December 28, 2011 at 7:25 am
Here is the challenge. You mention four search criteria:
Well, i am creating a search form for emp details where the emp details are filtered based on four conditions
1. unit
2. department
3. Section and
4. Employee no.
Of those four criteria the only one I can figure out is emp no. The other three are totally unclear what columns these belong too. Since you are doing a catch all search form you should take a look at Gail's article[/url] on catch-all queries.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
December 28, 2011 at 11:09 am
Million of thanks for every body who helped me in learning CTE and achieving task. I have created function for this and used in procedure.
[font="Tahoma"]Million of thanks for everybody once again[/font]
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply