In the subreport's source you cannot use an expression.

My guess is that if you have any chance of getting this to work is to make 2 or more subreports and...

I can't vouch for it but you could use this :

http://standalonesqlagent.codeplex.com/

Combined with this (which I vouch for) :

http://ola.hallengren.com/

Kiss me where it smells funny?

ZZartin (7/20/2011)

---

Sorry if this is slightly off topic but isn't modifying system tables...

Michael Poppers (7/20/2011)

---

Steve Jones - SSC Editor (7/20/2011)

---

cengland0 (7/20/2011)

---

BenWard (7/20/2011)

---

From my PoV the QotD is there, not as a status symbol or as bragging points but rather to help us...

Brandie Tarvin (7/20/2011)

---

On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the mix?

I'm...

... unless one of the connection is not a sysadmin... or maybe the owner of the db is missing and that somehow blocks in the permissions.

visual.prabu (7/20/2011)

---

Thank you Ninja and for your replies.

Now it's working.

Problem is i tried grouped fields to display, as per ninja's reply, i remove the grouping,

then i tried and got...

Any way you can try doing that on another sql 2000 server instead of 2k5?

cfradenburg (7/20/2011)

---

Code and execution plan would be good to see. ...

Rob Schripsema (7/20/2011)

---

I'd still like to argue that the scenario you encountered ("why doesn't this SQL code return any rows?") would lead you to a completely differerent set of assumptions...

cfradenburg (7/20/2011)

---

Trevor Tinsley (7/20/2011)

---

Ambiguous, and nothing to to with case whatsover. Is it me or is there a growing trend for such 'dodgy' questions posted with the sole intent of...

Tell the truth now, did you get it right WITHOUT running the code?

I'd love to see the real...

Trevor Tinsley (7/20/2011)

---

Ambiguous, and nothing to to with case whatsover. Is it me or is there a growing trend for such 'dodgy' questions posted with the sole intent of annoying...

Can't happen unless table variables behaved diffrently in sql 2K (which...