SSCrazy - Thanks for the script man I have been testing it for 2 days with no problems whatsoever as long as I manage the growth of my transaction log....

Thank you for all the thoughtful responses. I guess the answer is no, I should not reorganize or rebuild during working hours. I think the best way for me to...

Thanks for the information guys! I will start doing this manually via script from now on. I will begin by breaking down the script I have been linked and go...

You know I actually have no idea, the job was just originally setup to run that way. What I do notice is that every time the t-log backup runs after...

Yeah sorry I should have included that info:

The delivery instructions field will contain many different types of data such as :

UPS delivery next day acct num #999999# or

UPS FAST...

ok....

So I have been reading up on my Charindex's and whatnot and with the code that I have been giving. I have come up with this Charindex for grabbing whatever...

Hey guys thanks for the reply:

In the program we are using I have a field called "UPS Shipping Instructions"

This field can contain anything value so the users go free-for-all on...

Wierd to me to.. the other way works perfectly for me?? I checked the field and it is

decimal(19,0) null

Is there another way I can write this same case statement...

Yup exactly thats my issue is that my values in UPS_Final are never set to null. When I execute with a matching number I get a value in UPS_Final and...

OK could someone help me re-evaluate my statement here. I am looking to only use this CASE when these values (105188, 105191, 105194, 105197, 105200, 105203, 105206, 105209, 105212) are...

Bah im an idiot.. I tried like 5 diff switches before that haha