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...

So basically your management are asking you to run a marathon but have chopped off your legs?

If all your view does is a select of all columns with no WHERE clause then the only reason I can think of for doing so is to provide a...

Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm

Are you talking about UK counties?

There are only 86 counties in the UK so it is probably quicker and cheaper to derive the data yourself. http://www.abcounties.co.uk/counties/map.htm

You need to allow for

CHAR(9) = TAB

CHAR(10) = LF (Line Feed)

CHAR(12) = FF (Form Feed)

CHAR(13) = CR

DECLARE 
    @ControlCode VARCHAR(1) ,
    @WhereClause VARCHAR(3)

SET...

Years ago I started off prefixing tables with tbl, views with vw etc but moved away from doing that when I found I needed to replace a view with a...

You need to look at AWE memory.

Adventures in AWE

If you look in sysaltfiles within the master database check the size * 8/1024 for the size in MB.

It certainly works for TEMPDB however, if your database was built without...