Yes, rCTE is expensive until if you use only tiny records, I have used only 12 records and i think it is fine..

Nice thoughts and suggestions!! But My idea is to keep the SQL script very simple, instead of creating the monthname statically we can go with the dynamic way.

Thanks,

Karthik

Here MonthName is a parameter where i can select the month. For example if you get the details of sales for the month of Feb, then you can select the...

You are welcome..

It is Interesting, Idea is to make the SQL script very simple and reusable. Thanks for your comments.

Yes, recursive CTE is also row by row. When you are not joined any tables then recursive CTE will restrict upto 100 rows.

Good Question!! This CTE does not depends on any tables. Think of the environment that do not have any tables which has the date for the consecutive month and you...

Never Mind, I found the problem.

Variable has not taken the full file name.

This post gives an idea about picking the particular element in XML, how can i insert the each element in each row?

Thanks for the prompt reply. Yes, we can achieve that in T-SQL however the requirement is to do only with SSIS package because there are other operations that we need...

Hi Luke and Steve,

Thanks for your information..

Basically, i am a SQL developer.

I have a task like, Need to pull the Out OF Office data for each employee from my company...

Hi All,

Thanks for your time.

I have used the date[art for the year and it worked fine.

Thanks and regards,

Karthik

Hey Jason,

This is the query i am trying to solve

Create table Billing (Id int, Name varchar(50), Workhours Varchar(20),Description Varchar(50))

Declare @strdate int

Set @strdate =datepart(mm,getdate())-1

Select name,Sum(CAST(ROUND(Workhours, 0) AS int)) as [Workhours],Sum(CAST(ROUND(Workhours, 0)...