Check out the OUTPUT clause of the INSERT statement (this is what it's there for!).

(well, maybe other things to, but definitely this.)

Assuming that in the second two lines, that column 2 is supposed to start with a double-quote, then this works for me:

if object_id('tempdb..#Test2') IS NOT NULL DROP TABLE #Test2;

CREATE TABLE...

Jeff,

Is all of your character data going to start and end with a double-quote? (Your sample isn't doing this...)

It looks like you could benefit from checking out this excellent blog: http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/[/url]

CirquedeSQLeil (9/10/2010)

WayneS (9/10/2010)

And as long as that keeps going down, we'll make it!

Now, is anyone...

And as long as that keeps going down, we'll make it!

Now, is anyone tracking Gail...

Brandie Tarvin (9/10/2010)

It's like a raspberry, sticking one's tongue out, making the phbbt noise, and probably drenching everyone in the vicinity in the process.

You're the...

Brandie Tarvin (9/10/2010)

Careful, you. I have the DBCC Timewarp remote...

For those of us that don't do FB... I'd love to...

How's this?

declare @PatientID varchar(50);

set @PatientID = '1865004';

WITH BP1 AS

( -- strip the time from the date

SELECT BPM_TimeStmp,

BPM,

...

vivek,

First of all, I want to congratulate you on the excellent job you did on posting the table/data. You'd be surprised what we have to go to in order to...

Please read about SQL Injection before you implement this. It really would be best (IMO) to call stored procedures with the desired parameters.

This is covered in the SQL Server 2008 Upgrade Technical Reference Guide. It's called a side-by-side upgrade.

Hey Threadizens - any ideas on why OPENDATASOURCE isn't working on a prod server?

Thanks!

Wonderful