Viewing 15 posts - 361 through 375 (of 621 total)
Well that's just what I was going to say:) However, a viral infection in my throat made me miss work. Thanks Seth.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 29, 2009 at 5:53 pm
Try this
CREATE VIEW MAX_EXPIRATION AS
SELECT
t1.ID,
t1.MaxExpirationDate,
m.MemberGroup
FROM member m,
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 28, 2009 at 8:16 am
Ok, I'm fairly certain its the NOT IN clause that is the hog. Mainly because it shows the code in the hover box that pops up in the execution...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 27, 2009 at 7:36 am
Try this
http://www.sqlservercentral.com/articles/T-SQL/63681/
It should answer most of your questions.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
January 13, 2009 at 1:14 pm
Jeff, I lost quite a few brain cells on this one, as it was just a bit over my head, and would be interested to see your solution, using...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 24, 2008 at 9:11 am
Garadin (12/22/2008)
Please provide sample data and table structure. Displaying data *vertically* is not normally an issue, as that's how tables are usually constructed in the first place.
It seems like...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 22, 2008 at 9:39 am
Why can't you run the parts of the procedure up to the point the temp table is created and populated, then do a SELECT * from the temp table?
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
December 17, 2008 at 2:24 pm
I think they need to start a section for 'Best humor of the day', or maybe month. I gotta say, I'm not sure where I laughed harder...at this post,...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 4, 2008 at 12:27 pm
Garadin (11/3/2008)
Trying... to... resist...Gah.
Seth, I was rolling laughing at that. I'm a huge Dilbert fan, so any time I see 'Gah', it elicits strong images of Dilbert struggling against...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
November 3, 2008 at 2:19 pm
juergen, this will give you what you want based on your sample data.
SELECT
from_idnr = MIN(idnr),
to_idnr = MAX(idnr),
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 30, 2008 at 7:39 am
Shree, I tried a direct copy and paste of your code, commented out the WHERE clause, and the result was as follows:
ABC12344
DEF45677
GHI89010
When you say "print", what exactly do you mean?...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 29, 2008 at 8:34 pm
Try ISNULL(S.Sales,0) in the SELECT.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 29, 2008 at 2:22 pm
phillip.hess (10/29/2008)
I don't mind reading, I just need point in the right direction.Thanks
-Phillip
Check out 'Expanding hierarchies' in Books Online. If you mess around with the example you might have...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 29, 2008 at 2:20 pm
Seth
Thank you so much for the time and thought you put into this. I tested it against a production table, and it purred like a kitten. It never...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 29, 2008 at 6:30 am
Jeff Moden (10/28/2008)
Greg Snidow (10/28/2008)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 28, 2008 at 10:33 pm
Viewing 15 posts - 361 through 375 (of 621 total)