Friday

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? ...

Heck no! I lost to Steve! 😛

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...

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...

We're coming into the home stretch. Anyone have any bold predictions for the next few weeks?

How about . . .