I could not understand the japanese words, so did a quick google transalate.

You are most welcome..:-)

Thanks Keith. My input date range table could look something like the below

IdStart_range ...

The start_range and end_range would vary based on input. May be I am unable to explain but for now creating a physical table would not solve the problem. Sorry about...

On the SQL Jobs links.. I am open for any location.

If you concentrating to gain only on the theoretical knowledge of SQL Server, I would say 12 month is good enough. But, becoming an MCSA is not only about memorizing...

Can anyone please explain about the error level 14 and 16. I am not able to understand this

Great article Nakul.

Another use of the Checksum is for the hash index creation. When indexes are created over nvarchar or varchar datat type columns, CHECKSUM() hashes the value. This...

Please check if you have the necessary permission to perform INSERT/UPDATE/DELETE operation on the target table.

That was a googly :w00t:

declare @color varchar(20)

set @color = ''

SELECT * FROm TBLCOLOR

Where color = coalesce(NULLIF(@color,''),color)

When no value is entered, the value passed would be ‘’ . And the NULLIF returns a NULL value...

You can use PIVOT function to convert rows into columns. Bt please bear in mind that the reverse is not true.

The ACID property is interesting if we hook it to the conventional Db management system. If I talk about Mobile Database systems, in SQL Server CE for a SELECT operation...

I agree to the article highlighted by you. The best example I can see i sme. Not long ago when I started my career into SQL Server it seemed like...

Easy one.. But when I think I do find OUTER JOINS to work outfaster than NOT IN, of course it depends, but I will bet on JOINS as compared to...

Thank you Dave for your reply, if it is 5,2 then it would be aftere 1,2. I think you have rightly pointed it should be like the parent-child query. I'm...