Jeff Moden (11/25/2009)

---

I have to tell you that writing a trigger like that is a form of "Death-by-SQL" because it will only correctly process the first row of the "batch"...

Do the packets have actual identifiers? Are the items already in the packets? How does the actual, physical process work? That affects how you have to do...

Well first you have to create the packets and the container_packets. Then you can use the container and container packets to migrate the packet_items. I'm assuming you are...

I'm not sure what the problem is, so I can't really offer advice. Do you mean moving the data from the 3 table design to the 5 table design?

Since they are SP's you could add code that logs when an SP is used an then query that table.

I don't see anything in your design that limits an item to one packet. You would need a unique constraint on ItemID in the PacketItems table in order to...

You can run a command like this in the batch file using sqlcmd:

DECLARE @ReturnCode int

EXECUTE @ReturnCode = master.dbo.xp_delete_file 0, N'Path to Backups', 'Backup File Extension', 'Date To Delete Before'...

There are basically 2 methods suggested for doing this:

1. Use a Lookup component and send the unmatched rows to the insert and the matched rows to an Execute SQL...

Triggers are synchronous and are part of the transaction so if the trigger fails the transaction rolls back. Here's an introductory article I wrote about triggers[/url].

You want to create a custom template. Here's a search that returns several results on how to do it.

Right. That was the point I was making. There is no easier way, at least not that I know of.

The collation will matter in regards to sorting and comparison. For instance I'm going to guess that the way the Spanish collation handles the accented letters handles that differently...

Okay, heres a search of this site for reporting services articles. There are a bunch.

Take a look at SQL Reporting Services. It comes free with SQL Server 2000 and later. Drag and Drop report designer and the end user goes to a...

You can use SET DATEFORMAT. The Date Format comes from your language settings otherwise.