Gail,

After reading your reply I thought that it might be because of table variables as you said but interestingly, its the same using the permanent tables also.

>>Just be careful...

Gail, Good to know. Then whats the reasoning behind the differences in logical reads for the 3 plans.

--Orig

(2 row(s) affected)

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0,...

In the below mentioned version, your code snippet worked just fine. Which version are you using?

Microsoft SQL Server 2005 - 9.00.3282.00 (X64)

Aug 5 2008 00:48:00

Copyright (c) 1988-2005...

Jeff, point taken. I will avoid that next time. I was just demonstrating a technique.

Gail is correct and just to complement what she said, avoid using correlated subqueries if you can solve the problem with a simpler join.

In Correlated subquery, inner query is executed...

Jeff is right. If the data set is large then you are better off with Numbers table approach. But if you are doing small data sets or just a variable...

There are no built-in SQL server functions that handle this. You have to write this yourself although this problem has been solved in many ways as Chris pointed out earlier.

--Creates...

I don't have BI studio handy to test but here is what I can come up with.

=iif (FORMAT(Fields!DueDate.Value,"d MMM yy") = "6 Jun 79", "TBA", FORMAT(Fields!DueDate.Value,"d MMM yy"))

Also on a...

Set based solutions tend to be faster than the RBAR operations while taking less system resources. Doing a task 100 times is much likely to take more time than doing...

Have you looked at the Database Publishing wizard?

Hello,

SQL Server Express edition service pack 3 is not just another SP but an actual upgrade. Even if you run the .exe, it will reinstall not just apply SP3.

Although SQL 2K5 has robust built-in email support via Database mail, its not available in Express edition. You have to use CDOSYS to make it work for Express edition. SQL...

It helps to know if this is occuring in SQL 2K5 or SQL 2K8?

You could try using one of the mentioned tools (http://www.karaszi.com/SQLServer/info_generate_script.asp) to transfer the data. I prefer using the Database publishing wizard.

You can use this script to get all the objects in a specified schema and loop thru to update the statistics.

select * from sys.objects o join sys.schemas s

on o.schema_id=s.schema_id

join sys.indexes...