Viewing 7 posts - 31 through 37 (of 37 total)
How about this?
I
update part
set
USER_4 = cast(convert(money,unit_price,0)as varchar), -- save old price
unit_price = round((unit_price*1.05)/0.05,0)*0.05 -- increase price and round
where
unit_price is not null and -- exclude null value
unit_price <> 0...
June 17, 2008 at 1:55 pm
Andras Belokosztolszki (1/21/2008)
You could change your case statement like:
CASE
WHEN [myRow] = 1 THEN 'True'
WHEN [myRow] IS NULL THEN 'False'
ELSE 'FALSE'
END
Andras
I'm using MSSQL 2000
I get a syntax error when using...
June 13, 2008 at 1:36 pm
The reason we need the extra two gigs is because this server also has our ERP system runnning on it. I have not been able to sell the notion that we...
March 12, 2007 at 9:25 am
Will,
To answer your questions:
We have 2GB of memory on our DB server and are purchasing another 2GB today.
You can see how much memory sqlservr.exe is using by looking at the task...
March 9, 2007 at 7:47 am
Gentleman,
Your feedback on this issue is sincerely appreciated.
Being a generalist with responsibilities from resolving printer problems to developing business strategy and vision, I could not survive without you, and others like you willing to...
March 8, 2007 at 7:20 am
Collin,
I understand your frustration in regard to 'why doesn't this guy read the BOL?'. The problem is if you don't know the right question, reading/searching will/may be interesting but not...
March 7, 2007 at 4:20 pm
Viewing 7 posts - 31 through 37 (of 37 total)