IF Object_Id('tempdb..##TempTable') IS NOT NULL

DROP TABLE ##TempTable

Check out OPENDATASOURCE in BOL.

Do you create a table every day?

Sure you need separate table for each day data?

If yes, you better stay with Excel.

In SQL Server you need 1 table with "Date" column. Having...

I wanna see the query which actually returns you count(*) = null.

I was always sure it's not possible.

It's your application issue.

Quite typical issue.

Remove duplicated roudtrip to database for saving data.

You may check that double call takes place using SQL Profiler.

1) Don't ever pass @Criteria parameter.

Have you ever heard about SQL injections?

2) Use WHERE (State = @State OR @State IS NULL)

3) What is the connection between main query and...

Option d) is missing:

Use a subquery.

Option e):

use output parameter and assign @@rowcount to it

You did not read it carefully.

Read again. There is an answer on your question over there.

And again. DON'T USE CURSORS.

I don't see any reason why you need that @var if...

Why are you asking me?

BOL is on you desk, just press F1.

Find SELECT in index, then choose SELECT @local_variable.

I would not explain better.

BTW, don't use cursors. Think.

Did you read anything about index on BIT column?

It does not work by definition.

It's strong recommendation in any book - don't create index on bit column.

You don't need to believe me...

select T1.Session_ID, T1.Session_Name, T1.IPAddress,

        COALESCE(T2.SystemUser_ID, T3. Buyer_ID, T4.Supplier_ID) as PartyID,

        COALESCE(T2.User_Name, T3.BuyerName, T4.Supplier_Name) as PartyName

FROM Table1 T1

LEFT JOIN Table2 T2 ON T1.SystemUser_ID = T2.SystemUser_ID AND T1.LogUserType_ID = 1

LEFT JOIN Table3 T3 ON T1.Buyer_ID =...

If [Datedispensed] is a date why datatype is [nvarchar](max) ?

You know, mita, conversion of 2 million values takes some time. And...

There is no any test data we can see.

But anyway you must read "CAST and CONVERT" topic in BOL at least 10 times before you start to do any conversions...

Which SARGABLE solution have you found over there?

Are you sure your dateField is datetime???

Implicit conversion of datetime to smalldatetime used to be my "favourite exercise" some time ago.

And converting...