"Minimal thinking effort is always useful in programming"

My theory goes:

The entire human progress was driven by the lazy ones.

The whole objective of the...

Another reason to format the datetime on the GUI is sorting. If you return a dataset with a datetime column and you present it in the data grid you have...

If you need the size of the tables including the index pages then use this

SELECT name, dpages, reserved, rows

FROM sysindexes

WHERE indid = 0

AND impid = -1

ORDER BY name

Where reserved is...

Size of a table is not a precise requirement but if you run this you should get the number of datapages used by each table and number of records.

DBCC UPDATEUSAGE...

SQLBill,

Thanks for the reply.

Since the app and the server reside on the same computer I was just trying to get an opinion if one of the authentication methods (Windows or SQL) is...

Sergiy,

Of course I noticed the post that fixed the original function. This is the "-Add more of the red tint. -Worked fine, thanks" exchange in my little "non-technical' recap.

The biggest...

Let me recap this for you using non technical terms

- I have a red paint but the color comes out pink.

- Add more of the red tint.

- Worked fine, thanks.

-...

Instead of using #temp table use the table variable. It should work faster and is not creating any locks on the master db. And yes, sometimes when the initial record...

If Tomm's solution works then this might be a bit faster because it should only do one pass thru the table. Since I have no data I could not test...

Scott,

If you do not bulk insert you may just use a SP that will accept data for both tables and inside your SP you insert part of the data into...

Oh boy, I think there is more then 5 of us watching this...

I just don't understand what the argument is all about anymore....

The problem might be in your sp_SearchText.

As I mentioned above you should not use the ROUTINES view to search the text of a SP. (To see the code INFORMATION_SCHEMA.ROUTINES uses -...

In this case just replace the

'%[^''a-Z .,-]%'

with this

'%[^' + CHAR(128) + '-' + CHAR(255) + ']%'

and see if it works for you

Is something like this you are looking for?

SELECT S.item, MAX(Invoicedate)

FROM Stock AS S

LEFT OUTER JOIN Invoicedet AS I ON I.item = S.item

GROUP BY S.item

HAVING ISNULL(DATEDIFF(day, MAX(Invoicedate), getdate()), 61) >...

Very logical post but totally misses the point.

THE BANKERS ROUNDING IS NOT ABOUT PRECISION!!!

It is about distribution. It is STATISTICAL function.

This disussion was fun for a while but it is...