I would create a temp table which identifies the records to be

deleted and at the same time maps them to their replacements

Select r1.RespondentID As DeleteThisID,

       r2.RespondentID As ReplaceWithThisID

Into...

Why not use 4-part naming and a direct DELETE ?

DELETE

[INTERFLOW02].[MW].[dbo].[Inventory_Category]

WHERE storeid = 2

The ShrinkDatabase likely moved data and index pages around, causing internal page linkage tables to be updated and in the process potentially fixing some allocation errors.

Rather than regularly shrinking to...

>>Since sp_executesql is an extended sproc

sp_executesql is not an extended sproc. System extended sprocs begin with the "xp_" prefix, eg xp_cmdshell.

You can't run dynamic SQL inside a function.

Why would you expact a scan *NOT* to occur, given the scenario you presented ?

When you set @EmployeeID to NULL, you want all records returned, right ?

A scan is the...

Are the SQL Instances exactly the same ? Same hardware, same memory allocation, same server options etc ?

>>All we have is the dialed number, and only one combination of digits is possible for a connected call.

I think that is a very important fact and should result in...

The alias applied to an expression in a SELECT is not available for subsequent use in other expressions in the same SELECT.

Your options are:

- Use a derived table as already...

It's the function declaration that isn't parsing:

Function getValue(strValue as String) As Double

You can't declare the return type in VBScript. Functions return Variants. The joy of a non type-safe scripted...

Are you using Outlook as the MAPI client ?

If you open Outlook as the same user that SQLAgent uses, can you access your mailbox and send mail ?

Agreed, "it depends".

I maintain a system that is heavy on ActiveX scripting & DTS packages that was developed by consultants who didn't know T-SQL and built the system with a...

SELECT u.*

FROM users As u

WHERE IsNull(@iscustomer, 'Y') = 'Y'

AND EXISTS (

  SELECT *

  FROM orders as o WHERE o.userid = u.userid

)

UNION ALL

SELECT u.*

FROM users As u

WHERE IsNull(@iscustomer, 'N') =...

>>It's still not returning the sum of [Column 17] as PTO_Sum,

Right. Because you haven't included that column in the outer SELECT. 1st line of your query should be:

select

I think you should focus on 1 SQL style or another. You have some tables that you are joining in the FROM and some in the WHERE. Either go ANSI...

You are creating a derived table and calling it "p".

Right here:

inner join ( select round(sum([Column...