CREATE TABLE #YourTable

(

YourTable1 varchar(20)

,YourTable2 int

,YourTable3 datetime

)

SELECT *

FROM tempdb.sys.columns

WHERE object_id = OBJECT_ID('tempdb..#YourTable')

The fundamental problem is the whole approach reeks of bad design.

The thing that takes the time is scanning the table, not the CASE statements. The query I posted attempted to...

If you post what you are actually trying to do, someone may be able to suggest a better approach.

The best that can be done with the current approach is a...

To avoid typos when replacing DBs from backups with the same logcal file names, I tend to generate the MOVEs with the following:

-- To generate MOVEs from dest DB

SELECT ',MOVE...

My experience is that JOINs in sub-queries soon become nested loops.

Also, using EXISTS sub-queries negates the need for a DISTINCT.

I would try something like:

WITH UpdID

AS

(

SELECT ID

FROM demogtable d1

WHERE d1.demogID =...

This is also quite old but worth reading:

http://www.cs.arizona.edu/~rts/tdbbook.pdf

Your key problem will be working out what the encoding is.

It is probably Base64. This site may help:

http://www.opinionatedgeek.com/dotnet/tools/base64decode/

I think sp_start_job is one of the SPs which do not throw errors but return a status code instead.

Try:

DECLARE @RetVal int;

EXEC @RetVal = msdb.dbo.sp_start_job N'TestJob';

IF @RetVal > 0

RAISERROR(N'TestJob failed to...

Using the Windowed functions (ROW_NUMBER, RANK etc), is normally the easiest way to resolve this type of query.

-- *** Test Data ***

-- You should provide test data in this format...

Locks are acquired by a SQL connection.

If one connection acquires an X lock on a table that connection can still do a SELECT; it is just other connections that will...

CREATE TABLE dbo.MyTable

(

MasterIp varchar(255) NOT NULL

CONSTRAINT PK_MyTable PRIMARY KEY

,status1 tinyint NOT NULL

,status2 tinyint NOT NULL

,Active_status tinyint NOT NULL

)

GO

CREATE TRIGGER TR_MyTable_IU

ON dbo.MyTable

AFTER INSERT, UPDATE

AS

IF @@ROWCOUNT = 0 RETURN;

SET NOCOUNT ON;

-- Rows...

I do not understand your results, but the following should get you started:

-- *** Test Data ***

CREATE TABLE #t

(

TransactionId int NOT NULL

,SellDateTime datetime NOT NULL

);

INSERT INTO #t

VALUES (1, '20120612 09:30')

,(2,...

I was half thinking that for my original version but of course it is an AFTER trigger so one...

The trigger should be:

SET ANSI_NULLS, QUOTED_IDENTIFIER ON

GO

ALTER TRIGGER dbo.TR_tblProduct_PRCode

ON dbo.tblProduct

AFTER INSERT,UPDATE

AS

SET NOCOUNT ON;

BEGIN TRY

IF EXISTS

(

SELECT 1

FROM inserted

WHERE COALESCE(PRCode, '') = ''

)

RAISERROR ('No PR Code.', 17,1);

IF EXISTS

(

SELECT P.PRCode

FROM dbo.tblProduct P

WHERE...

SET ANSI_NULLS, QUOTED_IDENTIFIER ON

GO

--CREATE TABLE dbo.Exceptions

--(

--ExceptionId int IDENTITY(1,1) NOT NULL

--CONSTRAINT PK_Exceptions PRIMARY KEY

--,ExceptionDate datetime NOT NULL

--,ErrorNumber int NOT NULL

--,ErrorSeverity int NOT NULL

--,ErrorState int NOT NULL

--,ErrorProcedure nvarchar(126) NOT NULL

--,ErrorLine int NOT...