Cross tab maybe not sure

[saintedmunds]

HI

I have a table with the following fields
Surname DivisionID FormID

What I need to be able to do is create a query/sp that gives me the following

FormID D1 D2 D3 D4
6 smith Jones blogs green
6 orange dog cat smart

Do i make any sense?
Any ideas would be great.

Cheers

 

[NuJoizey]

looks like a cross tab to me. I don't know sql well enough to post some code of the top of my head, and I am not sure if you can easily do Cross-tabs in MSSQL server - but if I were in that situation one 'guerilla' method I might try is to set up a simulation table in MSAccess (if you have it around) and use the grid or the wizard to create the cross-tab query as you want it, and then cut/paste the SQL code into MSSQL and see if it works.

 

[ca8msm]

The PIVOT command may be what you are looking for but it depends on your version of SQL Server.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[saintedmunds]

Hi
Thanks for your replies.
I have looked at crosstabs on the net but they all seem to need a Summaries column but I dont need this.

Does any one else have an answer to my question please.

Cheers