Nevyn,

Yes you're right. If the shipment is due pre-tuesday it will Scheduled ship date as Tuesday and for some reason if certain jobs don't ship on Tuesday, they will show...

Can somebody please give me a hand on this?

Thank you all for your help. I'm still little confused. I need to encrypt few tables (10-15) from the database. How should I go with it?

Thanks again

Can somebody give me a hand on this? Thanks

TheSQLGuru- SQL server is running under the account - NT Service\MSSQLSERVER . How do I add this account to access my backup folder which is C:\Backups-All\Backup?

Thanks for your quick...

Hi Jack,

The T-SQL you suggested works fine. But when the ExpectedDate has (10/28/2014 or 10/29/2014 or 10/29/2014 or 10/30/2014) the date does not change to Monday (11/03/2014). Can you please...

Sean- Thank you for the link. I will go over it. I'm new to T-SQL

Jack- Thanks.

Please help guys.

One last question to you guys. The report that, I'm working on is the quarterly report. When I change the @start date to (10/01/2014) on report, other three (@End, @NextStart,...

Jack & Rxm,

Thank you for your response. I'm new to SSRS and trying to get used to it. Sorry about that.

Amol

Jack & Rxm,

My other there parameters @Start, @End, @NextStart, @NextEnd are dependent on @StartDate (2014-06-01). How can I set the other three parameters (@End, @NextStart, @NextEnd) in SSRS expression as...

Hi Jack,

I appreciate your response. I've a quick question for you. My report is the quarterly report so, I would have user enter only the @Start Date. Rest of the...

Luis,

Thank you for your quick response. I'll play around with the dates to get better understanding. Thanks again.

Amol

Can somebody please help?

Thank you very much for your help. The code you sent works for me. The only problem is when I set @Date=2014-08-01 the Next_ShipDate shows 2014-08-04 instead of 2014-08-07 (Thursday)....