Viewing 15 posts - 2,626 through 2,640 (of 2,769 total)
Ray K (1/26/2010)
Here's the sample data:create table #test1 (tdate date)
go
create table #test2 (fdate...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 3:04 pm
Jack Corbett (1/26/2010)
Ray K (1/26/2010)
Lynn Pettis (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
I cou'dn't resist in this one as the OP did not ask a question. 😎http://www.sqlservercentral.com/Forums/Topic853917-392-1.aspx?Update=1
Edit: Oops,...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 2:55 pm
Wow, three people posted samples simultaneously. That's gotta be some kind of record! 😀
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 2:36 pm
Okay -- for anyone trying to work on this, I've put together a quick 'n dirty test scenario.
Here's the sample data:create table #test1 (tdate date)
go
create table #test2 (fdate date)
go
insert into...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 2:31 pm
I understand what he wants. I'm just not entirely sure how to resolve it. I'm messing around with some ideas.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 2:18 pm
Lynn Pettis (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
Alvin Ramard (1/26/2010)
I cou'dn't resist in this one as the OP did not ask a question. 😎http://www.sqlservercentral.com/Forums/Topic853917-392-1.aspx?Update=1
Edit: Oops, I missed the "Pl...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 2:03 pm
I think I understand what you're looking for. Let me see if I understand this correctly . . .
Suppose you have a table, t1, that contains:2010-01-15
2010-01-13
2010-01-01
2010-01-11
And you have a...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 26, 2010 at 1:50 pm
Jeff Moden (1/21/2010)
Actually, a Cursor or While Loop is just what the doctor ordered here...
Who are you, and what have you done with Jeff Moden? 😀
(Sorry, couldn't resist!)
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 22, 2010 at 10:35 am
Markus (1/21/2010)
My brother loved Fenway for the old look but said the facililties leave alot to be desired.
. . . hence the reason why I said places, not ballparks! ...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 21, 2010 at 1:32 pm
This thread seems too quiet, so let me throw out some fodder . . .
Your opinion: what are the best and worst places to watch a game?
Note that I didn't...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 21, 2010 at 12:23 pm
Had a rehearsal last night with my community concert/symphonic band. (I'm the principal clarinetist and section leader.)
Any other symphonic musicians here?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 21, 2010 at 7:25 am
briogene (1/21/2010)
Thirty minutes a day will do...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 21, 2010 at 7:18 am
Add me to the angry chorus.
This is not a fair question. More detail is needed before we can give an honest answer.
I want my points back.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 21, 2010 at 7:11 am
norrisbiney (1/20/2010)
thanks for the prompt response. Where can i get the BOLs from.
BOL comes with SQL Server.
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 20, 2010 at 1:31 pm
A lot of people on these forums (myself included) will probably suggest that you get yourself acquainted with the documentation that comes with SQL (referred to as "Books Online," or...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
January 20, 2010 at 11:17 am
Viewing 15 posts - 2,626 through 2,640 (of 2,769 total)