jghali (11/4/2015)

---

I personally like the Normalized way (no redundant data)

Have everything organized in separate tables... As for queries, If you have the right structure and indexes, it shouldn't be a...

ChrisM@Work (11/4/2015)

---

drew.allen (11/4/2015)

---

The OUTPUT clause is very limited. You can either output the data directly to the client application or you can output your data to a table/table variable....

You cannot use sub-query in OUTPUT, but you can do it with intermediate "always empty" table.

Here is self-explanatory example:

create table src (col int)

go

insert src select 1

insert src select 2

go

create table...

As some others suggest: your question and setup is not clear at all.

Could you please provide DDL for your tables and some test data with example of required output. It...

You need to bring your JOINs to the sub-query FOR XML PATH.

If you provide DDL for your objects and some test data setup I could give you exact and details...

celine.godines (10/28/2015)

---

...

And would like to get my results in 1 row with the Customer then 2 columns for Products, 6 columns for Name/Value/Charges/NewCharges.

Could anyone help or am I being...

Lowell (10/28/2015)

---

Sergiy (10/27/2015)

---

I would strongly recommend not to run sending emails or any other kind of external operations from a trigger.

And glitch in the functionality beyond SQL Server control may...

What do you by "snapshot results from a query"?

Do you want to save results?

You can extract it out by BCP or SSIS or you can save it in another dedicated...

What OP is asking is next to impossible to achieve.

Using Jeff Moden splitter may not be the best in this case, as having few more "x" in the strings...

Why would you wrap single insert statement in transaction?

There is no reason to use nolock hint, untill you want some records to be missed or duplicated.

Yes, you can:

https://support.microsoft.com/en-us/kb/321822

What I need is a count of each of the 3 or 4 character OpCodes - they are usually found between position 40 and 73 on a given line. (I...

I hope that following link should help you to understand what is "remote connection"

https://msdn.microsoft.com/en-US/library/ms191464.aspx

As for SSMS, go to Tools/Options select "Query Execution" in the left panel.

You will see that...

Have you heard about data normalization?

I would suggest to do exactly that.

Store data in the database table as supposed to; report/display it as you wish (comma separated list or...

...what I want to do is add course date from a courses table linked to the appointment

...

... each gp practice is returned multiple times as a row is returned...