Okay, but that doesn't tell me anything about the exact how, nor does it solve the need to change the connection manager for the Flat File Source.   Just telling me...

If you are using Lookup to get multiple values, that's the wrong tool for the job.   Also, how were you planning to display the multiple results you were expecting?   If...

What about INFORMATION_SCHEMA.COLUMNS or sys.columns ?   Do you not have access to either of those?  It just seems to me that those would make it far easier than trying to...

SSIS and SSMS are in two different categories where connectivity is concerned.   SSMS has that import ability at only the most basic level, and can't be effectively optimized, whereas SSIS...

I am in the process of converting an access query to T-SQL. There is an IIf statement which I am having trouble translating.

SUM (LOTOSMIS_ACC_TYPE.sing_ind * LOTOSMIS_RET_DAILY.grs_amn *

iif( gm_cd in...

Hi,

Currently i having SSRS hosted in ASP NET Web Applications Portal.

It will connect to my SQL Server Stored Procedure for query records.

The issues is, when the month range...

I'd very much favor a nightly job...   might want to investigate "Automate", which can make automating a nightly web-site download into a piece of cake...   It's not free, but it...

Well. with a billion rows, an insert might have to also compete with other processes that may hold locks on the table.   It's not really a "simple insert" when the...

Yep... there's more than a few details missing here...  no table description, and no description of the "why" behind doing all those individual OPENROWSET selects.   As there's no description of...

I'm pretty sure that's not an option, ... although I'm certainly willing to be proven wrong.

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 4 years, 5 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...