you need function to split the comma separated values.

check for fnSplit.

I faced this situation once few years back. I deleted all Windows groups and turned the Authentication Mode to Windows Authentication in the same session. Then I closed the connection,...

Why to save filters in separate table. You should be having a strong reason to do so.

You always have a choice to get Criteria from front end in varchar and...

Glad.

Enjoy.

Hello,

SELECT

ERROR_NUMBER() AS ErrorNumber,

ERROR_SEVERITY() AS ErrorSeverity,

ERROR_STATE() AS ErrorState,

ERROR_LINE() AS ErrorLine,

ERROR_PROCEDURE() AS ErrorProcedure,

ERROR_MESSAGE() AS ErrorMessage,GETDATE(),

CONVERT(sysname ,USER_NAME())AS DBUSERNAME,

CONVERT(SYSNAME,SUSER_SNAME()) AS SYSUSERNAME

Please use the above select statement in your Catch block to catch the error.

SELECT @uniqueno = ResumePrefix+ResumeSuffix+ResumeLastNo FROM HC_SYSCONFIG

This statement is causing error. Convert ResumeLastNo to nvarchar

SELECT @uniqueno = ResumePrefix+ResumeSuffix+Cast(ResumeLastNo as nvarchar(100)) FROM HC_SYSCONFIG

Also recheck your code to resolve such issues.

This should help.

Declare @vTab Table (machinename varchar(10),dateRec datetime,recID int)

Insert into @vTab

Select 'machine 1', '4/14/2010', 1 Union ALL

Select 'machine 1' ,'4/12/2010', 2 Union ALL

Select 'machine 2' ,'4/12/2010', 3 Union ALL

Select 'machine...

Something is not right....

I got three choices

1. Wrong Answer

2. Right Answer

3. Wrong Answer

I got the point by selecting 'Right Answer' 😛

The result of the first Select @@RowCount depends upon the last query executed in the session.

I tried it in different ways;

1. Executed query that returned n number of rows and...

As far as values within the Preference types are concerned, they will be changed as it is configurable. But I dont think it will change the structure of your code....

Yes, I do understand the logic written in your code. The code will be changed to get it implemented as I have another three Preference Types. These are DonationFor, Procedures...

Like I said, i will check it with different Patient Preferences. Currently, I checked it with a few and it gave me the rigfht results.

The code that I wrote to...

THANKS ALOT Lynn Pettis...

The solution is working perfectly, also with the new patient scenarios. I will check it with a few more patient scenarios and will upload it on my...

Long Code Lynn Pettis :-).

I will definitely check it out later this evening.

Thanks.

I think you are very close to the point. If you closely see the structure, it...