Viewing 15 posts - 56,881 through 56,895 (of 59,067 total)
The service pack notation revers to Windows.... you have SP4 (8.00.2039) on SQL Server.
There is no bug that does this... it's a setting. SQL Server 2005 is setup for CONCATENATE...
February 20, 2007 at 7:44 pm
The answer is because you are doing the rounding first and then taking the sum.
By the way... the first letter of SQL stands for "Structured"... you might want to apply...
February 20, 2007 at 7:38 pm
And what would you like to display if all 3 amounts are <= 0 ?
February 20, 2007 at 7:32 pm
Why can't you or don't you want to use SET ROWCOUNT @MaxRows???
February 20, 2007 at 7:29 pm
Ummmm.... I gotta know.... WHY are you trying to do this in a script?
February 20, 2007 at 7:20 pm
Heh... at least it sounds the same... I've been called worse ![]()
February 20, 2007 at 7:15 pm
Another place to look is under "Expanding Hierarchies" in Books OnLine...
February 20, 2007 at 7:07 am
Sure there is... is Table "A" the only table you need to draw from? Also, can you type up an example of what you'd like the output to look like?
February 20, 2007 at 7:05 am
You said there was a correlation between a long running query and the slow down... fix the QUERY. Long running queries are usually IO and CPU hogs. Fix it before...
February 19, 2007 at 5:13 pm
Sounds a lot like homework... What have you tried?
February 19, 2007 at 5:07 pm
Maybe I'm just missing it... what does the output you listed have to do with the query you listed?
February 19, 2007 at 5:05 pm
The problem with such "real time" apps is that no one plans on the connection being down
Have your "trigger" write to a...
February 19, 2007 at 5:02 pm
Kind of a double post... please see my other reply.
February 19, 2007 at 4:55 pm
Don't embed the quotes... put the quotes around each full path.
February 19, 2007 at 4:54 pm
Oh no, no, no... MJV had it right and ISNUMERIC does NOT mean ISALLDIGITS!
create table #tmp( tc VARCHAR(10))
insert into #tmp
select '0d01' union all
select '0e01' union all
select...
February 19, 2007 at 4:33 pm
Viewing 15 posts - 56,881 through 56,895 (of 59,067 total)