Hi,

Try this one.This may helpful for you.

DROP TABLE #tem

DROP TABLE #temp1

CREATE TABLE #tem (Category char(3),cnt int,Sale int)

INSERT INTO #tem (Category,cnt,Sale)

SELECT 'ABC',11,450

UNION ALL

SELECT 'DEF',22,950

UNION ALL

SELECT 'GHI',3,690

SELECT * FROM #tem

CREATE TABLE #temp1...

Hi,

This might give answer for your question.

DROP TABLE TEST

CREATE TABLE TEST

(x xml)

INSERT TEST VALUES(

N'

')

SELECT...

Hi,

USE AdventureWorks

DECLARE @Fir INT

SELECT Top 1 @Fir = EmployeeID FROM HumanResources.Employee ORDER BY EmployeeID Desc

SELECT @Fir

Thanks working fine

Hi ALZDBA,

Thanks a lot. Its working fine.

🙂

thanks a lot ....

Hi,

Look at this. This might help you.

DECLARE @Name VARCHAR(30)

DECLARE @Length INT

SET @Name = 'sample example'

SET @Length = LEN(@Name)

DECLARE @p VARCHAR(30)

SET @p = PATINDEX('% %',@Name)

DECLARE @q VARCHAR(30)

SET...

try this ....

DECLARE @xml xml,@xml_with_new_namespace xml

SET @xml = '

...