March 13, 2008 at 1:46 am
Dear All
i develop a asp.net aplication for the company suggestions suggestion are assosiated with departments
like
1, A
2, B
3, C
4, D
5,E
i stord data in suggestion table for suggestion are good for which which departments with "," seprated values
like
1,2
1
3
4,5
2,3
1,2,5
2,5
1,4
now im working on report use SQL Reproting
i have a prb if i want to see all those Records belongs to department A
correct result is
1,2
1
1,2,5
1,4
but my query return only
one result that is
1
what can i do
any idea how to slove this prb
thanks in advance
Ahmer Ali
March 13, 2008 at 5:00 am
Hi,
What have you used cursor and split function for this work, if not then use both of these and get your result. I m sure that it will give result of your problem.
Regards
Sarvesh kumar gupta 😎
March 13, 2008 at 6:58 am
The whole idea of using SQL Server as relational storage engine is to not store things in a comma seperated field. You're going to have problems with that. Instead it should have been stored as a series of rows associated to the correct foreign key. Then you can run a report.
To really get help, you'll have to post the SQL query that you're running. Also, show the structure that you've created so that anyone attempting to help doesn't have to guess.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply