I'm not aware of any settings related to the nature of the OLEDB connection, but you can always search Google and see what you can or can't find, ... and...

FYI, the IIF function became available in SQL Server 2012.   I don't recall hearing much about it back then, so I would imagine it may not be all that well...

Apparently, I was unaware there was such a version of SSMS that can debug a sproc...  which version is that?

Both work.  The tally based is probably more efficient depending on scale.  It didn't occur to use a tally...

• This reply was modified 5 years, 9 months ago by sgmunson. Reason: Oops... hit button by accident before I was done typing

Why not just UNPIVOT, as shown here in a CTE:

CREATE TABLE dbo.ProductOrders (
ProductCategory varchar(5) NULL,
ProductSubCategory varchar(5) NULL,
[Total Orders Placed in North America] int NULL,
[Total Orders Placed in...

I can't really help with what VS does or doesn't do...   but frankly, why not learn how to debug your sproc the way it's been done for many years...   Look...

Yes, LEAD and LAG were indeed introduced in SQL 2012.   And I agree with Brian here regarding "which approach can I support?".   That's got to be the number one consideration.  ...

Wow... Thank you so much for such insights.

However, using a hint in the secondary table or in my case on the joining table can still be okay? since all...

Do you happen to know what character in that collation is represented by the ASCII value of "?"  Is there such an ASCII value within that collation?   Not sure about...

I'd have to wonder how VS would perform this task.   After all, it would likely need the kind of permissions you need in SSMS to be able to see the...

Thanks for your help. I have got the below response which works good to me. But , I am getting [] in columns with the values. Is there anyway...

Dynamic key value pairs would require a dynamic SQL pivot.   However, take a look at the following code, which assumes your JSON values are always separated by commas, and that...

Nicely done, Scott...   I had a funny feeling that there was no way to  make recursion work for this, and that some kind of loop was likely a necessity.   My...

Okay... let's restate the problem.   What you posted as the "task" is: "Find a bundle with number less than X".

Not sure exactly what that means, as neither "bundle", nor "number"...

Okay, you've solved the problem (and I'm glad we were able to help) by breaking it up into pieces, but it does kind of leave us hanging as to the...