Funny. I didn't chime in on that one, but I have heard people claim that indexing every column was the way to go because "it keeps the...

SACRILEGE!! HERESY!! CURSORS!! :w00t::w00t:

Good eye, Howard.

I think that may be looking at a terminology difference, Jeff. What you can't do (at least according to my reading) with a PIVOT table is...

I'm assuming their is a unique index or a constraint on MAIN_TABLE. If you have duplicate values for those two columns you have a problem....

If I understand you correctly, you want a column for each input date without having to specify the dates in advance, like excel will do. The...

BBQ diplomacy. You gotta love it.

Unless of course you're vegan.

I apologize to all fundamentalist vegans.

I think whoever hired Ms. Placas should be applauded for going above racism.

It took courage to make such a decision, knowing that a large segment of their...

sql-troubles (7/30/2010)

---

Sorry, I don't want to enter in any conflicts related to terminology (or of any type) as meaning is highly dependent on context, communities and is in continuous change....

though, as far I know, a dynamic script can't be run from an inline table-valued function because neither EXEC nor sp_executesql could be called from a SQL Server UDF of...

I haven't saved them, no. Some might be a year or more older. I'll see if I can search for a couple.

--------

Edited:

You can find...

What prevents dynamic SQL from either (A) making use of an existing inline table valued function, or (B) dynamically creating a subquery equivalent to the inline table valued function and...

Using sp_executeSQL, queries don't...

I've been out for weeks. Thanks for checking, Gail.

:crying:

Problem?

I see no problem.