Thank you so much for all of the help. It's really marvellous. I used Alan Burstein's PatExclude8K, and it did work perfectly for me.

Regards,

Minh

This is really great! Thank you so much for your help Mr. Grasshopper.

It worked exactly the way I wanted.

We use the first sale to pick the first sale of the next 2 month. That's the only rule as they gave me. We know that is the routine.

Thanks,

Minh

Yes, I have 2 servers (both s2k8 enterprise)

I used secondary database on the warm standby to create snapshot, not the source on primary server, and I want my users to...

There was no specific error. The restore job in logshipping just failed with no msg. Right after I drop the snapshot, the restore job runs fine without any problem. I...

Thank you so much for all great help!

Have a great day!

Minh V

Thank you very much for your help. Yours worked for 2k5 perfectly. Unfortunately, we still had 2k. Is there a way to work around.

Minh V.

You can use xp_cmdshell to rename file:

exec xp_cmdshell 'ren \\pamfitdwstg\d$\test.xls test_new.xls'

Minh Vu

I normally do this:

- Create the exact same table structure with the original one and give it new name

- Copy only data that you need only over to this new...

Thanks a lot for your help. I got that, too. But it won't help much. My current stupid solution is to kill the logshipping job, rebuild the indexes, shrink the...

Yes, table does have identity column.

Data will always have both weight and height; otherwise, they will be null on both fields.

Maijoe

Thank you so much for your help. I'm sorry to overlook the data. Your query works perfectly for the data that I gave before. Sorry about that.

My data actually...

To be clear, if data is '123.1, 135.4, 126.5', I will want it '123.1, 126.5, 135.4' (sorting data in rows) so that I will always have the data the same...

Yes, that is exactly that I like to do. Is there possible.

Thanks,

Minh

F1 may have more than 2 values, but they will be treat as seperately.

Minh