Forum Replies Created

Viewing 15 posts - 1 through 15 (of 45 total)

  • RE: Help with query

    Luis Cazares - Thursday, June 15, 2017 9:29 AM

    Here are a couple of options that are equivalent to each other, but different...

  • RE: Help with query

    Jacob Wilkins - Thursday, June 15, 2017 8:47 AM

    Something like this should work:


  • RE: Optimize SP

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


  • RE: Career advice - Urgent

    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,...

  • RE: Career advice - Urgent

    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...

  • RE: Career advice - Urgent

    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...

  • RE: PHP to SQL

    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...

  • RE: PHP to SQL

    okay, will give that a shot! Thanks again

  • RE: PHP to SQL

    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...

  • RE: PHP to SQL

    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...

  • RE: PHP to SQL


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


    E(n) AS(


  • RE: PHP to SQL

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

  • RE: PHP to SQL

    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...

  • RE: PHP to SQL

    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,...

  • RE: PHP to SQL

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

    DECLARE @tblMonths TABLE


    dtMonthStart date,

    intDaysInMonth tinyint



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

    @endDate date =...

Viewing 15 posts - 1 through 15 (of 45 total)