You should be able to setup 32bit DSNs by using the ODBCAD32.exe in the C:\Windows\SysWOW64 folder.

I recently had a problem with some maintenance plans on a machine I sort of look after but do not control the access rights on.

The problem was fixed by:

SP_CONFIGURE 'ALLOW...

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...