Stephen - can you not resolve this by setting defaults on b, c & d to zero and changing the formula to:

CASE (ColB + ColC + ColD)

...

You can do this:

select cast(c.Payrate * 100000 as int)

select cast(SUM(s.Hrs * c.Payrate) as money)

replace the apostrophe with 2 single quotes to indicate that it is a literal value...

insert into Countries (CountryCode, CountryName)

values (5, 'Cote D''Ivoire')

Minh Vu - the "600" you see is the default SQL Server setting - it is true that you can increase it to 1000 or even set it zero which...

So the row is not inserted at all - or the clientID is populated with the right value but all the other fields are null ?!

Is there a delete being...

I was reading the "update" and it brought back nostalgic memories of my first job which was in a small (really small) company of 25 people working on an e-commerce...

Arun - not sure if I understand the question correctly - is the insert and select being done on the same database object by the same person; on the same...

austin - check out these previous posts...one of them should help:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=195030#bm195033

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=168559#bm168562

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=203605#bm203673

anytime!

raj - why don't you start a new thread for this ?!

is the column a datetime one ?!

ask him to try "select * from user where date >= @date"...

oh - you're trying to concatenate the aliases....TC, let etc...that won't work...

don't have test data to test but try this:

select *,

case when contractretd = 0 then '-Terms & Conditions' else...

oh puhleez - i wouldn't dare compete with the likes of you, noel, remi, jesper, ray m etc. for votes - you guys are superlative - i just try very...

could you please post the query ?!

as noel or remi would say - hth!

how many rows do you get by doing a "select * from tempBets where matches = '4' and

mystery = '1'" ?!?!

Also you may have previous inserts in your winners...