peter.mclean (12/6/2012)

---

Great article. Wish I had seen something like this a few weeks ago - we spent nearly 2 days trying to get this working!

In my opinion a better...

In my opinion a better solution is to create a linked server to the spreadsheet.

For this to work you will need the connectivity package deployed to the SQL server running...

Well, I found another problem executing the dynamic SQL inside my procedure.

Then I came across another excellent tip regarding using sp_executesql in another database from the current. The tip has...

I have implemented a "workaround" passing my binary as hex formatted string.

This includes:

- converting my row version input paramter from a hex formatted string (nvarchar(128)) to binary(8) to be...

Thank you both.

Now I finally understood it - and also learned that a more appropriate subject title would have been "Clustered Index fields as an Included Columns in a...

Hi again,

I know that a Primary Key is not the same as a clustered index. But in my current scenario they are the same. That is: [LeadId] is a primary...

A good article - that in severals ways reminds my of a process at my company for building the cube - but NOT populating our datamart ("normalized" and dimensional databases)....