I came across a site where there is a programming task like below- Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which ar...

I came across a site where there is a programming task like below- Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which ar...

I came across a site where there is a programming task like below- Write a program that prints the numbers from 1 to 100. But for multiples of three print “Fizz” instead of the number and for the multiples of five print “Buzz”. For numbers which are m...

Thanks Jacob. Nicely explained. This is exactly what I was looking for...

Madhivanan, Regarding the point behavior of NULL values, when order by clause is present, I wanted to add that - In sql server NULL values (Unknown) is always treated as less than known values. So in case of asc NULL values comes first and in case ...

My blogpost - http://jeetendrasql.blogspot.in/...

This blog will explain how we can create separate columns out of a delimited (Pipeline or comma) values...

This blog will explain how we can create separate columns out of a delimited (Pipeline or comma) values...

Leonid, I have learned. Thanks a lot. It is one of a good technique...

My Answer to this is SELECT REVERSE(SUBSTRING(CAST(REVERSE(num) as varchar(max)), 1, CHARINDEX('0',REVERSE('0'+ cast(num as varchar(max))))-1)) from @t...