SELECTNode.value('../@ID', 'int') AS ServiceLineNumber,

Node.value('@Name', 'varchar(50)') as FieldName,

Node.query('New').value('.','varchar(100)') AS OldValue,

Node.query('Old').value('.','varchar(100)') AS NewValue

FROM@xml.nodes('/ServiceLine/Field') TempXML(Node)

SELECTagrNo,

SUM(CASE WHEN rowFlag = 'Y' THEN 1 ELSE 0 END) AS countOfY,

SUM(CASE WHEN rowFlag = 'N' THEN 1 ELSE 0 END) AS countOfN

FROMTable1

GROUP BYagrNo

I think he meant to answer this topic

http://www.sqlservercentral.com/Forums/Topic576550-149-1.aspx

but managed to start a new topic with new name.

Yes it is.

1 is "other value than 0".

Same suggesetion as I posted here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111457

CREATE TABLE#Stage

(

{same structure as "linked" tables}

)

INSERT #Stage SELECT * FROM DB1.dbo.table1

INSERT #Stage SELECT * FROM DB2.dbo.table1

INSERT #Stage SELECT * FROM DB3.dbo.table1

INSERT #Stage SELECT * FROM...

Good for you!

DECLARE@Value DECIMAL(28, 6)

SET@Value = 26.153875

SELECT@Value AS OriginalValue,

ROUND(@Value, 4, 0) AS Rounding,

ROUND(@Value, 4, 1) AS Truncating

SELECT TOP 5 w.userName,

@clientID,

...

SELECT TOP 5userName,

clientID,

userID,

CONVERT(CHAR(10), reportDate, 101) AS reportDate

FROM(

SELECTu.userName,

c.clientID,

ua.uID AS userID,

ua.reportDate,

ROW_NUMBER() OVER (PARTITION BY u.uID ORDER BY ua.reportDate DESC) AS RecID

FROMClients AS c

INNER JOINUsers AS u ON u.clientID = c.clientID

INNER JOINUserActivityLog AS...

if you insert 20 lakh (2 million) records, it can be faster to drop existing indexes before insert, and recreate the indexes after insert.

Bulk insert or BCP are the fastest way to get 1 million (10 lakh) records into the database with minimal logging.

Something similar to this?

CREATE TRIGGER dbo.trgMyTotalUpdate ON dbo.MyTable

AFTER UPDATE

AS

IF UPDATE(Quantity)

UPDATEmt

SETmt.Total = i.Quantity * i.Price

FROMdbo.MyTable AS mt

INNER JOINinserted AS i ON i.PkCol = mt.PkCol

TINYINT?

A datetime2 can hold values from 0001-01-01 00:00:00.0000000 through 9999-12-31 23:59:59.9999999

See the 7 decimals?

DateTime2 ?