you can try the isnumeric function:

WHERE ISNUMERIC(SOMEVARCHAR) = 1

but as others will tell you, it's not 100% reliable, because of the way it is structured; for exampel

select isnumeric('1E2')

select isnumeric('1d2')

all...

you need to change the isnsert so that it has your objnum in it, typcially by joining to the right table.

for example, if you have a lookup table that has...

in my experience, when the same query doesn't run right on two different servers, i check two items first thing: statistics and parameter sniffing.

statistics on one server might be up...

ok here's an example for you to play with to understand the concept:

create the two tables, and select from the two tables after every step;

this example says if columns 3,4,5,6,7...

all i meant was you are joining lots of tables in this query....if any two of the tables have a column named PARNT then you will get an error that...

first thing i notice is you declared 43 variables, but only use one of them; i guess there's more to this than you pasted?

next a minor thing is that your...

you could easily do this automatically in a trigger, especially by using the new COLUMNS_UPDATED() function that exists for triggers in SQL2005; if a change occurs, you could have a...

if your dev machine is running SQL Express or SQL Express Advanced, SQl Server Agenct does not exist; it's not part of the featureset, and i suspect that is what...

aw come on, you know what i mean...Dev is limited to a max of 10 connections, instead of limited only by memory in the full version, a couple of...

the portion you pasted has a trailing slash and closing bracket for your CS2 connection...was that just a copy/paste error, or could it be the issue??

Password=xxxx"/>

compatiblility in that case means it won't fail on install...it'll install the tools no problem.

but as you've noticed it will not install everything. That is by design.

People are a bit...

you have to check the 2 digit months first, because months 10,11, and 12 all match the january single digit criteria!!

[font="Courier New"]

SELECT yearmonth,

CASE

WHEN (SUBSTRING (   [YearMonth] ,5,2)='10' )  THEN  (SUBSTRING ( [YearMonth]...

in my case RB_TABLE has two indexes; that table has a clustered index one column, and a non-clustered on the exact same column for some reason; but looking at all...

OK Gail put your thinking hat on, because you've got to double check my work.

I'm combining a couple of scripts i had laying around to try and find statistics that...

i know what you mean;

I wrote this neat function that returns the DDL of a table, along with it's indexes....you know, CREATE TABLE.....

works fine in any database, but of...