drew.allen (3/3/2011)

---

opc.three (3/3/2011)

---

Try this:

SELECT b.value('(offerId)[1]', 'Int') AS [offer_id],

fr.value('(internetPrice)[1]', 'decimal') AS [internet_price],

fr.value('(newStandPrice)[1]', 'decimal') AS...

You're very welcome 😀

If you're just looking for an SQL script with all data in a database scripted out as DML commands (similar to what mysqldump can do) you can get that from...

Try this:

http://www.sqlservercentral.com/Xml/Rss/articles

Thanks, nice tip 😉

Check out RedGate's SQL Data Compare tool @ http://www.red-gate.com

Is this what you meant?

SELECT B,

C,

D,

...

Opening an SSIS package in a text editor and changing the server name does work, I have done it that way to do changes en masse.

I do not know...

Just FYI using NOLOCK in an UPDATE or DELETE statement has been marked as deprecated in SQL 11 (Denali).

Try this:

SELECT b.value('(offerId)[1]', 'Int') AS [offer_id],

fr.value('(internetPrice)[1]', 'decimal') AS [internet_price],

fr.value('(newStandPrice)[1]', 'decimal') AS [news_stand_price],

...

If your SSIS package are stored in SQL Server you can query the contents of them using LIKE with wildcards the same way you can query sys.sql_modules for references in...

Please post the DDL and DML.

Related post from same OP: http://www.sqlservercentral.com/Forums/Topic1072204-148-1.aspx

My fault, I missed the distinction you made. SSIS does not handle embedded column delimiters or embedded text qualifiers as robustly as I would like. SSIS will however handle embedded...

Some thoughts:

1. Don't use Hungarian naming for your procs, i.e. don't prefix with sp.

Try this code:

ALTER PROCEDURE dbo.compare_orders

AS

BEGIN

SET NOCOUNT ON ;

DECLARE...