from BOL

so you will not be able to go to 5 decimal places...

Okay sorry i misread the question.

the examples you gave are probably the...

From what i have found , they are usualy not directly advertised, but it can be mentioned in the Job Description.

I usually bring it up it interviews to see if...

select people_number,web_role from

where web_role = 3

union

select people_number,web_role from

where web_role = 8

this may not be the most efficient way though.

Char(32) is the ISO code for a space

http://htmlhelp.com/reference/charset/iso032-063.html

the replace function searches for all instances of space and replaces them with rtrim("") (nothing)

We have the option of working from home,

I agree with the comments about a messaging system we use Microsoft Office Communicator which works nicely as it ties into your Outlook...

try using

group by cast(words as varchar(max))

though depending on how long the text is this could be very inefficient

This could be related to SQL server clustering,

check your system logs to see if there are any errors that would prevent the clustering service from connecting to the SQL server

that is the right place to change it, but you need to supply a Reg Exp something similar to

SET @i = (SELECT PATINDEX((>(?: (? [^<]*))) ,@String))

should work, ...

An easy way is to use Reg Expressions, i wrote this code to strip out some tagging in a sql2005 database. You will have to change the PATINDEX('%[^a-z^0-9^_-]%', ...

The problem is the number of where clauses that are using the Ltrim Rtrim function, this means sql server must run the function on each row before it determines a...

As the others have mentioned this could be a complex task,

How many rows of data are you trying to match?

Depending on the number of items it may help to setup...

You could make this a constraint of the database to only allow upper case. Of course the best way to ensure this would be to update your stored procedures...

You can't use Group By as part of an Update query, if it meant to be part of the sub-query then you should enclose it in ')'.

You...

Start by having a look at the query execution plan to see where all the processing is taking place.

You may have to rebuild or recreate your indexes.