A fellow on this forum who goes by the name of "Adam Mechanic" would have you create a permanent date table so that you can easily solve these types of...

After reading the links that Frank posted and reading "Estimating Table Size" in BOL AND reading "Data Types" in BOL, I've kind of decided that it's just easier to remember...

Guess I didn't know that... how do you forward reference a temp table?

Thanks for the info!

This could be converted to a UDF to replace GETDATE() with a date for the month to find the last business day of...

The time included in the date takes you...

What's the lookup in BOL that proved so useful?

Nice job and you got right to the point.  Great comparison example against derived tables.  My hat's off to you.

Concur... a world of hurt lays ahead for those using Unique Identifiers in a casual manner.

... and, I agree, the customer code is the unique number to be used as...

Like I said, you have to give the hint "FIRE_TRIGGERS" to get triggers to fire during a bulk-copy or bulk-insert.  If you do that, then the inserts get "logged" in...

>"1000 Points whose values are coming after about every second"

Does this mean that the table grows by a thousand rows every second?  If so, some well designed indexes would help. ...

Not unless you specify the FIRE_TRIGGERS hint which also causes the operation to become fully logged.

Usman,

Charles is right, an IDENTITY column might help to guarantee row uniqueness is this case.  However, whether you have an IDENTITY column or not (sometimes can't change a table because...

Like I said, "Rather than using a view, ..."

Don't use @@IDENTITY which can be tricked by triggers... use SCOPE_IDENTITY() instead.

Always assign values captured in @@ROWCOUNT and @@ERROR immediately after the SQL that you want to check.  You can...

Very Nice article.  Covered a lot of ground and it's a pleasure to actually see commented formatted code.  I've seen a method to write to text files using linked servers...