General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
>I'd be tempted to consider keeping the codes in a table and just using a subquery for the condition. It would be pretty flexible, wouldn't have the limitations of a string and the subset of codes could be parameterized in whatever way necessary and the cursor used for the subquery.
>
It was already a table and I converted values to string first. I may just go straight with the table. For now I decided to just check directly against the codes in my code below the select statement.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only