Re: Crosstab with SQL Backend Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

pete.trudell@xxxxxxxxxxxxxxx wrote:
On Oct 13, 6:28 pm, Lord Kelvan <the_idd...@xxxxxxxxxxx> wrote:
you can still build the same queries in access using an odbc
connection from sql server if this is what you are asking

Regards
Kelvan

Here is my TRANSFORM Code, which will not parse in SQL- errs out :

TRANSFORM COUNT(CType)
SELECT dbo.Login.LName, dbo.Login.FName, dbo.CallLog.CType,
dbo.Login.Team
FROM dbo.CallLog INNER JOIN dbo.Login ON dbo.CallLog.LO =
dbo.Login.StdLogonID
GROUP BY dbo.Login.LName, dbo.Login.FName, dbo.CallLog.CType,
dbo.Login.Team
ORDER BY dbo.Login.Team
PIVOT(CType) IN ([Claims], [Inquiry], [Tele-Serve])

I've tried different things to adjust this and still it will not
work.

No, you can only use JetSQL against Jet tables or linked tables. You
cannot, for instance, use TRANSFORM in a passthrough query: it's a
JetSQL keyword that does not exist in Transact-SQL. In order to use
TRANSFORM, you will need to use linked tables. Is the problem that you
don't know how to create linked tables? Access pretty much walks you
through the process ...

SQL 2005 does have new PIVOT functionality if you are using that
version. It, however, still does not use TRANSFORM.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: temp table troubles
    ... It's an ETL (Extract Transform Load) tool that ... transformations and load the results into a SQL Server table. ... And what transform Code? ... > string rapidly exceeds its 8000 varchar limit. ...
    (microsoft.public.sqlserver.programming)
  • Re: variable in transaction
    ... The problem will arise if you change the metadata for the transform. ... Global Variables and SQL statements in DTS ... If you expose it as the same column Name each time then you will not need to ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ...
    (microsoft.public.sqlserver.dts)
  • Re: Huge data needs to be transfer from Fixed width Text File to S
    ... 1- Transform the data, because I have to change data into Date and money from Char and I need to perform certain validation which is very hard to implement in TQSL as i am using SQL Server 2000. ... This can *really* save you time (and transaction logs size) on big data import operations, as it makes the DB log only the whole operation in the transaction logs, as opposed to logging every single row inserted. ...
    (microsoft.public.dotnet.framework.adonet)
  • Microsoft DTS help
    ... database in the SQL server 2000. ... There are different approaches in DTS for migrating: ... Is Data transform task sufficient for my purpose? ... Regarding creation of packages, ...
    (microsoft.public.sqlserver.dts)
  • Re: Pivot and Transform in SQL Server
    ... SQL Server doesn't have pivot or transform functionality natively. ... > [Sub Product Code], tblExpenseCodes., First ...
    (microsoft.public.sqlserver.programming)