Can someone give me some direction on how to retrieve records with multiple Unique Identifiers? Additionally, it checks if the records come back with a match, if not, set value to 0.
select sortno from toys where tid IN (@tid)
Within that statement, it would display sort number, but if there's no matching tid then it'll set the sortno value to 0.
Another question, it's not directly related to SQL. From the middle end, say ASP.NET, I'm trying to submit the unique identifiers into the query above through IN operator. but because, it's a uniqueidentifier, i can't add additional single quotes to it to retrieve the records. Does anyone know how I would submit the unique identifiers into the query to retrieve the records from the middle end? Thanks.