Maybe this will give you a better perspective on how the different types of joins work.

DECLARE @Table1 TABLE( MyID int);

INSERT INTO @Table1 VALUES(1),(2),(3),(4)

DECLARE @Table2 TABLE( MyID int);

INSERT INTO @Table2 VALUES(4),(5),(6),(7)

SELECT...

You can't create a dynamic pivot like that. You need to use dynamic SQL.

In my case, I prefer to use cross tabs instead of pivots. These is because they...

Obi-Wan

Tallboy (12/30/2015)

---

Hi Luis,

Thanks for your prompt reply.

I know your code works as I have tested it out before. I know it creates a cte of dates but would you mind...

Are you sure? It seems that there's no mapping happening in the destination. At least that's what the warnings indicate.

Other than that, we'd need more details.

The following code should be removed for it to work.

SELECT CONVERT(date,[dates]) AS Dates

FROM DailyDates

OPTION (maxrecursion 0)

),

However, there's a major problem. You have a rCTE that counts which can become...

Maybe something like this. Without sample data, I'm not able to test.

UPDATE v

SET

[CLAIM_ID] = Maxformnbr

,[PROV_NBR] = ProviderMerge

...

I didn't say your SP had an INSERT statement, I was just explaining Bill how the IGNORE_DUP_KEY option worked. As I mentioned, it only works for INSERT and not for...

SQLBill (12/30/2015)

---

How did you set the PK to allow duplicates? The purpose of a PK is to not allow duplicates and the only way I'm aware of to allow...

You can use a NOT EXISTS, but without DDL and sample data, I won't guess the correct statement you need.

You could also convert this into a MERGE statement if you're...

SQLisAwE5OmE (12/30/2015)

---

Jeff Moden (12/29/2015)

---

Thanks for that. That view is a bit of a "Rosetta Stone" for what the...

kaza.rohan (12/30/2015)

---

Can we write dynamically for sys.databases , is there any possibility ?

But for other tables it is possible by using sys.columns and then we can unpivot it.

but sys.databases is...

And if you get stuck on any subject, this forum is full of experts that can guide you. In fact, the entire SQL Server community is very helpful.

Developer edition is a complete enterprise edition (all the features).

Regarding the other questions, I would say it depends. Some people like to do self study to be able to work...

It basically adds a value to the Description property of the column. It changes only the metadata of the column for documentation purposes. You could also do it using the...