So change it again:

case when servcdate < CONVERT(datetime, '20040101', 112)...

Don't know. What is the error? You need to find and read the maintenacne plan log files.

Read this article How to Post Performance Problems[/url].

Follow the instructions in it regarding what needs to be posted so that we can provide you with better answers.

Without that information the...

Personally, I think Lowell has given you what you need to develop a set-based process for copying the records needed from one set of tables to another. I think...

Yes, you could potentially make the view an indexed view. You really need to read about those in BOL (Books Online, the SQL Server Help System) before going down...

Now that the Star Trek Universe has been altered, they have opened the door to new series and movies. I wonder how these things will pan out in the...

Was on a staycation for the week and didn't visit the forums often. Thanks for the feedback. Glad we could be of assistance.

Your question is fairly vague. What exactly are you looking for?

Why are you shrinking your databases? One, this will cause excessive index fragmentation. Two, the files will simply grow again when the database needs more space that will...

Okay, thanks for a partial setup, but please look at how I am presenting my code, including the DDL for the tables, the insert statements with the sample data. ...

Also, please be sure that your sample data and expected results match. In the code provided, they aren't even close.

kaladharreddy15, when you post code for people to use/test, particularly DDL and load procedures, please be sure you have tested it and it works. I started looking at your...

Hey Bob, Glad to see you back! Nice name change! 😉

Are you saying that I shouldn't play with what's left of an old mans mind?? Trust me, I'm...

Looking it over, there still appears to be some information missing to help answer the question fully. I'll have to look at in more depth when I get home.