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),'',

...

It looks like you're trying to run this on a SQL 2005 server. MERGE was introduced in SQL 2008, so it will produce those exact errors when run on...

Even so, the performance may still be better using the string splitter than without. The only way to now for sure is thorough testing, which is why I initially...