I fall into the "avoid row-by-row operations" camp. Around here that's commonly referred to as RBAR. Itzek Ben-Gan, an well respected author an authority on T-SQL warns against iterative approaches...

fliteskates (5/29/2015)

---

Hey all,

I am trying to learn how to use SQL and I have downloaded MSSQL Server 2014 Express. I am a complete beginner with little experience.

I just downloaded and...

No certs, happy with salary. I don't think not having them has hurt me in any way. If you are new and trying to get your foot in the door...

Haha. Would be even funnier if it weren't so true....

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition...

Based on your original post, this will give you exactly what you were requesting:

DECLARE @order TABLE (OrderNbr int);

DECLARE @dept TABLE (Dept CHAR(1), Person varchar(3));

INSERT @order VALUES (1),(2),(3),(4),(5),(6);

INSERT @dept VALUES

('A','P1'),

('A','P2'),

('B','P3'),

('B','P4'),

('B','P5'),

('C','P6'),

('C','P7'),

('C','P8'),

('C','P9');

SELECT d.Dept,...

Just read this. Amazing work Frank!

Looks like SQL 2016 is going to be very Big Data-Centric from what I have read.

Jason A. Long (5/29/2015)

---

Well now... Turns out that the SQL Server instance that's running Reporting Services only has a single CPU core available to it...

I suppose that's why a query...

simon.barnes (5/29/2015)

---

I then discovered that there's no median function built into SQL Server (2008 R2, at least). Simple enough to write. I then heard the words "interquartile range" (75th percentile...

You can get most of what you are looking for by querying <your ReportServer DB>.<schema>.catalog. You can get the RDL/XML by casting the Content column as varbinay then as XML...

Jason A. Long (5/28/2015)

---

First thing first, here is the query that I'm using...

WITH ContentToVarBin AS (

SELECT

c.Name,

CAST(c.Content AS VARBINARY(MAX)) AS Content

FROM

ReportServer.dbo.Catalog c

WHERE

[Type] = 2

), ContentToXML AS (--The second...

Not clear what you mean by:

If you are talking about checking Objects on other servers you can loop through the server you are on as well...

I'm going to go with Jim Morrison seeing that he's been banned from another Venue.

This is not a very clear description of what you are trying to do. Can you post some DDL, consumable sample data and an example of the expected results?

DMV's are views, DMF's are functions. Dynamic Management Views and Functions were introduced in SQL 2005 and allow you to look at information that is stored in the Query Cache,...