You'll have to include the namespace in the query too...

declare @sample table (y XML)

insert @sample

values('

<submission fc:submission_type="CURVEBALL" xmlns="http://www.curveballxml.org"

xmlns:fc="http://www.curveballxml.org" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.curveballxml.org https://challengeyouxml.org/schema/fc_submission.xsd">

<header_record>

<submission_date>2002-10-15</submission_date>

<begin_posting_date>2002-04-01</begin_posting_date>

<end_posting_date>2002-04-30</end_posting_date>

<number_of_records_transmitted>8</number_of_records_transmitted>

</header_record>

<detail_record>

<status>Good</status>

<name>Z</name>

</detail_record>

</submission>')

;WITH XMLNAMESPACES('http://www.curveballxml.org' AS e)

SELECTtab.col.value('(./e:status)[1]','varchar(10)') AS [status],

tab.col.value('(./e:name)[1]','varchar(2)') AS [name]

FROM@sample

CROSS APPLYy.nodes('e:submission/e:detail_record')...

Also see

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137844

The script calculates the uptime for the server, not the database service.

SELECTcl.*

FROMdbo.CallLog

INNER JOIN(

SELECTCallID

FROMAsgnmnt

GROUP BYCallID

HAVINGMIN(CASE WHEN Resolution = 'Completed' THEN 1 ELSE 0 END) = 1

) AS x ON x.CallID = cl.CallID

Have you tried "CONVERT(XML, YourColumnNameHere)"?

DECLARE@Sample TABLE

(

Col1 DECIMAL(7, 4)

)

INSERT@Sample

SELECT7.0449 UNION ALL

SELECT7.0444 UNION ALL

SELECT7.0445 UNION ALL

SELECT7.033

SELECTCol1 AS OriginalValue,

ROUND(ROUND(Col1, 3), 2) AS OriginalPoster,

ROUND(Col1 + 0.0005, 2) AS Peso

FROM@Sample

The overlooked thing is the TOP operator.

declare @SampleInput table

( CustomerID int )

insert into @SampleInput

select 10001

insert into @SampleInput

select 10002

insert into @SampleInput

select 10003

insert into @SampleInput

select 10004

insert into @SampleInput

select 10005

insert into @SampleInput

select 10006

insert...

No, you can't use a computed column as source for another computed column

The main reason I think is circular reference, like this:

A = B

B = A

You will get the student with last character of your alphabet, probably Z.

Zanzibar is MAX over Sweden. It's the way they are sorted.

At least it is "lowest common" 😀

+1 for Florian's calculator analogy.

This may also be useful to know

http://weblogs.sqlteam.com/peterl/archive/2008/11/24/SQL-Server-2008-with-MERGE-and-triggers.aspx

SELECTCOUNT(*) AS User_Count

FROM(

SELECT[User_ID],

MIN(Created_Date) AS First_Purchase_Date

FROMdbo.Orders

GROUP BY[User_ID]

HAVINGMIN(Created_Date >= DATEDIFF(DAY, 1, GETDATE())

AND MIN(Created_Date < DATEDIFF(DAY, 0, GETDATE())

) AS d

1 week, and 4 pages of replies.

Where did OP go?

Make your voice heard

Vote on Connect here

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=254388