Thanks for your reply . I am using XML source as a data flow source and pointing it to photos as well as Ads table . This works fine .

But...

I get the following error "Cannot bulk load because the file "C:\Documents and Settings\pbaruah\Desktop\test.xml" could not be opened. Operating system error code 3(The system cannot find the path specified.).

"

after excuting...

Below is the query that I am using

INSERT INTO TestPB(firstname, lastname)

SELECT X.product.query('fname').value('.', 'VARCHAR(30)'),

X.product.query('lname').value('.', 'VARCHAR(30)') ...

I am getting the following error after running the query below :

Cannot bulk load. The file "C:\test.xml" does not exist.

DECLARE @xml XML;

SELECT @xml = (

SELECT * FROM...

Thanks it worked when I used dateadd(dd, datediff(dd, 0, getdate()), 0) inplace of '11/4/2009'

Thanks all for your help . I have already solved the problem .

Thanks a lot . That worked .

No preference on Name .

Thanks for the prompt reply .

The below query is raising the following error :

with cteWithRow( RepName,CampaignID,CampaignStartDate,[Type],Purchased,Cost,Used,Balance,BannerRevenue,As_Of_Date,Rown)

as

(

Select RepName,CampaignID,CampaignStartDate,[Type],Purchased,Cost,Used,Balance,BannerRevenue,As_Of_Date,

...

THANKS .

Thanks .

Thank You . It works fine .

Thank You for your reply . Your solution shows fy_month_start =3/29/2009 and fy_month_end ='4/25/2009' but its supposed to be '3/27/2009' and fy_month_end ='4/23/2009' .

For 2010 the fiscal year starts from...

The business rule is

Begins Ends

27-Mar 23-Apr ( 4 weeks)

24-Apr 21-May ( 4 weeks)

22-May ...

No. The fiscal month is not static year to year . For 2010 its 3/26/2010 .