USE AdventureWorks;

GO

SELECT ProductID, Name, Color

FROM Production.Product

WHERE ProductID = 1

FOR XML RAW('Task'), root('TaskList')

If executing the above query, XML result set will come along this ProductID 1.

USE AdventureWorks;

GO

SELECT ProductID, Name, Color

FROM Production.Product

WHERE...

Yes, the same ProductID not in my database as well....

I don't know how the logic is. I am trying the same.

If you have any idea about the logic let me know.

Lynn Pettis (8/5/2009)

---

sqluser (8/5/2009)

---

1. If all the fldCID (101,102 for fldCID = 1) are available in AT then i have to get the maximum fldDates fldMID.

In this...

I want my result set should be like below.

RowfldIDfldUName1.12.2 3.3 4.4

110 Sample1 2009-07-07 NULL NULL NULL

220 Sample2 NULL ...

Thanks John for your reply. For time being i get the same procedure from some other server and create the same in my server.

Now, i am able to create...

I am using Standard Edition with Service Pack 2.

No, that...

Yes, i am using sysAdmin Privilege to configure this.

Thanks guyz for your reply.

Can you tell me, why you are going for dynamic query as per your script...

Hi,

test the date

DECLARE @test-2 int

SET @test-2 = 1000.00000

SELECT STR(@Test,5,2)

what happened?

ARUN SAS

[/quote]

you need to change the length 7 instead of 5.

DECLARE @test-2 int

SET @test-2 = 10.00000

SELECT STR(@Test,5,2)

I hope this may solve your issue.

IF EXISTS(SELECT * FROM sys.objects WHERE [name] = 'tblTable')

BEGIN

DROP TABLE tblTable

END

CREATE TABLE tblTable (fldID int, fldName varchar(8))

IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME...

Thanks MITHUN