Not exactly using CASE, but this should do the trick :

SELECT *

FROM MyTable

WHERE IsNull(FirstName, <Name to look for>) = <Name to look for>

  AND IsNull(LastName,...

If you 'add' two values of different data type, SQL Server will convert one of them so they are both the same.

I don't know the exact reason why SQL Server...

If you are 'sure' that this login is not allowed, try blocking the user. Someone is bound to start complaining... Hope it's not your boss

Yep. Mind you, if you do not include a join condition (ON ...) that binds table 1 and table 2, the data from table 1 will be duplicated for each...

Duplicate thread!! Solution can be written in a single select statement :

SELECT

 (DATEDIFF(d, <start date>, <end date>)/7) + 

 CASE WHEN DATEPART(dw, <start date>) = 6

...

Just a small thingy in the query of jpipes. You need to switch the Count(*) = @counter to @counter = count(*)

I would try to import the Excel sheet in a (temporary) table and then do the join that way. Probably offers the best performance.

If that's not possible, you could use...

You can also use OUTPUT parameters for the stored procedure. This allows you to 'return' any datatype and to return more than one variable.

CREATE PROCEDURE OutputVars

@Output1...

Calculate the number of days between them and divide that number by 7.

Next, you will have to do some additional math to check if your interval starts / ends on...

Is there a VB application connecting to the server? Or maybe a developper working on one?

It is not all too uncommon to start and stop a connection for each database...

Using the dynamic SQL Statement is the only solution.

Be careful when using this technique, since the execution plan of the statement will not be cached. This will impact the performance...

I don't know exactly what you are trying to do, but it seems to me this is normal behaviour, due to your data.

If we are talking about one ccr_name in...