HI Y.B,

Please find the desired output which we looking for.

HI All,

Please find the sample table structure.

create table ITGDaillyMetrics (

ITG varchar (max),

Backenderror int,

dates datetime )

insert into ITGDaillyMetrics values (ITG01 - XFINITY Username and Password Reset,10,26 Sep 2016)

insert into ITGDaillyMetrics values...

Hi suresh thanks for ur reply..

can u please clarify my doubt then..

So.......If u create an unique Clustered index On a table then is it allow...Nulls and duplicate values the.....By default..?

Wow.........anthony.green.......Superb.........Its working fine...

Thanks alott...anthony.green

Thanks a lot...anthony.green. i Meet my Requirement.

But Unfortunately i have one more Requirement same like...i need to Insert the Incremented value in other table

Example :...

Its working fine..!

Manju There is no Problem In query or in ur Table..Its excuting fine..Please find out the below Image..

Hi chandrika.r 91171 ..

May be I understand ur requirement Clearly or not..!

...

Hey Hi Ganesh...

Please Try the Below Mentioned query..

syntax :

DECLARE @BeginningStay DATETIME

SET @BeginningStay='1978-01-25 00:00:00.000'

SELECT + DATENAME(d, @BeginningStay) +

CASE

WHEN DATENAME(d, @BeginningStay) IN ('1', '21', '31') THEN 'st'

WHEN DATENAME(d,...

Hi ... Priyanka...

In sql server. if u want to Give acess or Create Any login like ' Sa ' or Db-Creator

Before that The login wat ever you are...