ALZDBA (12/5/2011)

---

When you switch to the engine level compatibility (100):

- did you update all statistics

- did you perform dbcc updateusage

- did you perform full db maintenance

- did you run...

Lol you used it last, and I don't really remember posting...

i would disagree; you want to stay in the same datatypes whenever possible.

/*--results

09:00:50.9600000

09:00:00.0000000

*/

--SQL2008 has the new Time datatype as well as the...

SSIS is reading a text file, so yes, it's text until it's implicitly or explicitly converted to a specific datatype.

so if you had the SSIS task read the file and...

how are you importing? SSIS? BULK INSERT? are you importing to a staging table first?

I'm sure there's an explanation, we just gotta dig a little bit.

I'm still wondering how to implement this myself...if the Pk is a foreign key in the child table, won't the FK prevent you from changing the key to a new...

if an application is building SQL statements and executing them, then your database and it's objects could be version 9/10 compatible, but the commands create by the application may...

well, what you are asking is how to create an Excel document with multiple sheets; '

a CSV is actually a raw text file, which by default opens in Excel, which...

any chance teh report is returning results that create something like this, which would of course return no records?

WHERE (recordDateTime BETWEEN '2001-01-01' AND NULL)

if you are using parameters, you are making sure the datatype of the parameters are datetimes and...

mySQL does not support Common Table Expressions. SQL and Oracle do, and you asked ina SQL forum.

instead, you have to move the example into a named Alias...same thing, just...

Dev (12/5/2011)

---

SQL Server stores datetime in YYYY-MM-DD hh:mm:ss[.fractional seconds] format. Rest all the formats are result of cast / convert functions and added operation on t-sql.

CAST and CONVERT...

Paula here's an example i built for another post, I think it describes everything you are looking for.

the key is to apply a default schema to the users; then any...

i'm not sure why you wnat to loop; you could do the entire table in a single pass

something like htis:

SELECT ' Invalid data: record '

...

you have to join a Calendar table of some sort in order to generate your missing values.

Search here on SSC for Calendar Table or Tally Calendar.

If you can show us...