Viewing 15 posts - 2,116 through 2,130 (of 2,894 total)
The answer is possible after:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 23, 2012 at 3:06 am
Happy to help!
As I've advised in the previous post, it is a good idea to have a table of all (reasonable) dates (usually called date dimension in datawarehouses) in the...
February 22, 2012 at 7:03 am
L' Eomot Inversé (2/21/2012)
... Is that "duh" at the end "spirit" (???)?
It is exactly.
The line I've used (with a bit of relevant change :hehe:), is from very well...
February 21, 2012 at 5:13 pm
Phil Parkin (2/21/2012)
..
It's also about the only thing I'll ever call people out on in this forum, because I generally know less than them about SQL Server!
...
Don't be so harsh...
February 21, 2012 at 10:27 am
LINKING90 (2/21/2012)
...This is the error I get
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...
Check the forum name: It's...
February 21, 2012 at 10:24 am
It's straight forward. Never had any issues with.
February 21, 2012 at 9:48 am
SELECT SubjectOfOccurance
,CountOfCondition1 = SUM(CASE WHEN Condition 1 Met THEN 1 ELSE 0 END)
...
February 21, 2012 at 9:45 am
try this:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
should help to get the most relevant answer in minutes.
February 21, 2012 at 9:37 am
LINKING90 (2/21/2012)
I tried to simplify the problem into a table but this is my actual query where I am stuck:
select numInterested = (count(u.user_id)
...
February 21, 2012 at 9:33 am
Why do you resist to adding this column to the query itself?
February 21, 2012 at 8:49 am
Sean Lange (2/21/2012)
...I can't for the life of me come up with a valid reason why you would want a stored procedure to create and drop triggers.
I try:
In case of...
February 21, 2012 at 8:03 am
I guess the main strating point as per previous reply is:
1- Build your own lab - a.k.a. install SQL Server Developer Edition on a home computer.
... or your...
February 21, 2012 at 7:42 am
Just tried to be formal and not payed enough attention...
Could do just with:
"Now the question is, what OP really wants?"
Looks like we can re-name the forum to "English Grammar" :hehe:
I...
February 21, 2012 at 6:58 am
Viewing 15 posts - 2,116 through 2,130 (of 2,894 total)