i know logically, it makes sense to get the id's you are looking for in one table, adn then do a seperate step;

but from a good TSQL point of view,...

nope no practical limit; that table could be billions of rows in the subquery;

the only practical limit might be speed; proper indexing might need to be looked at so...

yet another way is since you already did the export, using a decent text editor like EditPlus you can use a regular expression to find \n (CrLf) and replace it...

i stand corrected; unless the call was wrapped in a transaction, the code does execute, the row gets deleted, and the archive table does get the deleted row even with...

toddasd (7/6/2011)

---

The RAISERROR doesn't rollback the transaction, you would need an explicit ROLLBACK TRANSACTION after that statement.

Wendel, your trigger is fine, but I'm thinking other triggers may be interferring. Disable...

Learning a lot today guys, thanks for the input.

I did as Phil suggested,and changed my datasource to use an OLEDB Source, made the SQL do the conversions, and it exports...

GilaMonster (7/6/2011)

---

You don't. You tell whoever wrote the app that they must call stored procs not run adhoc queries.

Frankly the idea of modifying the returned data is terrifying. If I...

change your raiserror to a print statement...wouldn't raising an error of 16 or above inside the trigger rollback the trigger?

i'm with Gail; all you can do is trace it...so i don't think so; for example the DMV's that have the execution plans for a given statement would occur after...

here's a recursive CTE example i keep in my snippets; if you can provide the CREATE TABLE/INSERT INTO statemetns like this example, we could help you with yours, but this...

run as a batch, i saw what you pasted was missing an open parenthesis, but otherwise just fine.

i suspect it's a highlight-and-F5 issue.

are you highlighting, say each section one part...

Vertigo44 (7/6/2011)

---

Sorry I should have been more clear.

I have already imported a cobal database into a sql database using an ODBC connection.

Now that I have finished mapping the fields...

this has got some nice comparison tools on the page..i selected Datacenter and Enterprise for example, and then i can scroll through so many comparision options ....

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

at a glance, it...

i think all you need is EXEC in from of the proc: multi line statements require EXECUTE procname, only when a command is standalone can you just put the name...

depending on the application, if it was doing anything with importing from access,excel or raw text files using the JET 4.0 driver , jumping to 64 bit becomes a big...