Sorry. I only tested it on (too) small numbers. Looks like the floor function does not work with large numbers.

You can mimick the modulo operator on floating point operands like below

with BigNumber(N, D) as

(

-- select power(cast(101 as float), 50)

select

101E50, --...

GSquared (12/29/2010)

---

Peter Brinkhaus (12/29/2010)

---

Probably hex values. 0x41 = 65, the ascii-value of a...

Probably hex values. 0x41 = 65, the ascii-value of a capital 'A', 0x42...

I have to agree with Paul that there are better tools to do this kind of dynamic pivoting. Anyway, here's an alternative

DECLARE @Query VARCHAR(MAX)

DECLARE @TableNames VARCHAR(MAX)

DECLARE @Comma CHAR(1)

SELECT

@TableNames...

As John already pointed out, it is probably a better idea to split the treepath into individual nodes if you have a lot of different nodes. Here is some sample...

Well, probably not the fastest solution you can get, but maybe this on will do.

SELECT

T.TreePath,

STUFF(

(SELECT

',' +...

Why not just remove the column? Right click on the column header, select 'Delete Columns', select 'Delete columns only'.

Peter

only4mithunc (12/8/2010)

---

Hi Peter,

In 2005 I'm able to do this as mentioned earlier, but the problem is with 2008 .

I have followed the steps you have mentioned.

The sorting tab also was...

only4mithunc (12/8/2010)

---

Hi Peter Thanks for your reply.

It didn't work.

This is what I have tried:

1) In my tablix selected the detail row

2) Right Click --> RowGroup--> Group Properties

3) In General tab,...

You can add a row group with a break on the RowNumber expression. However, you have to remove the breaking expression from the Sorting options (the group expression is automatically...

Here's another solution using a slightly modified version of Chis' test table data.

Solution:

;WITH TrimmedSentences(SentenceID, Sentence) AS

( -- Trim preceding white space of all sentences

SELECT SentenceID, LTRIM(Sentence) FROM #Sentences

),

Tally(N)...

A commonly used trick to concatenate values of a column is to use a FOR XML PATH('') subquery, i.e.

SELECT DISTINCT

ds.DeviceId,

-- Use STUFF to delete the first...

Peter Brinkhaus (11/11/2010)

---

Maybe this one will do. The trick is to number the childs and cars in any order you want and do a full outer join on the row...

Maybe this one will do. The trick is to number the childs and cars in any order you want and do a full outer join on the row numbers.

select

...