You can use either xml.value (but it is a problem with variables), or you could use dynamic SQL do do this.

DECLARE @RET_VAL DECIMAL(13,2);

DECLARE @Formula AS VARCHAR(255);

-- function does stuff...

arun.samuel (3/7/2008)

---

I have a 3 tables :

1. tblCaseInfo with CaseID, ResolutionID

2. tblSessions with CaseID, Location

3. tlkResolution with ResolutionID

get all resolved cases for a particular LOCATION.

trying to do the following...

Wow, this is amazing. And now I know the name for this...

There are DML, DDL and Logon triggers (trigger...

No, it does not 🙂 nvarchars seems to have become a new requirement for this problem 🙂

There is of course another alternative...

abd (3/5/2008)

---

Thank you Andras and Nisha for your replies

In fact Andras, yes, this is a short example of my sp

but the problem here i can not use the IF statement,...

You could also use

SELECT *

FROM Tickets

...

wpotter (3/4/2008)

---

Good morning everyone;

Is it possible to call a table in a CASE statement in the else area:

(CASE --(CASE 1)

WHEN cd.location_type_id != 1 --Home

THEN f.county_id

WHEN cd.location_type_id != 4 --Day...

Check who it is who is responsible for this transaction

sp_who2 200

If you think that this transaction was a mistake, then kill the 200 process (this will roll back that transaction),...

The first question, what recovery mode are you running in? I sort of hope that you are in SIMPLE. (if not, then I assume that you are trying to reduce...

sangeethasriram18 (3/4/2008)

---

Hi,

Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar...

sangeethasriram18 (3/4/2008)

---

Hi,

Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar...

The result will be a resultset, and you cannot assign this to a variable directly. However, you can dump the result into a temporary table, and get the result out...

guptaopus (3/4/2008)

---

HI,

Have some Stored Procedures some part of data is static for all SP want to use is in smarter way. How can i call or use that part of...

tfuyt (3/4/2008)

---

Hi

I'll Take the Full backup every sunday and Diff. Backup every Day 11:59 PM and T.log backup every 1/2 Hr. and

after few week my database is down at...