Nevermind. This one worked.

SELECT tbl2.rows2.value('.', 'int')

FROM @company.nodes('/Company/Locations/Location/Department') AS tbl(rows)

CROSS APPLY tbl.rows.nodes('./Employees/EmpId') AS tbl2(rows2)

WHERE tbl.rows.exist('../LocId[text()="3"]') = 1

This worked.

SELECT x.y.value('.', 'int')

from @depxml.nodes('(DEPARTMENT/EMPLOYEES/EMPID)') x(y)

Bump. Anyone?

I tried to login to SSMS using sql auth, I got this error -

A connection was successfully established with the server, but then an error occurred during the login...

I am sorry if I didn't explain myself clearly. The user 100 has two reports by same name - REPORT2. The id is unique, but we still would like the...

Will it work from inside an aspx page? The csv file will be uploaded from an aspx web form.

I don't think it will work in this case. This page has a dropdown option for the users to order the resultset on different fields.

"Then if Farrell became friend of Sergiy, is he a friend of Senthil?" No. There is no friends of friends or recursive relationship.

I don't want to add multiple records, if...

I believe it talks about heirarchical tree structure. This friends table would be a non-directed graph. I think this table design is OK, I have all the select, insert, and...

Thank you.

Can you please tell what typical fields you would have in each table. There is going to be just one forum. I think there will be no need for Forum...

Its a copy paste error. The actual var is @stringids, I thought @useridstring would be easier to understand for others. There were couple of other copy/paste errors as well. I...

Hi Lowell,

"no squishing userid's into a varchar and then re-extracting them." I am not sure if that will work. Please let me know if I am wrong or is there...

This is the sproc that runs from the windows service, from where I get the timeout errors.

CREATE PROCEDURE [dbo].[proc_broadcastemailsget]

AS

DECLARE @clientstable TABLE (userid INT PRIMARY KEY)

DECLARE @bid INT

DECLARE @useridstring VARCHAR(8000)

IF...

Thanks very much.

I have another questions. Some of the old orders imported from another system does not have the date, the datestamp field is null (it is of type...