drew.allen (8/10/2016)

---

There were actually two problems. twin.devil corrected both, but only mentioned one. The second problem is that jobno is an attribute, so you need to use "@"...

<Boot><JeffModen>"+1"</JeffModen></Boot>

🙂

while working with xml, please make sure you are using the exact same name, because XML is Case - Sensitive.

The problem is you need to change the "jobs" into...

SELECT

PromotionInd

, ISNULL(MAX(case when vChargeCode = 'BRK' then vChargeCode end),0) AS BrkChargeCode

, ISNULL(SUM(case when vChargeCode = 'BRK' then [ChrgAmt] end),0) AS BrkAmount

, ISNULL(MAX(case when vChargeCode = 'CLR' then vChargeCode...

SELECT

PromotionInd

, ISNULL(SUM(case when vChargeCode = 'BRK' then [ChrgAmt] end),0) AS BrkAmount

, ISNULL(SUM(case when vChargeCode = 'CLR' then [ChrgAmt] end),0) AS CLRAmount

, ISNULL(SUM(case when vChargeCode = 'BIN' then [ChrgAmt]...

User7766 (8/10/2016)

---

Hi Twin.Devil,

Here is the desired output I'm expecting from the input data that...

you Output table is not conclusive, Kindly share the output data according to your sample data.

Well, Most of the time that is really the point.

On a side note,...

I'm no sure but i believe there is a calculation issue in your expected output.

/*****expected output**************

13/1/201612001.2

14/1/201614401.3

15/1/201618201.5 ----- This Should be 1440 * 1.3 = 1872

16/1/201629121.6 ----- This Should be 1872...

Nice question, Thanks for sharing.

Well 1st you need to understand What Ltrim does. Check the following link for detail.

In Short Following is the definition of these function

RTRIM and LTRIM simply remove spaces from a...

is this one is one time report or you want to store it one historic basis and want to compare data on different dates?

Quick suggestion, you can you PATINDEX to validate Email as well as to get the Birth Year from the email address.

select dob, adj.YEAR_OF_BIRTH, email, IsValidEmail

from

(

Select cast('20160101' as datetime) as...

Check this link

All I can think is there's some condition, like a timeout setting or something in PHP causing it to fail. But when I run it from SQL Mgt studio, it...