Thanks for the reply guys, I'll use CTE's instead and break it down further.

Regards

Hi Eric,

Thanks for your reply. I have made my mind up and have decided to sign the contract with Company A. Hopefully as I get more experienced in the field,...

Hi Lowell,

Thank you for your advice.

I agree with you that once i have crossed the 35k mark it will be easier for me to get equivalent or even higher salary...

After talking to some friends and work colleagues I think I have made up my mind now. I have decided to go for Company A because:

1. Flexibility - Better chances...

The cursor worked fine with the sp_executesql I have set the stored procedure to insert into a table every time its called. Thank you ever so much for your...

okay, will give that a shot! Thanks again

Thanks Luis, that explanation was very helpful!

I tried using a cursor but i get following errors which don't make any sense to me.. Would you be able to have a...

When I run the above query I get the following error:

EXEC rept.spUsageReport_v3 8, '20121201';

INSERT INTO tblUsage_all (clientNumber,client,subscribed,Lapsed,Q1,Q2,Q3,Q4,[Quater Total],logged_in_30day,logged_in_90day,system_usage_30day,system_usage_30day_percent,previous_usage30day,30daypointchange,syst

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '30'.

Msg 102, Level...

Hi,

I do understand most of the query you wrote but some bits i dont get. Could you please explain what you are doing here

WITH

E(n) AS(

SELECT...

Brilliant, thank you so much for your help. Really don't want to touch the stored procedure because that is another puzzle.. :crazy:

Hi Luis,

Thanks for your reply!

What I am trying to achieve is:

Send in each rep id and month (starting from given date by user to previous 24 months) into the stored...

While I wait for your replies, this is as far as I have got till now with my cursor. If you point out anything please do correct me

DECLARE @id INT,...

I have managed to create a months table and cross joined it with the reps table

DECLARE @tblMonths TABLE

(

dtMonthStart date,

intDaysInMonth tinyint

)

DECLARE

@startDate date = '2014-01-01',

@endDate date =...