sorry forgot to add attachment

Hi,

Thanks for your help. one small doubt, How can i add dummy node. PFA . create table with data script. xmlnode.sql which i am using. provided resultxml vs requireresultxml...

Hi,

I have two table Account and Address both join base on accountuid. I have created xml using below code but it is not in format which i want. PFA...

Thanks Eirikur Eiriksson, i will try from my side first if i stuck anywhere will raise it 🙂

thanks for your reply. I had copy it and save it as xml but i dont have xsd file so i can directly use in SSIS package. any idea how...

sorry but i cant use strorproc

I Got the solution. i just convert int to decimal and its worked.

Thanks for your help

i am using below code

SELECT WORKFORCECD,DTE,MONTH,YEAR,PERIOD,LINEITEM,lINEITEMNO

FROM

(SELECT WorkForceCd, DTE, Month, Year, Period, TotalChargableDemand,DemandAdjustments, ActualForecastJoiners, CommitedJoiners, JoinersAdjustments, ChargableInternJoiners, UnmanagedAttrition, UnmanagedAttritionAdjustments, ManagedAttrition, ManagedAttritionAdjustments, OtherMovements, EndingSupply, SubContractors, PeopleUsingNonStandardTime, BeginningSupply, OtherMovementAdjustments, ChargableHourAmt, StandardAvailableHourAmt FROM...

currently i don't have any data in that table.

In table1 i have 3 years of data in same format , I need to insert values from different tables so i will create one query that will populate table2....

Thanks for your reply

if there is data for 2013 then it will be new row in #table2

9,2013

Thanks for your help.

Thanks for your time, Data will be null as of now. we need to populate data from application. for that i need to provide them this as a template.

Thanks for your reply, But i want output as id,name , sep-13,oct-13.......

months as a column name not as a value.

add your aggregate fields as a calculated filedS then use average function.