WORKED ME GREAT REMI, THANKS

Even I don't have any idea Remi!

Actually this is for my friend and she told me that she is generating some reports. I tried to do it this way, but...

It worked me great, Thank you so much Lowell. When the time I was doing I didn't even think of any of the DBCCs.

Begin tran T1

If (Select count(*) from yourtable  where ColC  is null) = 0

Begin

update yourtable 

set ColA = (ColB + ColC + ColD)/3 

End

If (Select count(*) from yourtable  where ColC  is...

are you running the query with in a transaction? If you are, then make sure that you commit the transaction.

Changing the name of the variables can't be the reason. but you could always reduce the exec. time by using the Convert

Yes it is but when u supply the input parameters like @startdate as '2005-07-27', '2005/07/27' are in any other formats, the convert style 101 change it as '07/27/2005'. So it...

Hi MR,

The input parameters, which I have supplied aren't the VARCHARs,they are DATETIMEs. By using the convert function, and DATETIME style, you can supply any datetime format to the...

You could try this, should be faster too..

CREATE PROCEDURE StoredProc (@startDate datetime, @endDate datetime) AS

SET NOCOUNT ON

select * from orders

where convert(varchar(10),orderDate,101) between

convert(varchar(10),@startDate,101) and convert(varchar(10),@endDate,101)

Hi Russell,

If u c the query again, I didn't give any spaces between the quotes.

try this

update SSNtable

set SSN = replace(SSN, '-', '')

hope it should work

My mistake, I thought I mentioned.

Thanks for ur reply Anthony, but is it possible to copy 2 databases in to a single new database? Once I restore the new database with one of the existing...

thanks,

actually I had to copy two databases in to a new database so I just used DTS to export all the DB objects.

please c my updated post. actually thr was no need to declare a variable