Look up the DECIMAL DATATYPE IN SQL SERVER on your favorite search engine so that you'll understand that all you need to do is change the "scale" and maybe the...

Thanks Phils! But i really forgot to add an important point here what if the same emp for month 1 and month 3. Here 210 in M1 and M3.

That'll...

Hi,

Can someone please suggest, how this can be done?

I have a data region and date and Quantity. I want to display column(Region) and rows(Months) values as Quantity.

But when i...

I was able to fix the source that creates the jobs.txt and remove the space at the beginning of some of the records. Now The Code supplied by...

Do all of the files have a similar issue?  Perhaps you need to tweak the code to handle the anomalies.  Frederico offered a hint about that above.

And, no... they're...

Ah... there IS one major drawback.  If you have very wide tables with only a row or two per page and a lot of different columns get updated but only...

There's not much wrong with it at all.  It works the same way that I wrote such auditing in the past with it being "point-in-time" enabled.  It's nasty fast and...

My priorities have never changed... it's all based on the 3 "L's"...  I've not numbered them and their in no particular order because they each equally important to the others ...

Thank you for the very kind feedback, WebRunner.  Coming from such a long time regular as you, it means a lot.  Thanks again.

Looking back at that, it might make a...

A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many...

Do all of the files have a similar issue?  Perhaps you need to tweak the code to handle the anomalies.  Frederico offered a hint about that above.

And, no... they're not...

@inayarens ,

First, welcome aboard.

Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working account.  They also later come...

As a bit of a sidebar, your slowest queries are frequently NOT your worst queries.  Rather it's usually some fairly small stuff that gets called thousands of times per hour. ...

Check the code.  Do...