Thank guys! I had no clue VS 2012 with data tools has no report building capability. 🙂

I really liked Report builder 3.0. I might get that :w00t:

Well, probably not a problem if this is last resort. Or I assume I might change some table structure to deal with this.

Thank you so much, greatly appreciated 🙂

Sure. Here's simplified (please ignore lack of PK FK etc) set up to create the xml...

DECLARE @tmp1 TABLE (

RecID INT,

field1 INT)

DECLARE @tmp2 TABLE (

RecID2 INT,

field2 INT)

DECLARE @tmp3 TABLE (

RecID3 INT,

field3...

I agree with Mr Jones. You have a contract there, they don't care much about you and your family, will let you go anytime they wish and before that happens...

SQL Kiwi (9/29/2011)

---

v_kozachuk (9/29/2011)

---

Thanks for the question.

But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"

The article on technet (

I see no way of doing it without an udf, that's OK I'll ask for permission, thank you so much for tour help 🙂

Ok, I just found the parsename function. It's very close to what I'm looking for, but you know, if I have variable number of delimiters per string and there is...

Oh wow :hehe: I'll play with this one in my spare time :w00t:

It's puzzling to me why SQL Server doesn't have a builtin function to take care of splits....

Thanks so much. I'll probably go with the split idea. I think this is going to be fun incorporating this into one query (can't create functions). 🙂

here is nice explanation:

http://brandonlive.com/2010/02/21/measuring-memory-usage-in-windows-7/

Thanks for reply however it did not work. All paddings, left, right, even top and down are 0pt.

It still looks like this :

(dots are in place of empty spaces)

-----------------------

|...

Nope, it doesn't really like me... Let me clarify that I did not set any Indent in properties. What I'm talking about is the child group that was created with...

How about leaving that division by billion and add a string that will say "Billion" -- prhaps dynamically, depending what you divide the big number.

Instead of Nothing, put the name of the whole data region. That will fix it for you if you have one group and details. If you have more than one...