I'm not sure if this helps the OP, besides the storage aspect of date types, the other thing to consider when using date literals is that there are ANSI, ISO,...

Slightly shorter to use the Function (truncate) of the ROUND function:CAST(ROUND(@D,1, 1) AS DECIMAL (18,1))

Here is another way for grins:declare @date datetime

set @date = '2011-11-08 21:30:00.000'

SELECT STUFF(LEFT('0' + CONVERT(VARCHAR(20), CAST(@date AS TIME(0)), 9), 11), 9, 0, ' ')

You can also avoid doubling-up your single quotes by using the CHAR function:SELECT 'don' + CHAR(39) +'t'

Burninator (9/23/2011)

---

I’m gonna go out on a limb here and disagree with all y’all. I work with address data extensively. I ceased to believe years ago that “we’ll...

The documentation issues aside, I think Drew is saying it's easy to run a test and see if supplying a style as any affect on conversion from string to date:SET...

Sorry I mis-read that as a table variable issue not a tabled valued function.

Can post the code? We might be able to help with some suggestions. If it's not...

Well there could be lots of reasons. Perhaps jsut change the table variable to a temp table well help?

Does this Help, this shows the First of the previous month and the Last day from 2 months ago:SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP) - 1, 0),

DATEADD(MONTH, DATEDIFF(MONTH, 0, CURRENT_TIMESTAMP) -...

I know the OP is asking about Truncating, but I would Disable (or drop) indexes first, then Truncate. The reason is that when you link the tasks in SSIS, people...

Probably should this kind of formatting in the front end, but if you must do this is sql, maybe this will help:SELECT

EmpCode,

MIN(ShiftDateTime),

...

Something like:DECLARE @Flag CHAR(1)

IF EXISTS (SELECT Col1 FROM table1 INTERSECT SELECT col2 from table2)

BEGIN

SET @Flag = 'Y'

END

EDIT: bah too slow. 🙂

Obviosuly, everything is SQL seems to be on a case-by-case basis. But, anytime you are using linked servers, you never know what the optimizer will do. I'm not sure if...

4-5 TB, is pretty trivial for a year's worth of data. Any decently architected cube set (SSAS) should be just fine. I'm alwasy skeptical of the latest buzz word, so...

Not the most effecient, but I think might work for what you are trying to do. If not, check out what Gail posted, so we can help you better:update

...