Parameter mapping is on the input, ie passing variables TO the query, the next item down is result set, it maps output FROM the query to variables. You can...

What is your key structure on that table?

If no key then just chose a value that falls between the current 2nd and 3rd positions.

However, I would say ever...

GROUP BY Asset_ID, To_User, MAX(Change_Date)

Comes to mind.. You might have to put the home MAX(DATEADD.... logic in but I think this will work..

CEWII

I think there is a better way..

As a matter of fact I can think of two..

First way (best):

1. Build a table that contains the text values and the id of...

Although I hate to say it this way, it depends..

But first, it seems a simple inner join would more than suffice for what you want, just join the header to...

I too found it to be kind of sketchy in SSMS, where it was screwing me much more often than helping, I too shut it off. I had similar...

The data might not be, but if you have a column in the destiantion table that you are not populating during the data pump it can cause this. Is...

I think Ed is right on, there are almost no good reasons to try to upgrade master and msdb, with that said, there are probably things in those databases you...

Yikes!

I don't blame you for not wanting to administer another server, but like many things its a question of cost, is the maint/admin costs of the box acceptable in light...

That option ONLY works in BIDS, it has no effect during a run outside of BIDS.

As far as calling it from code, that has me stumped too, I...

I couldn't agree more, there is no reason to incur the overhead of a cursor, just adding the base table with a join on the keys should work great.

CEWII

I still think his best bet is to trace it, then he can see exactly what is going on..

CEWII

It is really not obvious until you understand it, then it is really a, "I can't believe I didn't see that.."

CEWII

I have to admit, I like Phil's process..

CEWII

I checked out the article in the other posters response and generally disagree.

As I see your question I see two parts, the first is definition, the field should be defined...