Thanks Guru...I got my answer

Hi Arnold,

Why won't u trying the solution of Rosh (i.e. INNER JOIN)? It gives the same output as per your requirement.

Also, INNER JOIN is in general faster than other methods.

Seems it's better to lock the control table

Hi Adi,

Many thanks for ur reply. Actually its my mistake...instead of writing 2 MB , I have written 2 GB.

Really 2 GB is a big data size. We should...

Hi kshitij and John,

I have heard that 2GB is the size limitation of table variable, later it crushes.

Is it true?

Thanks in advance.

Hi John,

Thanks 4ur reply. I have gone through it. But my question is, there is a limitation of table variable reg. size. I want to know that threshhold size.

thanks again.

Hi,

You can also use

SELECT CAST ( '20081117' AS char(8))

HI Addai and Anirban,

Many thanks for your valued review.

Hi All,

I have seen this question created a lot of confusion. Here is a humble explanation.

My question was "'What are included columns in SQL Server 2008?"

There is no difference of...

Hi Sirish,

I think u need to create a cursor, check for each status against each student and update it.

Hi,

SQL server doesnot support arrays. Try to use temporary tables.

Hi Peter,

MS SQL Server 2005 has 5 editions.

1. Enterprise

2. Standard

3. Workgroup

4. Developer

5. Express

It entirely depends upon the business nature of your shop, which edition u ll use. You can go...

Hi Grant,

Thank you for your reply. I have checked the query plans. Both the query plans are same, cost also same. I think ur guess is right. But there is...

Hi Anirban,

Many thanks. I will try to dig more questions from the SQL mine.

Hi Carlo,

I have tested it several times in SQL Server 2000 and 2005. Every time, it gives NULL first. I guess that it shows the NULL first because NULL has...