Can you please explain why you neither want to use the view nor the underlying code itself?

Also, what you've posted is not a sp but single SELECT statement.

There's no simple...

Something like this?

SELECT TOP (@topval) dbo.bigtb.fire, dbo.maingroup.maingroup, dbo.bigtb.subgroup, dbo.maingroup.groupnamefa, dbo.subgroup.subgroupfa, dbo.bigtb.title1,

...

...

Design the query using msquery (in excel tools-> data -> get external data then select the dsn/odbc link).

Any criteria fields in the msquery should have a value of []. The...

What do you mean by "loading twice"?

Does the current loop perform the "double load" or does it happen when the SSIS package is restarted?

There are several options to avoid the...

If you have SSMS (SQL Server Management Studio) installed, you can connect to a SQL Server instance on another machine if the machine allows access (SQL port open, usually port...

How about using UNION ALL to merge the three results into one?

What do you mean by

?

Would you please post some sample data (table def and sample data) together with your actual execution plan so we...

The WAITFOR has a parameter @p2 for a timeout. What's the value of this parameter?

The process did wait for 15+ seconds to get new data.

Without knowing what is triggered by...

Usually, AD group memberships is controlled without the need for confirmation from a DBA - for a very good reason, since the SBA should not be concerned about a member...

By definition, there is no "first row" in a table. It all depends on the columns in the ORDER BY section of the SELECT statement, what row will be presented...

I'm still waiting for a description of the business rule how to sort the rows (without the term "priority").

Did you try the solution I provided?

If the league table can have duplicates, keep the UNION ALL and change the league query to

SELECT L.LeagueID as PlayerID, L.LeagueName as PlayerName

FROM #league...

Here's an approach using the OUTER APPLY operator available since SQL 2008 (so, it's nothing new in 2012 ...).

Please note that I changed UNION to UNION ALL for the query...

The AND operator has a higher precedence than the OR operator leading to the following logic:

where (ath_postype = 'NTC') or (ath_postype='NTD' and

ath_postdate >= '2013-01-01 00:00:00' and

ath_postdate <= '2013-01-05 23:59:59')

If this...

The View [DML].[ExtOLSMachineEntitlement] refers to a table DML.ExtOLSMachine.

You might want to take the effort to have a look at your execution plan... -> The table is indeed referenced.

I guess...