Click here to Skip to main content
16,022,060 members

Comments by Vishal0903 (Top 5 by date)

Vishal0903 9-Sep-20 5:29am View    
I am using SQL 2012
Vishal0903 8-Sep-20 4:19am View    
Yes, this is how I am expecting

Based on this Output there are many other steps to be performed - So, handling in C# or VB.Net would be still more difficult
Vishal0903 8-Sep-20 4:14am View    
The records may or may not be present in the table - Only after querying the table, I will be able to know if the value exists
Vishal0903 8-Sep-20 4:13am View    
Logical OR when Same Type has 2 values
AND
Logical AND when Different Type is present

T1,123|T2,BC|T1,456

Ex - (123 OR 456) AND (BC)
Vishal0903 8-Sep-20 3:55am View    
If I pass "DECLARE @SPInput varchar(150) = 'T1,123|T2,BC|T1,456'"

It should not return any result - As my final Output is T1 and T2

but T2 -> BC is not present in my table

This query almost works, but except for AND - Can you please help with this?