Viewing 15 posts - 2,236 through 2,250 (of 2,771 total)
You could probably get away with it in theory, but what happens when you start getting into complex table joins where you need to differentiate LEFT and RIGHT join? ...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 16, 2010 at 6:33 am
Steve Jones - Editor (9/14/2010)
Heck yeah, I won.
Heck no! I lost to Steve! 😛
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 14, 2010 at 4:15 pm
What Lutz and I are showing you are ways to convert your year/month (201008) into a datetime format that you can compare against other dates. That way, you can...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 14, 2010 at 7:51 am
Try:declare @Date varchar(10)
set @Date = '201008'
select cast(right(@Date,2) + '/01/' + left(@Date,4) as datetime)
Edit: I missed this part:
I have one column in table table1 that has period month of integer...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 13, 2010 at 10:56 am
We're coming into the home stretch. Anyone have any bold predictions for the next few weeks?
How about . . .
The Rockies overtake both the Padres and Giants to win...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 13, 2010 at 10:50 am
tosscrosby (8/27/2010)
I'll show you what I consider our best and if/when I get out your way, you can reciprocate.
Not sure whether or not you got the email...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 13, 2010 at 10:42 am
Wow. I leave The Thread for a little over a week, and look at what I miss!
BTW, as the M*A*S*H-aholic that I am, I recognized the lyric right away!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 13, 2010 at 10:31 am
WOTD: I'm ba-ack!
What'd I miss?
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 13, 2010 at 7:22 am
Ray K (9/1/2010)
Ray K (8/31/2010)
Ray K (8/30/2010)
Three!!!(Days 'til I leave for vacation!)
Two! II!!! 2!! Deuce!!! 10 (in binary)!!!
One! One! One! One!!!
Getting ready to...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 2:57 pm
After reading his clarification, it makes more sense. If planned properly, good DR shouldn't have unnecessary costs and wasted hardware. On that point, I will not argue.
(To the...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 9:35 am
CirquedeSQLeil (9/1/2010)
Cats in the Cradle
. . . and the silver spoon . . .
(Now I have Harry Chapin stuck in my head!)
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 9:24 am
Brandie Tarvin (9/1/2010)
alen teplitsky (9/1/2010)
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 9:20 am
sing4you (9/1/2010)
dbowlin (9/1/2010)
Ray K (9/1/2010)
Brandie Tarvin (9/1/2010)
Today's word: FilibusterGhostbuster
Who ya gonna call?
What did you do Ray?
Are you the key master?
The end of the world as we know it, real wrath...
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 8:23 am
Brandie Tarvin (9/1/2010)
Today's word: Filibuster
Ghostbuster
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 7:20 am
Ray K (8/31/2010)
Ray K (8/30/2010)
Three!!!(Days 'til I leave for vacation!)
Two! II!!! 2!! Deuce!!! 10 (in binary)!!!
One! One! One! One!!!
+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/
September 1, 2010 at 7:20 am
Viewing 15 posts - 2,236 through 2,250 (of 2,771 total)