Hello Luis, I did understand your point and I also want to add that the use of a variable was just at the beginning of the stored procedure, and that...

That is correct too. I am aware now that SQL 2012, which is the version I am using, supports IIF expression.

Thank you Drew.

Thank you Luis C.

I tried to do the following down below, but it is not working since it returns nothing:

/*

EXEC Test_String 'VQAL1-SQ994.1'

*/

Stored Procedure contents:

ALTER PROCEDURE [dbo].[Test_String] (@ProductID VARCHAR(25))

AS

BEGIN

DECLARE...

Thank you for your solution Luis.

I have a question. I need to replace the VB code with SQL and put it in a stored procedure that will take in...

The current output record for type Cash Management Services and sub type One Card is the one actual record, all the other records for type Cash Management Services, are a...

I changed my original query to use 23:59:59, and that also gave me the missing record back.

How would I need to change the query in order to be able and use a date format like MM/DD/YYYY?

Many thanks.

This did the trick for me:

The date will come...

I think this is the right way?:

UPDATE a

SET [Talks] = b.found_talks_type

FROM [dbo].[mp_sessions_teamcouples] a

INNER JOIN @Find_Missing_Talks b

ON a.sessionid = b.sessionid

AND a.coupleid = b.coupleid

Hi.

I am not an expert, but do you need to use the single quotes around the column names in your case expression?

Good luck 🙂

Thank you guys. Both solutions gave me clarity to where I was making a mistake.

I am adding some test data. I hope this helps.

I need to be able to group by each item

Something like:

current sales quote current...