How to get this Report ????? - SQL Server Forums

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

SQL Server Development (2000)

How to get this Report ?????

Author

Topic

Radhiga
Starting Member

35 Posts

Posted - 2006-04-17 : 08:50:56

Actully my requirment is something similar to the below..
Tbl_MyCable_service
sid Serviceno servicename
1 CableTV 111111
2 LandLine 222222
3 Mobile 333333
4 Games 444444

TblCustomers

cid cname Services
1 John Games
2 John CableTV
3 John Landline

Now i want to genereate the report like the below

SNo cname services
1 John 444444,111111,222222
to perform this im planning to use cursors...B'coz both the tables doesnt have any unique key..Based on the Services the customer has taken i need to generate the report.
if u have any suggestion guide me pls
thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-17 : 08:52:42

Refer this
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Madhivanan

Failing to plan is Planning to fail

a_r_satish
Yak Posting Veteran

84 Posts

Posted - 2006-04-18 : 00:05:10

Hi friend, please search once in this site before posting your querries...
There have been a lot of questions in the same manner in this forum itself.

satish.r
"Way to success is always under Construction"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources