could you please provide the results you are expecting from your sample query above...I think it will help clarify what you want.

Thanks

wwwnlc111 (5/7/2016)

---

Manually it is working perfectly fine, actually my destination is network shared location , even SQL job working perfectly fine as destination local driver but with network location keep...

are you saying that the SQL agent job fails or is just slow?

could be a...

might be useful to consider divide by zero as well

DECLARE @Table_A TABLE

(id INT,

frs INT,

sec INT,

result DECIMAL NOT...

maybe

Update @Table_A set result = ISNULL(frs / sec,0)

select * from @table_A WHERE result = 0

will each combo of Product/metric have only one metric value?

edit....forgot to ask...how many unique metrics?

what did google search throw up for you?

eg "ms sql script all agent jobs"

lot s of answers

as Ed tried to tell you...

http://www.sqlservercentral.com/articles/Tally+Table/72993/

code is at bottom of this article.....strongly suggest you read the article and the associated discussion thread

does every summaryline include the text that is in bold below?

Upper Right, Clinical Info for Radiologist: Bone Tumor; Additional Info to DI Tech: xxx please check

if so...maybe think about doing...

have you considered using ROW_NUMBER() ?

some test data......and yeah the generic audit is slow.

Personally I only use this for...

maybe....

CREATE TABLE #MEMBERS (

MEMBERID INT,

SESSIONID INT

)

INSERT INTO #MEMBERS

SELECT 1,1

UNION

SELECT 1,2

UNION

SELECT 2,1

UNION

SELECT 3,1

UNION

SELECT 3,2

UNION

SELECT 3,3

CREATE TABLE #SESSIONS (

SESSIONID int

)

INSERT INTO #SESSIONS

SELECT 1

UNION

SELECT 2

UNION

SELECT 3

SELECT

...

Jeff Moden (5/5/2016)

---

Wow. I wrote the code almost 3 years ago. I didn't remember the problems that we had with Linq2SQL and other things that had to be...

Jeff Moden (5/5/2016)

---

J Livingston SQL (5/5/2016)

---

Jeff Moden (4/28/2016)

---

Apologies. I'm not going to get to this tonight or tomorrow. I'm in the middle of a server migration and I...

Jeff Moden (4/28/2016)

---

Apologies. I'm not going to get to this tonight or tomorrow. I'm in the middle of a server migration and I need to sanitize the code...