Create a new database or upgrade to SQL standard edition.

You will need to convert col1 to an INT use;

...

Check your error logs there will be a more descriptive error message in there

Transactional replication does not invovle adding an extra column to your table

winston Smith (3/4/2009)

---

I have this condition in a select statement

tbl.columnName <> 'ACT'

In the actual table tbl.columnName is NULL. I thought NULL is not equal to 'ACT'. but nothing is selected...

Select FirstName + ' ' + Last Name as...

nymgk_75 (3/4/2009)

---

Hey Jeff,

Thanks for the reply! I like your way also...

Can you explain what the "U" is used for then? We didn't have that in the other...

Dugi (3/4/2009)

---

Instead of UNION use UNION ALL because the UNION statement select only distinct...

try this code..

SELECT ParentId , '--Parentid' AS TypeId

FROM YouTable

UNION

SELECT ChildId , '--Childid' AS TypeId

FROM YourTable

sqlcentral (3/3/2009)

---

steveb (3/3/2009)

---

That is why i asked for a unique column that defines the order, without a primary key on your table then this is going to be difficult.

is...

sqlcentral (3/3/2009)

---

Ok, perhaps my sample data...

This is not possible with db mirroring as each database needs to be kept in synch.

The best idea i can think of , would be to automate a restore...

sqlcentral (3/3/2009)

---

That will only...

This sounds like a reasonable approach.

The way I normaly handle things like this , would be to create a look-up table with all the JType values add a column ...

Thanks, this code should work orderd by Level

SELECT * FROM YourTable WHERE LEVEL IN(

SELECT MAX(LEVEL) AS LEVEL

...