WITH cteStart(N1) AS (

SELECT t.N+1 FROM dbo.Tally t

WHERE t.N < LEN(@Parameter)

AND SUBSTRING(@Parameter,t.N,1) = ' '

),

cteLen(N1,L1) AS (

SELECT s.N1,

ISNULL(NULLIF(CHARINDEX(' ',@Parameter,s.N1),0)-s.N1,8000)

FROM cteStart s

),

words (N1,Word,Grp) AS (

SELECT l.N1,SUBSTRING(@Parameter, l.N1, l.L1),CEILING(l.N1 / 50.0)

FROM...

or EXCEPT 😀

SELECTv.Vchvendor, SUM(vgl.vglamount) AS [VGLamount],

STUFF((SELECT ','+ b.vchinvoicenbr

FROMVoucherGLDist a

JOIN Voucher b ON b.VchVoucherNbr = a.VGLVoucher

WHERE b.VchVendor = v.Vchvendor

FOR XML PATH ('')),1,1,'') AS [Invoices]

FROMVoucherGLDist vgl

JOIN Voucher v ON v.VchVoucherNbr = vgl.VGLVoucher

WHEREvgl.VGLJEBatch...

Add a parent group (grouping on Full_Name) to the details and give it a name (eg NameGroup)

Add a column to the right of Time_Taken and set the expression to

=Sum(Fields!Time_Taken.Value,"NameGroup")

set the...

Do you want Total_Time, Min_Time, Max_Time and Average_Time shown on each detail line or on a single total line

Luis Cazares (12/2/2014)

I have this problem every time I look...

imex (12/2/2014)

Try something like this:

with CTE_User as

(

select

UserID

from MyTable

group by...

Cast to int, ie

SELECT CAST(45.67 as int)

will give you 45

If the string is less than 8000 chars you could use Jeff Moden's 8K splitter like this

DelimitedSplit8K(REPLACE(REPLACEDetail,'id=',','),' ',''),',')

to get a list of ids

This depends on the variability of the contents...

This means that either

Mid(Fields!businessnamevalue.Value,1,2) chars 1 and 2

or

Mid(Fields!businessnamevalue.Value,3,2) chars 3 and 4

has the value 'DA'

which indicates to me that the field businessnamevalue does not always start with timeslot

Add a calculated field and set the expression to

=TimeSerial(Mid(Fields!businessnamevalue.Value,1,2),Mid(Fields!businessnamevalue.Value,3,2),0)

this will give you a date type field in the dataset (the date will be 01/01/001 but the time will be correct)

You...

It depends on the content of fields!businessnamevalue that contains timeslot (as per your description)

can you post examples of this field?

Add a calculated field to the dataset that parses the column you mention and converts the start of the time period to TIME datatype and use that to order the...

Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀

pwalter83 (11/18/2014)

Thanks very...