SQL Server could really use a TRANSFORM operator

[John Morrison]

Sometimes it would really be handy to have an easy way of doing a crosstab
in T-SQL without resorting to convoluted stored procedures or a long series
of subselects. Why can't we have something like a TRANSFORM in SQL Server?

John M.

[Michael Levy]

What is the TRANSFORM function that you're referring to do? Maybe there's a
compliment within TSQL.

-Mike
--
Michael Levy MCSD, MCDBA, MCT
Consultant
GA Sullivan
michaell@gasullivan.com

[John Morrison]

"Michael Levy" <michaell@gasullivan.com> wrote:
>What is the TRANSFORM function that you're referring to do? Maybe there's
a
>compliment within TSQL.

It's an Access function. I've long wondered why Microsoft saw fit to put
it in Access, but not in T-SQL.

John

[Michael Levy]

I looked through the Access docs and the only reference was to a Transform
statement that created cross-tabs. Is this what you're referring to?

-Mike
--
Michael Levy MCSD, MCDBA, MCT
Consultant
GA Sullivan
michaell@gasullivan.com