bteraberry (1/18/2012)

---

Sean Lange (1/18/2012)

---

I second the opinion of not doing dynamic sql like this. Your whole query is only a single simple select statement. Even if this is "internal" only...

Maybe I am misreading the OP but there was never any mention of anything other than inserts. Either way the OP has figured out the solution. 😀

shah.simmy (1/18/2012)

---

hi this is just que i am confused.

how many unique key we can have in a table?

if a data coming from xml format type,hw you can store in...

Please see the first link in my signature. You need to provide ddl (create table), sample data (insert statements) and a clear explanation of what your desired output is based...

I second the opinion of not doing dynamic sql like this. Your whole query is only a single simple select statement. Even if this is "internal" only you are still...

Glad that worked you and thanks for letting us know.

fahey.jonathan (1/18/2012)

---

We are not trying to do an UPDATE or a DELETE, so using the OUTPUT clause with those statements does not help.

We want to get the value of a...

From BOL: "Returns information from, or expressions based on, each row affected by an INSERT, UPDATE, DELETE, or...

The others will work but the Output clause is a bit more flexible and is more of the preferred way. Ping back if you need some help.

Take a look at the Output clause. http://msdn.microsoft.com/en-us/library/ms177564.aspx

This would be a great starting point for doing exactly what you are trying to do.

Yeah that should work just fine.

yes...

...of course the trigger will always fire, your condition is just not going to execute the code inside your if block. Splitting hairs perhaps but very important to understand.

I have never heard of this vertical vs horizontal but I would use your first schema. The second one is just plain strange to me. A transaction does not have...

Asking the right question is really tough, especially when it is new. There are lots of people...

I see...I am by no means an SSRS guru. I can barely spell it. Interesting that the syntax is different for concatenation than in tsql. Either way, glad you were...