Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query help - manipulating one table

Author  Topic 

talkaspx
Starting Member

3 Posts

Posted - 2005-08-29 : 19:54:06
Dear all,
I am building a query from just a single table and would really appreciate any help. Thanks in advance.

Table A
-------
ID#Value#Group
---------------
1#Value1#Grp1
2#Value2#Grp2

INTO a temp table

Temp table
-----------
ID#Value
--------
1#Value1-Grp1
2#Value1-Grp2
3#Value2-Grp1
4#Value2-Grp2

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-30 : 01:03:37
Well. What is your question?
Do you want to compare two tables or copy the result from one to other?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -