Could you please tell us what error you are getting? More information may be needed such as what your table schema are, what data is producing the errror,...

The key thing to remember is that a multi-row insert is a single transaction and your trigger will fire only once for the set of rows, not once for each...

One thing to be aware of when doing this on a large scale is that you have no suitable column to ORDER BY on. Ordering by name will...

I'm afraid I really don't understand your question. Could you possibly supply a little more detail? What do you mean by "practical"? Some...

Here are another couple of CTE-based variations. They may be easier to read and understand. Basically each does a summary query to total the...

This question is a common one. You can find a lot of different approaches if you will search this site using the keywords "PARSE" and "DELIMITED".

There are lots of variations that will work.

Here's another that gives you a six-character string in the format YYYYMM.

...

Let's all do the Canadian National Cheer !!

Gimme a "C"

eh?

Gimme a "N"

eh?

Gimme a "D"

eh?

What's it spell?

CehNehDeh!!!!

😀

I'm just brown-nosing. 😉

Lets not forget to congratulate Steve too.

Tony,

It's a good solution because it gets you past the problem of not being able to use a db-qualified procedure name in the CREATE PROCEDURE Statement. I'm not...

An odd fact about inline table valued functions is that you can run inserts, updates, and deletes against them. They really are treated like parameterized views.

I like a little cheese with my whine.

I refrained from joining in the debate over in The Thread. I agree with you though that a little tech could go a long way at that...

You or the officials?