No need to follow the "Notes" in the challenge...you can give me any solution which is best....

Actually i'm trying to solve a challenge posted in one of the websites but was unable to do so.....I seriously want to know that solution cause i have a great...

Thanks lutz..

Hi Lutz,

I created a function by slightly modifying your query

CREATE FUNCTION [dbo].[udf_TEST_EMAIL] (@String VARCHAR(MAX))

RETURNS @Email TABLE (Email VARCHAR(MAX))

AS

BEGIN

DECLARE @E_mailID VARCHAR(MAX), @delimiter CHAR(1), @sub varchar(max)

SET @delimiter ='@'

WHILE CHARINDEX(@delimiter,...

Never mind....i got it.....i was on 2000 server...thanks all

Hi vani,

Can you please post the document which helped you acheive this.

thanks

Kevin.

CAn you post your final solution.....

thank you

there should be a space for the seconds (' 00:00')

Try this

declare @lastdate datetime, @startdate datetime

set @lastdate = '12/15/2010'

select @startdate = convert(datetime, datename(month,@lastdate) + ' ' + datename(day,@lastdate) + ' ' + datename(year,@lastdate) + ' 00:00')

print @startdate

Try this out....

select columna, columnb, count(*) from Table

group by columna, columnb

thank you ver much lowell this your code helps me.....

I tried the following code

select left('00'+cast(substring('008', 2,2)+1 as varchar(10)),3)

it hold good only for 000 to 008

of i add 009 + 1 using the above code it will give...

Thanks lowell. I tried using all the string functions to acheive this but canot get the result.

Thanks Jeff. I finally got the code i need. Thanks evry1 for helping me out.