Hey we seem to be throwing ideas out there...

Why not xml??

Talk about crappy design... Seems to be on the topic a lot today.

How about exporting to text file then using bulk insert .

"" and "=>" or not the same thing... use them as required.

Let's say we have front row tickets for those kind of events.

Maybe they could be able to call 1 hour earlier while you're not even home yet .

Starting to sound like another moo point here... He must know what's best for his system.

But I wouldn't do that just to be sure there's no possibily of injection. ...

It's surely not something you brag about .

That would be dynamic sql.... Preffer the proc approach.

It's not the same productid, this is not a duplicate row.

Have a look at the data in each table to see if anything doesn't make sens.

Yup... the advantage of the output parameter is that you can have as many as you want and that you're not stuck with the int datatype. The can also...

Hehe, sounds like an horror story I heard about our governement. They wanted to merge all the applications used by all the departements into one huge software. A...

Simplicity is the golden rule in sql server.

He'll get this eventually. Maybe after 2-3 weeks of trying to make this work ...

I assume that there are more that he didn't pick up yet.

Way to stick it in there .

I feel I must point this out at this point.

When you...