Hi and welcome to SSC.

The first I did was run through a formatter so I could read it.

SELECT client_name

,client_id

,web_id

,CASE

WHEN active_hierarchy.trending_id IS NULL

THEN 1 -- web_id expired

ELSE CASE

WHEN mapping_is_historical...

Are you sure you even need a cursor? Given that you want...

ChrisM@Work (5/1/2013)

---

Sean Lange (5/1/2013)

---

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a where clause.

Here is the...

So what exactly is the issue here?

I would suggest you use the newer join constructs. With this query you don't even need a where clause.

Here is the syntax:

from batt_State s

join...

As Rob said in his first post....NO. You can't restore a newer versions backup on an older version.

All of the subsequent posts explain in detail how you can get the...

vgregdo (4/30/2013)

---

Hi,

I have an existing piece of code that navigates through a hierarchy and was trying to figure out if I could write a query that would return a result...

After running this through a formatter so it was legible it becomes pretty clear.

DROP TABLE a

GO

CREATE TABLE a (i INT)

GO

CREATE TRIGGER a_insert ON a

FOR INSERT

AS

BEGIN

DECLARE @a AS VARCHAR(40)

SET @a =...

Basically what you need to do here is parse your string values. There are a couple ways you can do this pretty easily. If you have consistent data like your...

The error message is happening because when you do an insert there is an implicit transaction started. This is required for atomicity. Your trigger has now rolled back the transaction...

or this?

select charindex('sas',name), 'sas' from table

Like this?

select name, charindex('sas',name)from table

OnlyOneRJ (4/30/2013)

---

U can only script the Structures of Tables, Stored Procedure, Functions & Views & then run that script on 2000..

Regarding data.. just create a DB manually on 2000...

mw112009 (4/30/2013)

---

Folks:

How can i check for the presence of an index in another database ?

Lets say I am in DATABASE A and i want to check for an object in...

No need to script it. Just use the Data Export Wizard.

Hugo Kornelis (4/30/2013)

---

<nitpicking>

Not NULL - Unknown. Quite different concepts! (NULL means the absence of any data; Unknown is a result in three-valued logic that is the result of attempting to...