i've been having a bit more of a play with this and have noticed that the line

OriginalSchema.value('Form[1]/Codes[1]/code[sql:column("y.myNum")][1]','varchar(max)')

is significationly slowing down my query.

each row in the table that houses the XML...

what sort of text/information were you hoping to return from the Stored Procedure?

would it just be a Flag to say Pass/Fail?

WITH MyCTE(title,impact,probability) AS

(

SELECT 'RiskA',10,0.1 union

select 'RiskB',10,0.5 union

select 'RiskC',9,0.8 union

select 'RiskD',5,0.5 union

SELECT 'RisckE',5,0.3 UNION

SELECT 'riskf',6,0.8 UNION

SELECT 'riskg',2,0.3 UNION

SELECT 'riskh',6,0.8

)

SELECT *,

CASE WHEN [mc].[impact] >= 7 AND [mc].[probability] >= 0.7 THEN 0

...

are you doing something that a Recursive CTE could resolve?

http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/

ronmoses (3/1/2013)

---

Where I got tripped up was here, and I guess I'm still not sure I understand...

create proc sp1

as

select * from temp1

exec sp2

Without a BEGIN and END defining the body...

i got caught on questions

10

11

12

7

6

i got confused with question 12.

the answer states Group By and ORDER BY cannot contain a sub query, but isn't this considered a subquery?

select * from...

thanks for the reply.

i'm going to step through the process you've laid out, and see if it makes sense to me 😀

cheers

doesn't this do it?

DECLARE @noVowels [varchar](50)

SET @noVowels = 'Information System'

SELECT

REPLACE(

REPLACE(

REPLACE(

REPLACE(

REPLACE(@noVowels,'A','')

,'E','')

,'I','')

,'O','')

,'U','')

i decided to do a test and view the execution plan.

DECLARE @i INTEGER = 1

SELECT CASE @i

WHEN 0 THEN

(SELECT COUNT(1) FROM table1)

WHEN 2 THEN

(SELECT COUNT(1) FROM table2)

ELSE

(SELECT COUNT(1) FROM...

i think it is valid syntax, its just giving a cross join because there isn't a join in the WHERE clause.

select

*

from

table1 t1

,(select ...) t2

where

t1.col1 = t2.col1

jasons example is a good...

i believe that if your within cursor in one SP (lets say its named aCURSOR)

and you make a call to another SP that also has a cursor with the same...

could someone explain what the original post is returning, and what is believed *should* be returned, as i dont understand.

when i run the code, it returns '8', which is what...

hi.

its set to Anonymous Authentication.

i've actually got it to work, now.

i got it to work at 9:30 (about 45 minutes before i opened this thread), but the person who receives...

dont you just hate it when someone else comes in with the answer before you? 😀

i think it would be like this.

select NameField,COUNT(table2.LinkField) FROM

Table1

LEFT JOIN Table2 ON Table1.LinkField = Table2.LinkField

and Table2.OtherField = 'Somthing'

and Table2.LinkField IN (1,2,3,4)

GROUP BY namefield