grin2dan

Hello All, I need to generate a simple script according to the following: "Using only one update write query to update a salary by 10% for salaries below 100k and 15% for salaries above 100k" TIA

I have a script written in Korn that hangs. Please see code below and advise. TIA [code] login as: dgrin dgrin@cbdp57009's password: Last unsuccessful login: Sat Jun 13 13:06:21 CDT 2009 on ssh from dbtrsqc1.chris topherandbanks.com Last login: Tue Jun 16 21:46:51 CDT 2009 on /dev/pts/0 from dbtrsqc1.christopher andbanks.com ******************************************************************************* …

Hello All, any code immediately following an 'N' is throwing an error. Please advise on why. TIA. [code] set @localized_string_AddRole_Failed = N'Failed adding the ''state_persistence_users'' role' DECLARE @ret int, @Error int IF NOT EXISTS( SELECT 1 FROM [dbo].[sysusers] WHERE name=N'state_persistence_users' and issqlrole=1 ) BEGIN EXEC @ret = sp_addrole N'state_persistence_users' SELECT …