Re: how to join dynamic SQL results with another query

--CELKO-- (jcelko212@xxxxxxxxxxxxx) writes:
Have you thought about BASICS? First of all there is no such thing as
a "pivot query"; look at the defintion of a query. This term is
Microsoft crap.

Joe: this group is devoted to Microsoft crap. Think about the BASICS
before you spew on your keyboard.

Dynamic SQL says that you are a realllly baaad SQL programmer with a
realllly baad schema.

No, it says in this case that the relational model that SQL is built
on for good or bad has a shortcoming in that it cannot address the
common need for an output there the columns is based on the data.

Your approach is totally wrong and will mess up your company; but you
will get kludges on line that will give you enough time to update your
resume. Since I have
3 decades cleaning this stuff, I should be happy.

If you go on like this I can sooner or later put "three decades
of cleaning up after Joe Celko's posts in the newsgroups" on my CV.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Active Directory vs SqlServer which way to go?
    ... Why not just create a simple mapping between groups and application-specific ... roles and store it in SQL or web.config or whatever? ... That is essentially what AzMan is about, ... > Thx Joe for the response. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Is There a Better Way? (Incrementing PK Column)
    ... Joe, a pleasure to be "schooled" by the expert. ... I've read your SQL ... so I ended up putting a trigger on the ... It would sequence ...
    (microsoft.public.sqlserver.programming)
  • Re: Please help : System.Data.OleDb.OleDbException: Syntax error i
    ... Also Joe, be careful of using Date as a column name as well, I know you didn't use it here but I had to find out the hard way. ... They could easily put in malicious SQL for one of those values. ... The SQL string looks fine because I pasted the ... >> Dim objDataReader as OledbDataReader ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Drive Space Problem
    ... Tibor Karaszi, SQL Server MVP ... "Joe G" wrote in message ... > We have a 2003 server used for sql databases. ...
    (microsoft.public.sqlserver.server)