Hi Lynn, EXECUTE() AT allows you to run a batch of statements, including for instance running results into a temp table for further processing.

Lynn Pettis (7/21/2014)

---

Just a thought, but I was wondering if the following would work:

SELECT WorkOrder, TakTime

INTO

[plc].[TaktTime]

from openquery([SAPETL],'

WITH TaktValues ([Counter], NODE, PLNNR) AS

(

...

Lynn Pettis (7/21/2014)

---

So you are saying the Linked Server is hidden by using a synonym? Well, not obvious from what you posted. ...

sgmunson (7/10/2014)

---

There's a much simpler query:

DECLARE @DATE AS datetime = '07/10/2014';

DECLARE @TIME_START_INT AS int = 820;

DECLARE @TSV AS varchar(4) = RIGHT('00' + CAST(@TIME_START_INT AS varchar(4)), 4);

DECLARE @TIME_END_INT AS int =...

All at once or one at a time?

On phone so long shot - try LEFT REMOTE JOIN ticket.

Lynn Pettis (5/13/2014)

---

Is the temp table created on the fly (SELECT INTO) or is it predefined using CREATE TABLE and then populated with an INSERT INTO statement? If the...

Properly written queries will cut down on those scans. Consider the query you...

Without sample data to test against...

Try this.

;WITH Updater AS (

SELECT

FTEHrsAVG,

NewFTEHrsAVG = AVG(CASE WHEN FlexVast = 'VAST' THEN FTEHrs ELSE NULL END)

...

Jeff Moden (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would probably work...

EasyBoy (4/16/2014)

---

Thanks Scott and Lynn for your inputs.

As suggested by Scott i have made changes in existing index with filtered index (suggested by Lynn). And i am able to bring...

Back to basics. Change Exec(@Tsql) to PRINT @Tsql. Examine the output. Too many delimiters around your variables perhaps.

The easiest and fastest way to process your table would be the "quirky update". See Jeff Moden's article here[/url]. Post back if you have any questions after reading the article.

tfendt (3/21/2014)

---

I also posted this question in StackOverflow. Here is the solution:

select DealerId, Tire, count(*) as RepairsOfThisTire,

max(cnt) as TotalRepairs,

...

It also counts the total number of repairs per dealer.

;WITH

Preagg AS (

SELECT DealerID,...