SELECTModules.ID.value('.', 'VARCHAR(20)') AS Module123 ,

Modules.ID.value('(../../Feature)[1]', 'VARCHAR(50)') AS Feature123,

Modules.ID.value('(../../Access)[1]', 'VARCHAR(50)') AS Access123

FROM@UserLFAMap_Rejected.nodes('/Modules/Module/ID') as Modules(ID)

See option 4 if you want to do pattern searches.

In your case, return all records starting with '1005..'

Thank you!

We were thinking the same idea, but you were faster with the response..

SELECT STR(Col1, 6, 0)

Neither one of them!

If you have '123000' in Column1 which is translated to '12300000000000'

and you search for '123' you will get a match, because '123' is also translated into '12300000000000'...

See http://weblogs.sqlteam.com/peterl/archive/2008/05/13/Lightning-fast-collapsed-date-ranges-and-missing-date-ranges.aspx

Partitioning only works with developer edition and enterprise edition.

See here http://weblogs.sqlteam.com/peterl/archive/2008/06/12/Horizontal-partitioning-Enterprise-style.aspx how you can manage that.

If you are not using Enterprise edition, not developer edition, see this blog post how...

Thanks!

If was indeed the < character mocking up.

Happy New Year everyone.

If you know the deepest level is three, you can use something like this

DECLARE@r XML

SET@r = '

<Reference>

<Basic>

<Book>A1.Hj1.JU9</Book>

</Basic>

<App>

...

SELECTSUM(st.nos) AS NumberOfSummary

FROMMachine AS m

INNER JOIN(

SELECTStoreID,

DATEDIFF(DAY, InDate, OutDate) * NumberofParts AS nos

FROMStore

WHEREcancelDate IS NULL

AND Indate IS NOT NULL

AND Outdate IS NOT NULL

AND NumberofParts IS NOT NULL

) AS st ON st.StoreID...

SELECTMAX(SIGN(col1)),

MAX(SIGN(col2)),

MAX(SIGN(col3))

Doesn't

IF UPDATE(colStatus)

do that for you?

Read and understand the code.

And as a sidenote, why would you like to store some data in local variables?

You do know an UPDATE can affect more than one record?

Which transaction level are you using?

Repeatable read?

exec master..xp_cmdshell 'bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout c:\file.txt -T -S[BLRKEC24506\INFY] -c'