This is probably one of my own biggest pet peeves. I may not...

Well... no... but...you see... what had happened was... there was this thing... and... LOOK OUT A BUTTERFLY!

@AllMarketsCount is 16 and @UploadedMarketsCount is 6.

IF @AllMarketsCount = @UploadedMarketsCount

This is returning 0, which is correct, however, if I change the "=" to for example "<", the result is still...

Haha, I was wondering if you'd throw down on this one :w00t:. I don't disagree that aliases are better when they're descriptive. ...

If I've gotta join it to anything, it's getting aliased. Which means, you're correct, I've probably never used a 5 parter either, didn't really think about it =) ...

MyServer.AdventureWorks.dbo.Products.ProductID

Server.Database.Schema.Table.Column

You use it in linked server queries.

Good info Lynn, thanks.

Just to clarify though, 3/4/5 part naming in the FROM clause isn't being touched, this just seems to imply that they want you to alias the tables...

A few things:

1. Please refer to the article in my signature for how to post sample data in future posts. (Your sample data will end up looking like...

The only part of that proc that should cause a lock (to the best of my knowledge anyways) is the update statement. Even then, that should be a...

Actually, I take that back, I've actually been told that it's best to use FULLY qualified names (which I would alias immediately of course). IE.

ServerName.DatabaseName.Schema.Table.Column.

Also, keep in mind that you can always use GETDATE() within a stored procedure to grab the current Date/Time without having to pass it in.

Lynn,

Where did you read this? Everything I've ever read suggests 3 part naming due to different schemas.

A temp table and the running totals method should handle this with no need for a cursor or a correlated subquery. You'll also get the additional benefit of being...

Oops, missed the first line in your request :blink:

In any case, you have a "go" in the middle of your script. This changes your scope and causes your variable...

First, due to the fact that you need the table for a few days, scrap the ideas of using a table variable and a local temp table which will go...