A mix of the two seems to help

SELECT @HOLDER = ID

FROM #testEnvironment

WHERE CHARINDEX('.', yourData COLLATE Latin1_General_BIN2 , CHARINDEX('.', yourData COLLATE Latin1_General_BIN2) + 1) = 0;

Use sp_executesql with OUTPUT variables

DECLARE @t TABLE(value VARCHAR(10),xml_1 XML)

INSERT INTO @T(value,xml_1)

VALUES('1+2','<root><s>1</s><s>2</s></root>'),

('3+4','<root><s>3</s><s>4</s></root>')

SELECT value,x.r.value('.','INT') AS s

FROM @t

CROSS APPLY xml_1.nodes('/root/s') AS x(r)

Not sure this will help but I seem to remember something similar. Turned out the problem was the database owner, setting the owner to 'sa' using sp_changedbowner fixed it.

Did you really want it lowercase?

SELECT (SELECT LOWER(FirstName) AS "text()"

FROM #temp

ORDER BY ID

FOR XML PATH(''),TYPE).value('.','NVARCHAR(4000)') AS OutPut;

Try this

WITH Range(MINDATE,TotalDays) AS (

SELECT MIN(DATECOL),

DATEDIFF(Day,MIN(DATECOL),MAX(DATECOL))

FROM #SAMPLETABLE),

CTE AS (

SELECT n.number+1 AS number,

ROW_NUMBER() OVER(PARTITION BY CASE WHEN...

prady_1988 (10/5/2012)

---

Sorry, I may have mislead you.

The values under Relationship is taken from 2 tables.

Table1 -> AssetID, AssetName

Table2 -> Relationship1

Table3 -> Relationship2

Table4 -> Company

Hence for each record I am getting...

prady_1988 (10/5/2012)

---

Thanks Mark, but the problem is "Relationship" and "Company" columns are from different tables. Hence...

Try this

SELECT AssetID, AssetName, MAX(Relationship) AS Relationship, MAX(Company) AS Company

FROM myTable

GROUP BY AssetID, AssetName

I've waited five years, but finally I've got a reply!

http://www.sqlservercentral.com/Forums/FindPost1368501.aspx

WITH Recur(EmployeeID,Employee,ManagerID,Manager,Level) AS (

SELECT EmployeeID,Name,ManagerID,CAST('SuperBoss' AS NVARCHAR(100)) ,1

FROM #DataToBeReOrdered

WHERE ManagerID IS NULL

UNION ALL

SELECT d.EmployeeID,d.Name,d.ManagerID,r.Employee, r.Level+1

FROM #DataToBeReOrdered d

INNER JOIN Recur r ON r.EmployeeID =...

SELECT UniqueID,ID,Name,

(SELECT Latitude,

Longitude

...

This may also work for you

case

when ', ' + @myVar + ', ' like '%, ' + ProdGrpCode + ', %' then '82'

PiMané (10/1/2012)

---

Another way and very fast:

SELECT nc1, class, nc2 FROM #nc t WHERE NOT EXISTS (SELECT 1 FROM #nc t0 WHERE t0.nc1 = t.nc2 AND t0.nc2 = t.nc1 AND t.nc2...

SELECT nc1,class,nc2

FROM #nc

EXCEPT

SELECT nc2,class,nc1

FROM #nc

WHERE nc2 > nc1

ORDER BY class,nc1,nc2