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)
 search page

Author  Topic 

dass05555
Yak Posting Veteran

55 Posts

Posted - 2008-03-19 : 07:49:00
dear gurus,

I need a stored procedures for single table ,for search operation.

table 1
--------
A |B |C
--------
1 |2 |1
2 |2 |1
3 |2 |2
4 |2 |3


i want retrive the data in any combination
like
1.A,
2.B,
3.C,
4.AB,
5.BC,
6.CA,
7.ABC



thanks in advance

dass

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-19 : 08:06:06
i'm sure i can't be the only person that has read your post and can make no sense at all of what you're after?
what do you mean by "data in any combination"? the sample result you've given just doesn't make any sense to me

Em
Go to Top of Page
   

- Advertisement -