Oh oh... how do you store dates from previous century (1999 etc.)? Are there none, or are they simply missing the "century digit"... like 60313 meaning 1906-03-13?

So far I've come...

It seems that the "1" at the beginning is a nonsense (or has some meaning not connected with the date... most probably it is there to avoid losing the leading...

There is a possibility to enter the item ID's as a delimited list (VARCHAR data type). Then inside the stored procedure you can parse the values, insert them into a...

I'm glad it worked... good that you could add identity column to the staging table - just make sure that it always starts at 1, if you are going to...

Well, then I don't think you need a special table to hold the last value. You can get the highest existing value from the table itself by SELECT MAX(SEQ_NUM) FROM...

I think the real question, disregarding description of various attempts how to solve it, is this:

There is a table with column that would normally be identity column. However, design does not allow...

OK, now I understand more or less what you need. Check David Burrows' solution, it does precisely what you described, and it is a lot simpler than your code.

After re-reading your last post again, I begin to see the light... but what should happen if @field_1 = 'field'  and  @field_2 = 'forest' ? Is that rated 0 because...

Fine, you're setting the indicator. But WHY are you doing that? What is the purpose of the indicator and how is it used later? That's what we can not understand...

It looks to me like some search with evaluation which of the found items is most corresponding to criteria, or something like that. Not sure though... and I still don't...

Excuse me, could someone explain to me what data type is NBR? I suppose it is some number, but couldn't find anything more precise about it. Thanks!

Look up TRUNCATE TABLE in BOL:

Permissions

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are...

Troy,

I agree with Sergiy. You need to have precise description of the process first, only then you can try to implement it in SQL.

Somebody has to tell you what they...

Hi Mark,

no, WHERE clause can contain any column from the respective tables, not only those that are returned.

If you need to issue several different select statements, always using data from...

What do you mean by "execute a select statement in that particular company"? Should we understand it so that each company has its own database and what you need is...