Database

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)

<br />
SELECT a.categoryId, a.categoryParentId, a.categoryName, MAX(ISNULL(b.categoryId,0)) AS categoryHasChildren<br />
FROM categories a LEFT JOIN categories b ON a.categoryId = b.categoryParentId<br />
WHERE a.categoryParentID=2 OR a.categoryID=2<br />
GROUP BY a.categoryId, a.categoryParentId, a.categoryName<br />

SELECT 
   a.categoryId, 
   a.categoryParentId, 
   a.categoryName,
   (
      CASE 
         WHEN EXISTS(SELECT * FROM categories b WHERE b.categoryParentID=a.categoryID)
         THEN 1
         ELSE 0
      END
   ) AS categoryHasChildren
FROM categories a 
WHERE 
   a.categoryParentID=2 
   OR 
   a.categoryID=2

CREATE TABLE #test (
   dt DATETIME NULL
)

INSERT INTO #test VALUES ('2003-01-01')
INSERT INTO #test VALUES (#2003-01-01#)

Server: Msg 128, Level 15, State 1, Line 1
The name '#2003' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.