Viewing 12 posts - 2,431 through 2,443 (of 2,443 total)
Try
Select {col1, Col2, ...Coln} From {Table}
Where Department+col1 <> '3A'
AND Department+col2 <> '2B'
AND Department+col3 NOT IN ('2C','3C')
See if that makes any difference.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 24, 2008 at 6:12 am
Revision: "i think any manager WORTH HIS SALARY would quickly pick out who was genuine and who wasn't." Those managers that are not would be the reason for your second...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 23, 2008 at 6:21 am
Thanks guys, it's always something simple. As for why use the quotes, that's because of an ID-10-t error.
At least I'm not nuts, just sloppy.
Thanks again!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 21, 2008 at 8:22 am
I think this will work, if I understand what you're doing correctly - using Ryan's example, modify the assignment of @s-2 to be something like this:
DECLARE @maxrows int, @row int
SET...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
April 21, 2008 at 7:36 am
Steve, I have to say that I disagree about the personality type in your article not being promotable simply because they wish to contain work to worktime. This may be...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 28, 2008 at 9:57 pm
The point isn't to let you not argue, it's to let you argue constructively, since you understand how best to get your point across to the other personality types.
Or,...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 28, 2008 at 9:52 pm
Andy, have to concur with the group. Great article! I moved from a supervisory position into a reporting role using SQL, due to a new dept forming. Although I...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 18, 2008 at 10:09 pm
Chris Morris (2/6/2008)
jcrawf02 (2/6/2008)
Because we just have to be different. I'm going to go get my 'twelve barley-corns, round and dried' to measure something now . . .
Nah, pretty...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 6, 2008 at 8:31 am
Because we just have to be different. I'm going to go get my 'twelve barley-corns, round and dried' to measure something now . . .
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 6, 2008 at 8:02 am
I understand the datatype of DATETIME, but thought the point was to truncate the value to just the date, and not give me 00:00:00 at the end. I'm not...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 6, 2008 at 8:00 am
why am I getting times in the result for all of these, when I want only the date portion?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
February 6, 2008 at 7:09 am
Newbie of a newbie here, I'm working on a web development degree, so not close to being a dba or anything, but wanted to hang out around people who know...
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
January 29, 2008 at 5:36 pm
Viewing 12 posts - 2,431 through 2,443 (of 2,443 total)