SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 cross tab problem?
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 02/08/2005 :  07:54:55  Show Profile  Visit AskSQLTeam's Homepage
shay writes "Hi i have a view structured something like this :

id catname productname

1 aa prod1
1 bb prod2
1 aa prod1
1 bb prod2
2 cc prod3
2 dd prod4
2 cc prod3
2 dd prod4

i need to insert to another table and do string manipulation on each value, i do not know the number of columns ,all values need
to go in to one target colume so the result will look like this :

id data
1 XXaa XXbb >>prod1 >>prod2
2 XXcc XXdd >>prod3 >>prod4

etc

what is the best way to approach this? i searched around and found that this structurew is a cross-tab structure. is it? and if so how can i make it happen.
currently i am using a complicated code with cursurs that does ont realy work
and i feel is not in the right direction i hope there is a knowen solution
for this problem

thanks,

shay cohen"
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000