GilaMonster (11/4/2015)

---

No, index usage...

Also as Gail's answer eluded to, it only helps if those tables have an index. If you have any heaps you are out of luck.

You are right in that you can't just do a...

Or something like this...

DECLARE @myTable TABLE (SomeDate DATE, Col1 INT, Col2 INT, Name NVARCHAR(10))

INSERT INTO @myTable

VALUES

('2015/10/01', 50, 13, 'personA'), ('2015/10/01', 50, 11, 'personA'), ('2015/10/03', 50, 21, 'personA'), ('2015/10/01', 50, 17,...

Is this what you are looking for?

DECLARE @myTable TABLE (SomeDate DATE, Col1 INT, Col2 INT, Name NVARCHAR(10))

INSERT INTO @myTable

VALUES

('2015/10/01', 50, 13, 'personA'), ('2015/10/01', 50, 11, 'personA'), ('2015/10/03', 50, 21, 'personA'),...

Welcome to the forum. In the future please post some DDL code to help us help you. Trust me you'll get help much faster.

Read this excellent article on...

Being in N. America Rugby isn't very popular here but I got the question right anyway using (American) Football as my reference. 😉

Ed Wagner (10/29/2015)

---

yb751 (10/29/2015)

---

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I thought...

Agreed, my #1 source online for everything SQL. I've learned more on these forums than anywhere else hands down. 😀

I was on my last eye twitch yesterday (so to speak) so I put together this image. (attached)

I was thinking about unleashing it but then I thought maybe it was...

Lowell (10/28/2015)

---

SQLPain (10/28/2015)

---

yeah that's true, currently I have more than 50 jobs set up on reporting server, all with funky name, don't know how to figure out which one is...

Try this:

SELECT

ScheduleID,

[Path],

[Name],

s.Description

FROM ReportServer.dbo.catalog c

JOIN ReportServer.dbo.Subscriptions s on c.ItemID = s.Report_OID

JOIN ReportServer.dbo.ReportSchedule rs on rs.SubscriptionID = s.SubscriptionID

SQLPain (10/28/2015)

---

On the description of the Job 'D26XXX' I see the following note:

'This job is owned by a report server process. Modifying this job could result in database incompatibilities. Use...

Have you opened the job and more particularly that job step? Likely, all you need to do is modify the call and add more recipients.

Look for something like:

@recipients = 'John@AdventureWorks.com',

And...

christophe.bernard 47659 (10/28/2015)

---

Hi yb751, Luis Cazares

thanks for your time that's exactly what I want ..

I don't know the function pivot but I can see that's very powerfull ..

@yb751 => your...