Thanks for this post Samuel! This is something I can use too...

Michelle 🙂

Yes, that's exactly what I want to do. I would like to add my row_number () to my first script.

I get multiple duplicate rows but with different statuses. ...

Thanks, RBarry, I was able to get it to work...

Michelle 🙂

Wow, cool! Thanks. I thought the whole thing would have to be re-written.

I'm just getting this error now.

Msg 207, Level 16, State 1, Line 9

Invalid column name 'serial'.

Msg...

Thank you for the explanation RBarry, it worked now.

But now, I'm realizing that I don't think that's what I wanted to do. :crying: Here's an example of my...

Thank you RBarry,

That seemed so simple.

However, I'm getting this error now and my query isn't executing.

Msg 207, Level 16, State 1, Line 30

Invalid column name 'ORDER_ID'.

Msg 207, Level 16, State...

:w00t: Thank you Bruce! It works perfectly!

And thanks for the lesson it made sense to me. It acutally helped me understand what's in my code so I...

Here's an example of my data in the created_at column: 20090315060047

Any help is greatly appreciated!

Thanks

Michelle

Hi Wayne,

I'm not declaring any variables or creating any tables. and I'd prefer not to create any tables as I'm not the sole owner of the database and IT might...