SELECT CHARINDEX('1','~'+@str)/2

I had similar problems with SQL7 SP4 server and was having to do daily reboot. In the end increased size of windows paging file (beyond windows recommended value) and problem went...

SELECT TAGNAME,

REVERSE(LEFT(TAGDESC,PATINDEX('%[0-9]%',TAGDESC)-2)) +

SUBSTRING(TAGDESC,PATINDEX('%[0-9]%',TAGDESC)-1,CHARINDEX(' ',TAGDESC,PATINDEX('%[0-9]%',TAGDESC)-PATINDEX('%[0-9]%',TAGDESC))) +

REVERSE(SUBSTRING(TAGDESC,CHARINDEX(' ',TAGDESC,PATINDEX('%[0-9]%',TAGDESC))+1,LEN(TAGDESC)-CHARINDEX(' ',REVERSE(TAGDESC))-CHARINDEX(' ',TAGDESC,PATINDEX('%[0-9]%',TAGDESC)))) +

RIGHT(TAGDESC,CHARINDEX(' ',REVERSE(TAGDESC))) AS 'TAGDESC',

EUDESC

FROM tbtxt

After the first insert iCount is equal to one and not greater then one ????

True but the trigger...

The problem is the ROLLBACK in the trigger. It will stop execution of sql and therefore your test of @@ERROR wil not be performed.

If you remove the ROLLBACK you will...

Good article. Must admit though I have only used triggers once to implement cascade deletes (I know problems, problems ) when I converted an...

Yes, true but also check out 'Execution Plan Caching and Reuse' in BOL. Plan reuse and aging is dependant on several factors.

Money will always be displayed with four decimal places whether rounded or not

12.3456

will be 12.3456

or 12.3500 when rounded to 2 decimal places

if you want the values to have two decimal places...

Well the results are the same, the execution plan will be the same, so no difference. However the use of sp_executsql may be an issue. Any sql query has to...

Personally I would backup the databases, copy the backups to the new server and restore using MOVE option. If you keep the backups in a separate area on the new...

Hey Andy, bet you wished you never asked

What voting system you going to use

Layout #1 with the cube colours of #6

Just for reference, two possibilities

SELECT b.[Client ID],b.[Course ID],d.[Course Date]

FROM [Course Bookings] b

INNER JOIN [Course Details] d

  ON d.[Course ID] = b.[Course ID]

WHERE b.[Course ID] IN (SELECT...

The query worked for me when I create a test table.

Unless the data is sensitive, can u post the result of the following...