tag:blogger.com,1999:blog-7411361293462314642012-02-16T14:38:04.818+08:00TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.comBlogger121100tag:blogger.com,1999:blog-741136129346231464.post-28929455238767461312008-09-03T21:56:00.002+08:002008-09-03T22:00:07.520+08:00

I didn’t write any post on my blog for quite long time. Today, I spend some times to write a post. Actually, this topic is saved in my draft for quite long also. :) And I received one topic from SQL Server Central which is same as my topic. We know last time that we cannot put conditional filter in where clause of T-SQL statements. But that’s not true that I find out one thing which can use

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com39tag:blogger.com,1999:blog-741136129346231464.post-23245781842231470472008-06-14T15:02:00.001+08:002008-06-14T15:03:50.900+08:00

I didn’t update my blog for quite long time. Today, let me share some knowledge on T-SQL Programming. Last time, I posted constant table. This time, I wanna post constant fields and joining 2 tables without having any relationship.  Interesting, right? Sometimes, our customer request to generate setup data for their promotion and discount. And that time, both their services or stocks table and

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-78842396564926263442008-05-01T22:50:00.002+08:002008-05-01T22:55:55.732+08:00

If you want to format result values in SQL, you can use the following methods:Let assume we have integer value variable.DECLARE @DataValue AS intSET @DataValue = 2and wanna format as '00002'There're 2 ways to format:SELECT REPLICATE('0', 5 - LEN(@DataValue)) + CAST(@DataValue AS VARCHAR(MAX))ORSELECT RIGHT('00000' + CAST(@DataValue AS VARCHAR(max)), 5)

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-42215709362023430022008-05-01T13:59:00.004+08:002008-05-01T14:03:20.768+08:00

This is also one of my question in Experts-Exchange forum. I wanna display row data to in a columnar format. I’ve one tables which include three columns such as Sr, StartDate and EndDate. I wanna display count of Sr group by month depending on the StartDate and the resulted format is as follow:Sr|Jan|Feb|Mar|..to..|DecThe solution for this problem is as follow:SELECT Sr, Jan = SUM(CASE WHEN MONTH

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-89688746559556101262008-05-01T13:44:00.001+08:002008-05-01T13:46:11.964+08:00

I haven’t updated my blog for quite long time. But today I’ve times to post some information related to the SQL query. When I prepare reports for one of the hospital in Myanmar, I’m facing some difficulties to display data and raised question in Experts-Exchange. This post is my re-collection of solutions from Experts-Exchange. And also thanks for the expert, angellll, who answer this solution

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-82736260149256835992008-04-11T21:57:00.007+08:002008-04-11T22:16:10.379+08:00

Because of the format problem, please see this article here. Sorry for this inconvenience. ;(

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-59793019998082066472008-03-29T17:19:00.001+08:002008-03-29T17:28:20.397+08:00

When we develop application, we need all the days from the month sometimes. We are thinking of the way to create StoreProcedure to generate days using temp table and cursor. But using cursor will slow down our application process and we want faster way to get all days. So we think of another way to create one table which store all the days from 1-Jan of current year to 31-Dec. That’s also not

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-53434429730343865392008-03-29T09:05:00.002+08:002008-03-29T09:15:11.052+08:00

In database development, sometimes we really need to display some constant data and don’t wanna let user change that constant data. But those data are not so many and don’t wanna create table. For this situation, we’ve one alternative way in SQL to create constant table. The trick is not so advanced but it’s really easy and we already know those statements. We just create one simple view using

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-11920938065544598102008-03-29T08:52:00.000+08:002008-03-29T09:01:50.991+08:00

Sometimes, we need to add serial number in our query result to show on the report. I’m not sure SQL 2000 has this feature or not but I never use that feature in SQL 2000. :D In SQL 2005, we’ve one function call ROW_NUMBER(). So we can display serial number in our query result. The example for that function is as follow:SELECT ROW_NUMBER() OVER(ORDER BY customername) FROM customer WHERE

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com1tag:blogger.com,1999:blog-741136129346231464.post-70133294599701426152008-03-28T21:45:00.000+08:002008-03-29T08:43:36.813+08:00

If you are boring on reading long text in my previous post, here’s some little text for you. Do you know how many data file type created from SQL 2005 after you created your database? You didn’t notice or forgot, right? If you didn’t create partition(s), there’re two files created which are .MDF file and .LDF file. .MDF for your primary data file and .LDF for your log file. If you created

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-55392038534855113192008-03-28T20:44:00.000+08:002008-03-29T08:04:02.902+08:00

I’m sure most of us are happy with wizards which Microsoft provide in SQL and forget what is happening behind the wizards. This is one example for our ignorance in SQL 2005. Normally we right-click on the database node in Enterprise Manager, click New Database, type the database name and click OK to create new database in 2005 Version. But we forget about options from the wizard and ignore what

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0tag:blogger.com,1999:blog-741136129346231464.post-23172110992159958482008-03-28T20:19:00.001+08:002008-03-29T09:21:46.671+08:00

I’ve created one blog called “My First Blog” which I posted some of jokes and information related to my personal life. But I also wanna create blog which support technical person and also note book for myself as in technical difficulties or some tricks. Actually, I’m not very good in technology that’s why finding tips and tricks from other developers from any web-site for my reference. While

TNT @ Albert Sunhttp://www.blogger.com/profile/11637752884132566512noreply@blogger.com0