[ArticlesInStock]

IdLog---IdArticle

101 --- Art1

102 --- Art1

103 --- Art2

104 --- Art2

105 --- Art2

106 --- Art2

[Orders]

IdOrder --- IdArticle --- IDDestination --- Quantity

201 --- Art1 --- 1 --- 1

202 --- Art2 --- 1 ---...

I took this as a challenge and tried to come up with something for you, unfortunately, even though I have SERIALNO in three aggregate functions, QA rejects my ORDER BY...

I get it, thanks to all of you. I though I coul substitute the SELECT statement with an UPDATE one to achieve what I wanted.

Actually, I was asking for an UPDATE statement.

I would like to extend this code to change the datatype for a column common to all tables in my database to tinyint. The column exists on each table with...

I think it would be better to make and run ALTER scripts to modify DB structure on production servers.

I cast my vote with all those who advised against sequence tables and promoted pure single-series auto-incrementing.

Point noted again, thanks to all who contributed.

Yeah, I appreciated that.

Asela,

Am I gettin you wrong OR are you actually trying to sum up dates? If you want to sum up some other numeric values by date or if you want...

Thank you Chris. We keep a primary key column for these tables because the main text column can be modified by users.

Apparently someone long ago decided that the key series...

How will your UPDATE statement be passed - using a recordset object or Execute function?

select DATEADD(d, 0,

DATEDIFF(d, 0,

(DATEADD(d, -(datepart(dd,s.date_shipped)-1), s.date_shipped))))

as Date_Shipped,

I took a look at your statement and cannot make any head or tail of what you are...

Could you be a bit more specific? What are you updating (or how) if you do not know the data?

Good question (meaning I don't have a good answer).

I've thought about it for a few times also (doing away with showing the users the serial numbers), but every time I...