August 15, 2008 at 3:56 am
I want to find three records from a table which is a parent table.Many tables are foreign keyed with these tables.I want to search according to all the fields.Doing LIKE clause i have to check all the values from the database.
I have to pass somewhat 28 parameters to search the records.
These 28 parameters have many conditions like, one value may pass and all the others will be null and all the value may pass and so and so...
Will anyone help me an easy method to write the stored procedure and will be most thankful.
ThankYou
Shameer
August 15, 2008 at 7:05 am
I'm afraid I don't understand what you're asking. Can you clarify a bit, please? Perhaps the table structure, and your query as it currently exits, and what you want it to do.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2008 at 2:54 am
Can post your question with more clarification.. we didn't get you what exactly you want to do.
Abhijit - http://abhijitmore.wordpress.com
August 18, 2008 at 3:30 am
just my 2 ct.
Maybe this little thing can get you on track.
http://qa.sqlservercentral.com/scripts/Miscellaneous/31808/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply