you probably want to show us the two expressions, and how you want them to be used together , i would think.

a crappy example is the ISNULL function is an...

glad i could help a bit g_dion; i'm glad you were able to do what you needed to.

what i...

discovered that my problem was the period in the pattern...the period matches an character except a new line...the patter i'm using, if anyone else ever needs a regular expression to...

weird, I've always been told that a backup from a previous version(2000,2005) can be restored on 2008.

my google-fu found this link at MS, which says you can get that error...

you'd get much better,understandable answers if you were able to provide the CREATE TABLE definitions of your two tables; psuedo code like table_new and table_old is not nearly as useful...

i have to go with lobbymunchers suggestion; a standard parent child relationship would be much more appropriate; i think you are mentally locked into bitwise operations because it's neat to...

the command is extremely basic, all available in books on line;

use database1

drop user webdev

use database2

drop user webdev

what are you having trouble with?

you definitely need some coffee; god knows i've drawn blanks like that before my daily caffiene infusion.

if you need the max(payment date) per company, you simply need a group by;

something...

Thanks Gail!

here is a sql 2000 compatible example; this is updating a third column in the table to contain the concatenated values;

you might be able to adapt this example to your...

you can use the old backwards compatible sysusers view or the newer sys.sysusers view in 2005 and above:

select * from sysusers

select * from sys.sysusers

that is different fromt he logins that...

Erik can you give a code example? I've recently found the IP address like this whenever i needed it:

select client_net_address from sys.dm_exec_connections where session_id = @@spid,

if there is another...

the row_number() function will do what you are after, as long as you are in SQL 2005 and above;

something like this will work:

SELECT COL1,COL2,COL3,COL4,ROW_NUMBER() OVER (PARTITION BY COL1,COL2,COL3 ORDER BY...

if a calculated column exists in the table, you MUST supply the column names.

insert into mytable

select 1,2,3,4 --will no longer work.

you must say

insert into mytable(col1,col2,col3,col4)

select 1,2,3,4

show us the...

you cannot include the computed column name in any insert/update/delete statement;

so if you were doing something like

INSERT INTO SOMETABLE(PK,Value,computedvalue)

SELECT 1,3.1415,2*(3.1415)^2

--it must be changed to

INSERT INTO SOMETABLE(PK,Value)

SELECT 1,3.1415