Duplicate post. Please post responses here: http://www.sqlservercentral.com/Forums/Topic1207598-392-1.aspx

Please don't cross-post. It fragments the discussion.

Drew

terryshamir (11/17/2011)

---

The reporting software is Excel. the people using do not have the skills (neither do I or do I want to learn) to do a pivot table but most...

Cadavre (11/17/2011)

---

PRINT '========== Alternative=========='

SELECT @Holder = randomDate + randomTime

FROM #testEnvironment

PRINT '========== Alternative 2=========='

SELECT @Holder = DATEADD(SECOND, DATEDIFF(SECOND, 0, randomTime), randomDate)

FROM #testEnvironment

PRINT '========== Alternative 3=========='

SELECT @Holder = DATEADD(d, DATEDIFF(d, randomTime, randomDate),...

You're probably better off leaving the pivot to your reporting software. You don't provide enough details to say for sure.

Drew

It has been repeatedly shown that manipulating dates by converting back and forth between character data performs very poorly versus using the datetime functions. The following code will always...

The .value() function requires a singleton, and you may not have specified the singleton correctly.

Drew

The best way is to avoid using a cursor in the first place. They perform horribly...

CELKO (11/16/2011)

---

SQL is declarative, so we do this stuff in the DDL, not in fake mag tapes. The number of suffixes is constant and short, so put it in a...

You're most of the way there. This should give you what you want. The vast majority of the time, you'll probably want to use relative paths for everything...

Your data doesn't have enough information to fully specify the order, so the order is not completely guaranteed. For example 17 could easily render as "Riding on big horses...

You really don't. There is nothing in your query that indicates that a...

Actually, as Jeff Moden...

A good rule of thumb to use is that you should not use code that you find on the Internet unless you understand what it is doing. If a...

I would argue that he's doing the...

It's because your '<B>' is text, not xml. The easiest way is to use the following:

select

= convert(varchar(3), t.num),'',

...