Here is the weired thing i observed, am not sure how sql server is reacting.

If i ran the whole query it takes around an hour but when login as another...

but i see a lot of diffrence when i run step by step.

is there a way i can do it automatically instead of running each step manually.

but i think that is the created date.

I am getting all NULL values when i execute that query by giveing the databasename.

If i run this each step individually it takes around 50min for whole process but if i run all at once it is taking for ever.

guys..whats your suggestions.

How many rows are are in "dbo.EmpAdmin" table? I am concerned about the time it is taking you to complete this; and how it is being...

the same query again tempdb growed to 1 TB and i have to restart the service. can i restrict the growth from unrestricted to like 400GB? does it solve the...

Ok, i understand everyone may not be able to see the atatched file and so am copying here.

drop table #Temp1

select distinct *,'1/1/2005' as EmptYear

,case

...

please see the query attached.

thanks

from select @@version

Microsoft SQL Server 2005 - 9.00.1399.06 (X64)

Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 5.2...

SQLServer2005SP3-KB955706-IA64-ENU.exe

SQLServer2005SP3-KB955706-x64-ENU.exe

SQLServer2005SP3-KB955706-x86-ENU.exe

out of hte 3 files how do i choose most appropriate for my server.

once installed does the server need reboot?

how safe is this installation and are there any precautions to be taken.

thanks

can i update sp3 directly without sp1,sp2.

thanks

Jeff

Probably 1 hr for each step.

thanks

As we know CONVERT and CAST has similar functionality but which one wud be best? and is there any diffrence between them.

Also how would i change a data type "...

As you said can the 'pseudo value' be null? hoes does it " NULL" effect in joins or unions.

thanks