Does having DDL statements in midst of DML statements affect the performance of the SP? Will it improve performance if i move these Truncate / Drop statements at the end...

Thanks Gail. I'll try that out. Also, there's another query in my first thread.

3) Is it good to truncate the temporary table in midst of the SP? (I'm truncating with...

The column on which the NCI is created, is being used in the WHERE conditions in the queries post this Index creation. How do I find whether this NCI is...

I also recently got this CPackage::LoadFromXML fails error message and was unable to open my package... few of the comments i found on the net was ,

1) Set...

Can you post the complete error message?

Also try to open the package from another system.

Thanks for the replies.

We've decided against using XML parameter mainly to avoid additional overhead to the application in buidling the XML tags and decoding them in the backend for every...

[font="Verdana"]

The problem occurred when we tried to restore SQL 2008 backup files in SQL 2005. Then we restored it in SQL 2008 server itself and it worked.

[/font]

Hi,

The issue was with the backup files. Got resolved now.

Thanks.

will do so in the future.

thank you for the reply.

Thanx for the response.. Most of the applications using this server are created with vb and asp(not .net). All are read committed.

thank you all for ur time and help. gr8!

i think you'll not be able to use getdate() function inside a UDF. try an alternative way to get the date and check it.

Nice article.

thanks much for that explanation.

thanks scott.

my scenario is like this...

i've two tables say tbl1 (empid, empname, deptno, yearofjoining) and tbl2 (empid, deptno, deptname).

i need to write the following query...

if the yearofjoining = '2006' then

select...