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

davidandrews13 (4/4/2012)

---

i see. i guess i'll just have to put up with it 🙂 thanks anway!

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

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

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

jamie.worsley (4/4/2012)

---

Thanks for the answers. Another HD died, raid 5 can't work after 2 drive failures. The sql error had been happening since xmas this year, not sure if...

Sean Lange (4/4/2012)

---

Lynn Pettis (4/4/2012)

---

capn.hector (4/4/2012)

---

i always like the ones that thank my post count level thingy...

Or when they address...

jamie.worsley (3/6/2012)

---

Hi, am new to SQL server. We recently had a drive failure on on of our SQL servers. SQLdump kept on putting out a backup file, each...

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

Brandie Tarvin (4/4/2012)

---

I'm stealing these name spellings for a story. @=)

You guys wanna be villains, heroes, or...

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

Me too.

The SSIS Send Mail Task uses SMTP for semding emails. I haven't used it but it should be fairly stable to use.

Welsh Corgi (3/30/2012)

---

I'm converting data from a legacy system to a new system.

There are codes and descriptions but in the legacy system in many instances there not be a code...

Reported as spam.