You should be using Developer Edition for a dev server. Enterprise is probably running unlicensed there, or...

james.ingamells (11/8/2013)

---

My previous posts no longer correlate to what i am trying to achieve now, but the concept is the same. I have a calendar table and also a table...

K. Brian Kelley (4/15/2011)

---

jinlye (4/15/2011)

---

this seems like a lot of effort and increased overhead on your SQL database, for something that can be handled much more efficiently at the transport...

Sorry, I can't see them. I took a look at your previous posts, but...

You're welcome.

Glad I could help.

In order to find the latest value for each column, you need to unpivot and concatenate the values in the source tables.

Setup:

DECLARE @vw1 TABLE (

[PRODUCT] [varchar](50)...

I wrote an article on custom date formats[/url] last year. Maybe some of the functions there can help.

It could be anything. Very hard to tell without more information.

See if this article helps: http://www.sqlservercentral.com/articles/Linked+Servers/73794/

You can edit your original post using the "edit" button.

Probably the SQL Server service account can't instantiate the OLEDB provider.

Follow the steps in the "DCOM configuration" section of the article.

However, I don't recommend that you troubleshoot in production (some...

Linked servers use OLEDB providers, which are ultimetely DCOM objects. DCOM configuration is really tricky and out of the box everything works with Administrator only.

See if some of the steps...

Please define "overlapping".

Two rows are identical: is this overlapping in your definition?

The last row you insert in not in the desired output: why?

Lots of information missing. Please read the first article linked in my signature line and find out how to post effectively to get quick answers to your questions.

Rather than sp_who2 and DBCC INPUTBUFFER, I would use a better tool to discover locking and blocking.

Adam Machanic wrote a masterpiece called sp_whoisactive, that you can find here: http://sqlblog.com/blogs/adam_machanic/archive/2011/04/30/twenty-nine-days-of-activity-monitoring-a-month-of-activity-monitoring-part-30-of-30.aspx

I...

You probably won't be getting many replies if you don't give us some data in a consumable format.

Please read the first article linked in my signature line: you'll find...