This will give you a number in the first column based on how many times DQLinkID appears in the result set

SELECT

ROW_NUMBER() OVER (PARTITION BY bd.DQLinkID ORDER BY bd.DQLinkID) AS...

can put it anywhere in the query you want

SELECT

ROW_NUMBER() OVER (PARTITION BY bd.DQLinkID ORDER BY bd.DQLinkID) AS NumMatches,

bd.DQLinkID, ...............................

ROW_NUMBER () OVER(...........) AS RowNum where you put in the over clause either a partitioning field and an ordering field or just an ordering field.

in your case you will...

ok try shrinking in small chunks as this can sometimes be faster than shrinking in one big go

also I take it you are fully aware that you will need to...

you just need to do a row_number based on the bd.DQLinkID then and it will say if its 1,2,3,4,5,6 rows for that particular DQLinkID which will give you a starting...

the issue is down to the DQID's and registrations being different for the same DQLinkID and your group by is working as it should as it cannot group 416 into...

take a look at the Create Some Data section of the article, or dump out the data into 2 excel files so we can import it

can you post DDL and sample data along with your expected results as per the 2nd link in my signature block?

and what about free space?

sorry but it might just be me reading the problem, but what is the actual problem?

has the service account used to run SSRS expired and needs a password change?

have any...

Rod at work (3/27/2012)

---

I believe I may have been rude with the initial post of this thread. If in fact you found my initial post to be rude, then...

take a look here http://ola.hallengren.com/

+1 on Lynn's comment.

We had a mix of Sybase ASA and SQL, used the ASA ODBC driver to create a DSN, then used an ODBC connection manager to point to...

i would take a look at cross tabs, links below, and the pivot keyword.

CT-P1[/url]

CT-P2[/url]

also follow the second link in my signature to post DDL and sample data so that we...

can you attach a screen shot of the execute sql task details?