Viewing 15 posts - 13,201 through 13,215 (of 26,486 total)
Quick question, why the CAST(@DateOnlyVariable as DATE) when @DateOnlyVariable is already declared as a DATE data type?
Observation, casting a DATETIME data type to a DATE datatype seems on the surface...
April 4, 2012 at 9:40 am
davidandrews13 (4/4/2012)
i was hoping to get it sorted like so:
footballs
footballStates
footballs_MLFlags
footballUnits
footballValidation
footballValidationStates
football_suspend
which is alphabetical from what i can...
April 4, 2012 at 9:32 am
No, you can't restore a backup from SQL Server 2008 R2 to SQL Server 2008.
You can use Copy Database to create SSIS packages to transfer the datbase from 2008R2 to...
April 4, 2012 at 9:26 am
Please realize that the backup failure and HDD failures are separate issues, they have NOTHING to do with each other. Yes, someone failed to notice a problem with the...
April 4, 2012 at 9:22 am
jamie.worsley (4/4/2012)
April 4, 2012 at 9:03 am
Sean Lange (4/4/2012)
Lynn Pettis (4/4/2012)
capn.hector (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
i always like the ones that thank my post count level thingy...
April 4, 2012 at 8:41 am
capn.hector (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
i always like the ones that thank my post count level thingy (ssc-whatever)
Or when they address...
April 4, 2012 at 8:29 am
jamie.worsley (3/6/2012)
April 4, 2012 at 8:18 am
When you were doing it manually, were always available to do the next step when the current step completed or were there delays do yo other work going on at...
April 4, 2012 at 8:11 am
Brandie Tarvin (4/4/2012)
Lynn Pettis (4/4/2012)
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
I'm stealing these name spellings for a story. @=)
You guys wanna be villains, heroes, or...
April 4, 2012 at 8:07 am
I think this is what the OP is after:
select
case when refcode like 'C[0-9][0-9][0-9][0-9][0-9][0-9][0-9]' then 1
when refcode like...
April 4, 2012 at 8:03 am
GilaMonster (4/4/2012)
A new misspelling for my records...Thank you Linn and Gylla
Me too.
April 4, 2012 at 7:47 am
The SSIS Send Mail Task uses SMTP for semding emails. I haven't used it but it should be fairly stable to use.
April 3, 2012 at 9:04 pm
Welsh Corgi (3/30/2012)
There are codes and descriptions but in the legacy system in many instances there not be a code...
April 3, 2012 at 9:00 pm
Viewing 15 posts - 13,201 through 13,215 (of 26,486 total)