sisiralek (10/24/2011)

---

Create the following table on TempDB, It will resolve the issue

CREATE TABLE [tempdb].[dbo].[sysutility_batch_time_internal] (

...

andrew.mckee (6/17/2013)

---

A simpler way to avoid "Select * " is to use "for xml path" to get columns:

SELECT 'CREATE VIEW ' + TABLE_SCHEMA + '.vw_' + TABLE_NAME + ' AS...

I replied to this QOTD quite early on but I have revisited it a few times due to the comment emails I get from it.

Never before have I seen so...

I am sorry to have to say that I did not like the wording of the question or the answers and I am surprised at myself for answering this question...

Long Live Bill Gates? - Tee hee!

I love Microsoft...

I think the title is misleading and a little unfair to the wonderful work Microsoft did with Merge (Despite its being 6 years after Oracle - poor show MS).

This is...

Wow Tom. Epic yet fantastic explanation of the inner working off this qotd.

Thanks very much for that. I thought it was interesting when I posted it but you really took...

I haven't tried this but i got it wrong (apparently). I don't think the proposers answer is correct though as SQL will terminate after 32 levels of nesting which...

-- In 2008 + you can use a date instead of a datetime with implicit conversion

DECLARE @Date date = GETDATE()

SELECT DATEADD(DAY, -DATEPART(dayofyear,@Date),@Date)

Ha Ha.:-P

Whilst others are being picky I thought I would add my bit.

None of the answers are right

When is New Years Eve anyway?

If its January 9th (as it is today) then...

In case anybody wonders, on a similar note...

Can table valued parameters be used in a function?.

.

.

.

Yes!

and they are very useful fo creating functions that take name-value-pairs

e.g.

CREATE TYPE [dbo].[AuditNVP] AS TABLE(

[Name]...

I love indexed views

Actually I hate indexed views

Actually I love indexed views

Actually I hate indexed views

Actually I love indexed views

Actually I hate indexed views

Actually I love indexed views

Actually I hate...

Yep - I thought that too but also do...

Great idea!

Dave