This is a very common issue. Unfortunately there is no magic button for this. It requires human levels of intelligence to sort this out. You can leverage sql to get...

Hi and welcome to the forums. What you are describing is very common. One approach to this is to use crosstabs. There are two articles in my signature which explain...

Hi and welcome to the forums. I see what you are trying to do here but I would suggest that you should avoid nesting views like the plague. The challenge...

RamSteve (2/24/2015)

---

So will there be any issues in using with(NOLOCK) for sys schemas ? I had the habit of using every where in SQL Statements ..What would be the pros...

Alan.B (2/24/2015)

---

Sean Lange (1/30/2015)

---

Jeff Moden (1/30/2015)

---

Sean Lange (1/30/2015)

---

Jeff Moden (1/29/2015)

---

Sean Lange (1/29/2015)

---

Gosh I...

RamSteve (2/24/2015)

---

I need all columns if no Identity on the table as i am merging and Inserting the Columns data when Not Matched with Identity_Insert ON

for that i need to...

What a bizarre requirement!!! You are going to have to write some code for this one. The only way I can think of is something like this.

select CAST(c1 as varchar(5))...

Edvard Korsbæk (2/24/2015)

---

Seems llike the way to do it. This is the...

So if you need the entire procedure to complete can you just wrap it in a transaction?

Since nobody else mentioned it I feel compelled to suggest that you discuss about changing the naming convention for stored procedures. The sp_ prefix is reserved for system procedures. When...

Edvard Korsbæk (2/24/2015)

---

Hi all!

Need to find a good place to read and understand.

I have several 100 users on my DB.

Some processes delete & recreate posts in a table.

IF user two...

Exactly. So go with the simplest one which I posted a few days...

KGJ-Dev (2/23/2015)

---

Hi Erik,

Here is my confusion, if i use the Sean's suggestion i am in the position to use the same query for two times as i need that output...

OK. We are close. The CustomerArea table is missing. Also, cool that you posted a query that doesn't work but what is the output you want from this data?

Ed Wagner (2/20/2015)

---

Sean Lange (2/20/2015)

---

SQLTestUser (2/20/2015)

---

not allowed to change the structure, wish i could, A location can have multiple areas, a customer can be associated to only one location and...