You can also filter in your XPath expression. For example:

SELECT

b.header.value('Value[1]', 'varchar(20)') AS Typex2

FROM @bb.nodes('//ProcessTraceNode[contains(FunctionSymbol[1],"SUBFORMULA")]') AS b(header)

I'm not sure which is more efficient.

Drew

If you group on the driver ID, you can find the Min() of the status. You can also use a PIVOT if the group by won't work for some...

A CROSS JOIN with a WHERE clause that references both tables is essentially the same as an INNER JOIN.

Please correct...

Have you considered writing an SSRS report? You can use a table to get the datasheet and a matrix to get the pivot table. You can the schedule...

I'm comparing the difference in months between the zero date and each date, dividing that by four (using integer division) and then subtracting the two values.

DateDiff(Month, 0, FirstDateField)/4 - DateDiff(Month,...

ColdCoffee (8/10/2010)

---

If you dont have an ID column, then as Lutz suggested, use ROW_NUMBER as given below.

declare @tab table

(

rid int identity(1,1),

starttime datetime,

endtime datetime

)

insert...

Rob Schripsema (8/9/2010)

---

Assumptions:

The date field has 00:00:00 for the time, and the time field contains spurious dates (maybe the date the value was entered? or are they all '1-1-1900',...

You haven't given enough information. Check the following link on how to help people answer your question.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Drew

Jeff Moden (8/8/2010)

---

Thanks, Drew. Rumor has it that it's also pretty touchy about special characters like...

Tara-1044200 (8/6/2010)

---

I see the problem now, there is no check for already updated rows in the loop and so it is an indefinite loop.

so how would i check the updated...

When creating dynamic SQL, it's a good idea to use the Quotename() function to appropriately quote table names, field names, et al. Quotename will automatically handle escaping the quote...

I've actually started using the FOR XML clause to create the data and then using sp_xml_preparedocument and OPENXML() to read the data. Here are some of the reasons that...

If you want to improve your chances of getting help, you really should post the DDL statements to create your tables and the DML statements to insert sample data into...

Jeff Moden (8/5/2010)

---

Whether I agree with such claims or not, such claims should be accompanied by...

Eugene Elutin (8/4/2010)

---

Try:

declare @ReqDate datetime

set @ReqDate = '20100806' --GETDATE()

select LF-(7*wn)-(6) BeginDate, LF-(7*wn) EndDate, LF-(7*wn) PeriodEndingDate

from

(SELECT dateadd(dd, (DATEDIFF(dd,'1900-01-01',@ReqDate - 4) % 7 ) * -1,...