Is it possible to use a dynamic WHERE IN clause LIKE
SELECT * FROM sometable WHERE ID in(@id)
Aug 03 '10 at 03:25 PM
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Aug 03 '10 at 03:25 PM
Seen: 709 times
Last Updated: Aug 03 '10 at 03:25 PM
How do I isolate a few characters to not show up in my results?
Looping without cursors
Cross tab data required
CASE STATEMENT USING MULTIPLE COLUMNS
Converting VBA Access Function to TSQL
Table Constraint - Unique value
Need to output a flat fixed-length file (some fields are COMP and COMP-3 format) with MS SQL 2008 TSQL for loading into mainframe
How to count based on multiple columns
Cast to decimal