YSLGuru please provide the beginning to the UL_batch_header stored procedure as that would greatly complete the picture of what you are asking about. Otherwise, I concur with ScottPletcher assessment although...

Okay you did not answer the question I posed about whether or not the date-time stamp gets changed based on an Insert versus an Update -- that was an assumption...

Well there is actually numerous ways this can be approached actually but most of them are going to greatly depend upon the layout of the current table as well as...

• This reply was modified 5 months ago by  Dennis Jensen.

The actual issue is this:

SELECT hMy, *

Why might you ask because hMy also appears within the * listing so which hMy are you attempting to sort on?  That is ambigious.

Duplicate

• This reply was modified 5 months, 3 weeks ago by  Dennis Jensen.

I am not sure what the issue you are having exactly but it seems if you just looked up String_Split that you would be able to implement what it...

Okay well the problem seems to be within your CASE statement and not the conversion out of your case statement the question is what is the largets numeric value that...

• This reply was modified 5 months, 4 weeks ago by  Dennis Jensen.

Okay not wanting to confuse things I would say based on your most recent information that the solution presented by Jeff Moden would be a good method of doing this and...

If you are using MS SQL Server you would use the Snapshot or Read Uncommitted (or something like that) and make sure you grab only the information that is post...

• This reply was modified 6 months, 2 weeks ago by  Dennis Jensen.

Great EM2 so that simply shows you how to find duplicates and overlapping indexes which was not your question. Further their final solution was simply deleting the offending Indexes that...

Okay Jeff Moden that is a great point.

Although being knowledgeable about Indexes I might off-handedly state that I would simply modify the Index even though that technically means I delete...

• This reply was modified 7 months, 1 week ago by  Dennis Jensen.
• This reply was modified 7 months ago by  Dennis Jensen.

Phil Parkin - I have been going with the idea (aka assumption) that similar is what is being referred to here as otherwise there would be no need to merge...

Really Jeff Moden that would be interesting to read (or see) -- your proof in a presentation -- as I find that a rather interesting stance and would greatly like...

• This reply was modified 7 months, 1 week ago by  Dennis Jensen.

Jeff Moden based on what ScottPletcher stated I do not see how one would end up with 2 Indexes as he did state you Drop one of the Indexes and...

• This reply was modified 7 months, 1 week ago by  Dennis Jensen.

Note I will be here for as long as this site exists for by far it is the best forum for getting and giving quality SQL knowledge. I have long...