Hi Steve,

The solution you suggested is exactly what I need. Do I have to add extra column type to my table? If so, I can't add the column to the...

Any help is greatly appreciated

Still stuck with this issue. Any suggestions are greatly appreciated? Need help guys. Thanks.

Hi Jack,

I appreciate your quick response. I tried creating the same keys on my local SQL server as my main server has. Still no luck. Am I missing something here?

Thanks

I appreciate your response. I'm a little confused here. I read the article on Encrypt a column of data from the microsoft link. Below is the DDL. Do I need...

Need help!!

I meant row level encryption. Sorry about the confusion. Any thoughs how can I achieve that? Thanks

cunningham- Thanks for your response. I've never done the way you suggested. Seems like the best way to get the data. Can you give me a hand on this?

Alvin,

I know it's little confusing. A small correction. We are planing to buy Standard edition and not enterprise.

Cadavre- You're the best. Thanks again.

Hi Cadavre,

Below is the table for expected results and select query:

JobNumberRequestedDeliveryDateNewScheduledShipDate

J0123452015-03-162015-03-16

J0123462015-03-172015-03-17

J0123462015-03-192015-03-19

J0123462015-03-202015-03-20

J0123472015-03-242015-03-25

J0123472015-03-252015-03-25

J0123472015-03-262015-03-26

J0123472015-03-272015-03-27

J0123482015-03-272015-03-27

J0123492015-03-282015-04-01

J0123502015-03-312015-04-01

J0123512015-03-312015-04-01

J0123622015-04-012015-04-01

J0123632015-04-022015-04-02

J0123642015-04-022015-04-02

J0123742015-04-032015-04-03

J0123642015-04-042015-04-08

J0123652015-04-052015-04-08

J0123662015-04-062015-04-08

J0123722015-04-072015-04-08

J0123782015-04-072015-04-08

J0123672015-04-082015-04-08

J0123672015-04-092015-04-09

J0123672015-04-102015-04-10

Hi Cadavre,

I appreciate your response. This is exactly what I need but the future dates to show the same schedule Wednesday, Thursday and Friday. How can this be acheived? For...

thomashohner- Thank you for your response. Quick question. I will still need to pass the dates in my paramters if I have the required dates in SQL. Isn't it? Thanks

Nevyn- I appreciate your help. Thanks.

Hi Nevyn,

2) Can you explain why the last 5 rows should pick tuesday the 24th instead of Friday the 20th?

That's because starting March 16 we will be shipping only...