WHILE @Counter > 0
BEGIN

	SELECT @key = Phase FROM #TEMP WHERE ID = @Counter

	IF @Key = 1
	BEGIN 
		SELECT 
			 @Var1 =  Agency ,
			 @var2 =  Request,
			 @var3 =  SourceofFunds FROM #TEMP WHERE ID = @Counter
		 
		UPDATE	#TEMP
		SET		Agency = @Var1
		WHERE	Request = @var2 AND SourceofFunds = @var3 AND ID <> @Counter

DECLARE @Str VARCHAR(100),
		@NewString varchar(100)

SET @Str = 'xxxxx 0 yyyy 1 zzzz 2'

DECLARE @I INT,
		@start int,
		@end int,
		@initial int
SELECT @I = 0, @start = 1, @initial = 1

WHILE @I <= LEN(@STR)
BEGIN

	WHILE isnumeric(substring(@str,@start, 1)) = 0 AND @start <= LEN(@STR)

SQLQuery= SQLQuery & " where(firstname + ' ' + lastname Like '%" & strWD & "%')

SQLQuery= SQLQuery & " where(firstname + lastname Like '%" & strWD & "%')

create procedure xmlread
 @xmlDoc text = ''
as
begin
	 --nvarchar(100)
	Declare @handle int
	SET @xmlDoc = N'
	<students>
	<StudentID> 100-252-1658</StudentID>
	<StudentFName>Suresh</StudentFName>
	<StudentLName>Prabhu</StudentLName>
	</students>'

	EXEC sp_xml_preparedocument @handle

SELECT [Sch ID], 
       count ([Student ID]), 
       [Enrolled Date], 
       count ([Student ID]), 
       count (CASE WHEN [new or old]='old' THEN 1 ELSE NULL END) as NEW 
FROM tblData 
GROUP BY  
	[Sch ID], 
    [Enrolled Date]

UPDATE dbo_aspnet_Users 
SET [Username] = @UserName, [email] = @Email 
FROM dbo_aspnet_Membership INNER JOIN dbo_aspnet_Users 
ON dbo_aspnet_Membership.UserId = dbo_aspnet_Users.UserId 
WHERE [UserId] = @UserId

DECLARE @STR VARCHAR(MAX)
SET @Str = 'SELECT '

SELECT	@Str = @Str + Column_Name + ',' FROM Information_Schema.Columns
WHERE	TABLE_Name = 'Table_Name' AND 
		Column_Name like '%cOLUMN_Name%'

select user.id,user.name,
count(messages.id) as Messages,
COUNT( case when message.Status ='Unread' then 1 else null) as UnreadMessages
from user LEFT OTUER JOIN
message on message.userid = user.id
group by user.id,user.name

SELECT X.Category, X.Date, avg(X.Value) FROM
(	SELECT	A.Category, D.Date, p.Value,
			ROW_NUMBER() OVER(PARTITION BY A.Category,D.DATE ORDER BY p.Value) AS RowNum,
			COUNT(*) OVER(PARTITION BY A.Category,D.DATE) AS Cnt
	FROM	TABLE1 AS A INNER JOIN
			TABLE2 AS D ON A.ID = D.ID
	WHERE	D.Date between '20100510' and

SELECT Cust_Name,[Apple],[Apricot],[Banana]
FROM	(
			SELECT  ct.Name as Cust_Name,ft.name as ft_Name,SUM(ot.mass) AS Mass
			FROM	 CT INNER JOIN
					 OT ON CT.ID = OT.Ct_Id INNER JOIN
					 FT ON FT.ID = OT.ft_Id
			GROUP BY CT.Name,ft.Name 
		) src
PIVOT	(SUM(Mass) FOR FT_Name
		IN([Apple],[Apricot],[Banana])) AS pvt