Definitely second statement will return count 1, i was bit surprised by the count 1 option is not in the answers list. 🙂

The same logic will work in case of Int datatype, but in case of Long datatype u need to CAST them while adding in query

Regards, Yog

try this as well, not sure this is the right way .. but this might work ..

select timestamp,point_id,_VAL from DEV.DEVTABLE.dbo.DATA_LOG

where timestamp between '2011-03-02 00:00:00.00' and '2011-03-02 23:59:59.00'

except

(

select timestamp,point_id,_VAL from...

may be it is possible through returing multiple results in one single xml and again seperating the xml to different set of tables 🙂

Regards, Yog

Just check if you can do something like this

DECLARE @hDoc INT,

@XmlString AS VARCHAR(MAX)

SET @XmlString = '<XmlRoot>

<TableName Id="1" FirstName="A" LastName="L" />

<TableName Id="2"...

Thanx - Regarding the parenthesis and standards, can you provide me the standards for writing the SQL Query, as i was looking for those 🙂

Its bit easy you may try this 🙂

SET NOCOUNT ON;

CREATE TABLE #StudentInfo

(

[StudentId] [int] NOT NULL,

[StudentName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

)

INSERT INTO #StudentInfo ([StudentId],[StudentName])

...