The dynamic naming is quite simple for something like this. The challenge is in how to join the tables. It can be done if you have foreign keys setup but...

You have so much negative logic in here it is really hard to figure out what you are doing. All that negative logic is going to make performance of this...

Hi and welcome to SSC. I don't quite understand what you want. Please a take a few minutes to read the first link in my signature for best practices when...

duplicate post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1413458-147-1.aspx

What do...

Not as scary as the brain surgery for Stefan's friend but my wife is having total shoulder replacement surgery in the morning. Her mom is coming out for a couple...

OK I am following you now. I am out of here for a couple days. Hopefully somebody else will stop by and lend a hand. I think you can probably...

vlad-548036 (1/29/2013)

---

SQL 2008R2

How to insert / retrieve 3 identity values without using GO 3 ??:-)

Also insert top(3) ... does not work either ... :w00t:

Please see the snippet below:

create table N...

SQL_Enthusiast (1/29/2013)

---

Sorry for the last minute addtion. Thank you for looking at this again. Here is the same data in Excel. Rows 7 & 8 I would expect to see...

OK that certainly helps. What is the desired output based on your sample data?

SQL_Enthusiast (1/29/2013)

---

I admit, I was frustrated yesterday and I took it out on the forum. It just appears that with little effort on a post, I get the "best practices"...

zoom19 (1/29/2013)

---

Sample data for t_Appointment

INSERT INTO [t_Appointment]([ApptID]

,[ApptCode]

,[ApptDate]

...

Can you provide data for that table?

Well think about what you are asking. You are starting with knowing that you need customer and...

Nice job posting ddl and sample data. However you missed t_Appointment.

Also if you could post what you expect as output along with an explanation of the business rules it would...