SSCarpal Tunnel

Although, yours has the same desired layout on the output, my example allowed for the dynamic column I need on person and I didn't have to worry...

Saravanan

Thanks for the suggestion. I like what you did, but the output is not in the layout that I need. I ended up using my pivot example and...

10 is the max, at this point, of the number of people associated to an EngagementID. Of course that could change down the road. I will try your suggestion.

Ok I did a pivot, but for some reason my PercentageSplit value is not pulling through...can anyone see what I am missing? So here is the process that I am...

Phil
Already ahead of you on that one 🙂 I did create a permanent table because of the number of SPs that would be using this table.

Phil
Thanks, I think this one will work best due to what I am working with here. Performance is not an issue as these are fairly small databases and these...

That worked, thanks! I am showing what I did in case there is someone else that is in a similar situation:

CREATE PROCEDURE [dbo].[sfc_SPName]

@SCHEDULEDATE DATETIME

AS

SET NOCOUNT ON;

CREATE TABLE #splitmyrows (

Id...

I have to keep the nextval due to our ERP system. This will be a job that runs once a night, so there would be no concurrency issue. All I...

Thanks so much. That worked. I was getting to the point that I could not see the trees through the forest.

Ok, I am able to gather the missing gaps with the following:

SELECT distinct voucher vouchers,right(voucher, charindex('-', voucher) + 4) voucher

INTO #tempVoucher

FROM LEDGERJOURNALTRANS

where TRANSDATE between '10/1/2013' and '07/31/2014' and VOUCHER like...

Thanks. I will try that and as for the 2 sets of numbers 2010 and 2011, those are typos. Should be 210 and 211.

It works too a point, but it pulls all the records. If I substitute @Ord_Nbr ='12345' the script still pulls all the records and not the record that is =...

Thanks LutzM...always comes down to a syntax error doesn't it, LOL. And to the other responses, yes I did catch the word "and" which was in there when I was...

What do you mean you worked for us for 4 months in the spring? Sorry, don't recognize the name.

Both to ChrisM and Drew. I appreciate the feedback.

To Drew:

However, the correct name is not pulling up. The original code modified using everyone's input:

SELECT glbank.check_num

, glbank.ref_num

, glbank.check_amt

, glbank.check_date

, glbank.bank_code

, vendaddr.name

,...