Viewing 15 posts - 2,566 through 2,580 (of 6,036 total)
When you run any program it must be compiled first.
When SQL Server compiles your script without "GO" you table does not have that IDENTITY column yet, and compilation fails because...
April 2, 2009 at 8:53 pm
steve dassin (4/1/2009)
Ok. The new idea is actually an old idea that's never be tried. It's a relational system that most sql folks haven't gotten their head into and/or around....
April 1, 2009 at 11:11 pm
steve dassin (4/1/2009)
Thanks for bursting my balloon ;-)::-)Do you really think I'd be wasting my time if dataphor represented the same old, same old!:w00t:
somewhat best,
steve
You did not answer the question.
April 1, 2009 at 9:37 pm
steve dassin (4/1/2009)
Sergiy (3/30/2009)
Yeah, I know.All algorithms are built, all math tasks are solved, all music is writen, all paints are painted.
Universal excuse for mediocre for all times.
Well you seem...
April 1, 2009 at 7:29 pm
GSquared, correlated subquery is bad enough by itself, but 2 correlated subqueries in a single query - it's just a killer.
March 31, 2009 at 1:58 pm
Andrew Winch (3/31/2009)
March 31, 2009 at 4:36 am
mithun.gite (3/31/2009)
as per me avoid using cases in select stmt... and better u go with the union all option , i think i would have opted for union all as...
March 31, 2009 at 1:45 am
Andrew Winch (3/30/2009)
Sergiy (3/30/2009)
Why do you think so?Can you provide any logical grounds?
Jeeze, chill out!
I had a gut feeling or, to better define it, a SQL newbie opinion.
Sorry...
March 30, 2009 at 9:47 pm
Yeah, I know.
All algorithms are built, all math tasks are solved, all music is writen, all paints are painted.
Universal excuse for mediocre for all times.
March 30, 2009 at 5:36 pm
Andrew Winch (3/30/2009)
Personally I would think that the CASE would be faster but I could be wrong. 😉Thanks in advance
Andrew
Why do you think so?
Can you provide any logical grounds?
Try to...
March 30, 2009 at 3:02 pm
steve dassin (3/29/2009)
You're in the hall of fame, which one got you there?:-)
Neither. 😉
Would you consider the present fuster cluck of technologies the best IT can do? :w00t:
Apparently, yes.
While 90%...
March 30, 2009 at 2:23 pm
Add a fake table on top of your query:
select RootName, Name
from (select NULL as RootName) ROOT
INNER JOIN sysobjects ON xtype = 'U'
FOR XML AUTO, ELEMENTS
March 29, 2009 at 10:53 pm
There are 2 types of knowledge.
You may know everything about nothing or nothing about everything.
Universal tools are good, but there is a tiny problem: they don't really work for any...
March 28, 2009 at 3:33 pm
Try to find and eliminate all implicit conversions in your view.
They happen when you join tables by columns having not the same data type.
You may also create "temp tables" in...
March 23, 2009 at 5:44 pm
SQL33 (3/23/2009)
Select (case when (leavedate is null)then datediff (day,enterdate,[date])
else datediff (day,enterdate,leavedate) end as 'totaldays'
from reservations
produces
Incorrect syntax near the keyword 'as'.
Count your brackets.
select datediff (day,enterdate,coalesce(leavedate,[date])) as 'totaldays'
from reservations
produces the...
March 23, 2009 at 2:28 pm
Viewing 15 posts - 2,566 through 2,580 (of 6,036 total)