Forum Replies Created

Viewing 11 posts - 61 through 72 (of 72 total)

  • RE: T-SQL to add 7 days to ship date

    Apologies for reposting the above question. I was not able to see the post after refreshing the page that's why I ended up posting multiple times.

    July 29, 2014 at 3:03 pm

    #1733398

  • RE: T-SQL to add 7 days to ship date

    In the below DDL, I have 2 jobs (J066811 & J066594) which show NEXT_SHIP_DATE as (2014-07-29 & 2014-08-04) instead of 2014-07-31. We ship the jobs only on THURSDAY of every...

    July 29, 2014 at 3:00 pm

    #1733397

  • RE: T-SQL to add 7 days to ship date

    In the below DDL, I have 2 jobs (J066811 & J066594) which show NEXT_SHIP_DATE as (2014-07-29 & 2014-08-04) instead of 2014-07-31. We ship the jobs only on THURSDAY of every...

    July 29, 2014 at 2:59 pm

    #1733395

  • RE: T-SQL to add 7 days to ship date

    In the below DDL, I have 2 jobs (J066811 & J066594) which show NEXT_SHIP_DATE as (2014-07-29 & 2014-08-04) instead of 2014-07-31. We ship the jobs only on THURSDAY of every...

    July 29, 2014 at 2:48 pm

    #1733392

  • RE: T-SQL to add 7 days to ship date

    In the below DDL, I have 2 jobs (J066811 & J066594) which show NEXT_SHIP_DATE as (2014-07-29 & 2014-08-04) instead of 2014-07-31. We ship the jobs only on THURSDAY of every...

    July 29, 2014 at 2:45 pm

    #1733391

  • RE: T-SQL to add 7 days to ship date

    Eirikur- First of all, thanks for all the help. I've a quick question. In the below DDL, job# (J066811 & J066594) have expected date (2014-07-29 & 2014-0728) respectively. The NEXT_SHIP_DATE...

    July 29, 2014 at 2:43 pm

    #1733390

  • RE: T-SQL to add 7 days to ship date

    In the below DDL, I have 2 jobs (J066811 & J066594) which show NEXT_SHIP_DATE as (2014-07-29 & 2014-08-04) instead of 2014-07-31. We ship the jobs only on THURSDAY of every...

    July 29, 2014 at 2:35 pm

    #1733386

  • RE: T-SQL to add 7 days to ship date

    Eirikur Eiriksson- Thank you very much. The T-SQL statment you suggested works. Thanks, again:-)

    July 29, 2014 at 1:27 pm

    #1733373

  • RE: T-SQL to add 7 days to ship date

    Can somebody give me a hand on this? Stuck with issue.

    July 29, 2014 at 8:41 am

    #1733240

  • RE: T-SQL to add 7 days to ship date

    Here is the DDL. Suppose, if today's date is 2014-08-01 and we miss the shipdate for the job# J012362, the 'TestNewShipDate' still shows 2014-07-31 instead of 2014-08-01. I've also included...

    July 28, 2014 at 3:57 pm

    #1733045

  • RE: T-SQL to add 7 days to ship date

    Hi Eirikur & SSC,

    I appreciate the response from you guys. I apologize for not being clear before. We have jobs that only get shipped on Thursday of every week....

    July 28, 2014 at 7:44 am

    #1732844

Viewing 11 posts - 61 through 72 (of 72 total)