SELECT
   YT.Cash_Locale ,
   YT.Cash_WTD ,
   YT.Cash_PTD ,
   YT.Cash_Daily ,
   DT.MaxCashWTD ,
   DT.MinCashWTD ,

 ...etc

FROM dbo.YourTable AS YT, (
...

I am not a SAN expert but my understanding is that it depends how your SAN is organised.

My understanding is that RAID5 is slow for writing (because of its striping...

DECLARE @NextAccount INT
SET @NextAccount=0

WHILE @NextAccount IS NOT NULL
    BEGIN
        SELECT @NextAccount=MIN(acct)
        FROM dbo.YourTable
...

Save yourself months of work and buy Apex SQLDoc or Innovasys DocumentX.

I spent 4 months documenting a huge database and then found out that DocumentX could do it in under...

CAST(YourField AS YourDataType)

YourDataType could be REAL, FLOAT, DECIMAL etc.

So the client wants a system that gains an extra 5,000 pages per week and at present has 1.5 million pages of records which they insist that they will page...

I think the point with "never look onto tables directly" is that if you give read access to the table then someone can decide what they want to read from...

It sounds as if SQL Server is escalating the locks from ROWLOCK to PAGELOCK.

Sometimes an EXISTS clause can give the desired results.

Let us suppose that we have a sales territory broken down into

Country - > Region - > Area.

The marketing dept are forever...

You should not delete the LDF file.

BACKUP LOG (your db name) WITH TRUNCATEONLY

Then run sp_helpdb for your database to get the name of the devices within the database.

DBCC SHRINKFILE (the...

You have to tell SQL2005 that it can use the CLR using the surface area configuration tool

CAST(YourField AS TINYINT)

or

CONVERT(TINYINT,YourField)

Byte can hold values from 0 to 255 so the SQL Server equivalent is TINYINT

SMALLINT is a signed 16 bit integer -32768 to 32767

INT is a signed 32...

SELECT SUM( 
   CAST(weight * points AS DECIMAL(10,2))
   / CAST(100.00 AS DECIMAL(10,2))
)

In other words it allows you to use worst practices

I think you are running into the ISNUMERIC issue where it returns 1 even when the number is not strictly numeric.

ISNUMERIC allows certain non-numeric characters to be identified as numbers.

E...