CHARINDEX???

create table PseudoTable

(

OneColumnToRuleThemAll varchar(max)

)

insert PseudoTable

select '01J416781|1|2013|2|Value' union all

select '934|f|asdf|qwer|erty|sdfg'

select * from PseudoTable

where CharIndex('|', OneColumnToRuleThemAll) = 10

It would be a lot more helpful if you could take a few minutes...

Then you should remove it....

You really haven't posted much in the way of details other than a somewhat vague description of what you are trying to do.

Maybe you want left(SomeColumn, 9)??

I see a few issues going on here. First you are taking in parameters to build a dynamic string and you going to end up executing that dynamic sql with...

No problem. Just make sure that your structures meet ALL of the requirements or it can lead to some very strange and...

LOL Erin beat me to it.

To the OP. This one happened to be pretty simple. Generally we like to see ddl, sample data and desired output. You might want to...

SELECT

EMPL_ID,

PAY_TYPE_ID,

SUM(LABOR_HRS) AS 'HOURS',

SUM(case when PAY_TYPE_ID = 99 then 0 else LABOR_COST end) AS 'Labor Cost'

???

Sounds like you need a running total. Check out Jeff's article about this here. http://www.sqlservercentral.com/articles/T-SQL/68467/%5B/url%5D

jgluszak (3/19/2013)

---

OK - I've tried everything I can think of to fix this but nothing is working. Here's the issue; I have created a report that is sums building square...

abembalkar (3/19/2013)

---

as of now it inserts 10 percent for every user as below.

orderid processid uid ordervalue perwet(percent wieghtage)

1 ...

So do as Lynn suggested IF they both return correct results.

Looks to me like what you need to...

Hi and welcome to SSC. It seems that you didn't really post everything needed for somebody to help here. There are a number of tables missing in your ddl that...

Why not just look at the excellent code that Chris M posted earlier in one of the dozen or so threads on the same topic.

http://www.sqlservercentral.com/Forums/Topic1432131-391-1.aspx#bm1432134

john_t_bailey (3/19/2013)

---

Sean,

Thanks for the quick response.

May I assume from your answer that this capability does not exist in SSRS 2008; but requires SSRS 2012? And actually, 2012...

If there are no triggers and you are not using a proc this is a...