Hi Kumar,

What Jason says is correct, your query in the wrong area, and moreover you’re new to this SSC.com, first you mine some of the article in this SSC.com. And...

Hi,

Try this

declare @des varchar(80)

select @des = '""desc""ripti""on""'

select @des

--select PATINDEX('%[A-Z]%',@des)

--select len(@des)-1-PATINDEX('%[A-Z]%',reverse(@des))

select '"'+substring(@des,PATINDEX('%[A-Z]%',@des),(len(@des)-1-PATINDEX('%[A-Z]%',reverse(@des))))+'"'

Hi,

The error tells you that the table already in the database, you just drop the table and insert the record.

And the table data type for the column Empname is only...

create table #temp

(

slno int identity(1,1),

name1 varchar(2)

)

insert into #temp (name1)

select 'C'

union all

select 'C'

union all

select 'A'

union all

select 'B'

union all

select 'B'

union all

select 'C'

union all

select 'D'

union all

select 'E'

select

max(case when a.name1 = 'A' and...

Hi,

See this http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=249

Its give the frame work to start on the ‘WoW’

Hi,

The solution based on the jeff article mentioned above, with your real data you should mine with this article to get more.

http://www.sqlservercentral.com/articles/T-SQL/62867/

Create procedure mysp

as

begin

declare @return varchar(10)

set @return = 'XYZ'

select @return

end

create table #temp

(

slno int identity(1,1),

name1 varchar(10)

)

insert into #temp (name1)

exec mysp

select * from #temp

Hi,

Use the output parameter in the procedure and ref the BOL for set the output parameter in the SP.

Hi,

Ref the jeff article The "Numbers" or "Tally" Table: What it is and how it replaces a loop

http://www.sqlservercentral.com/articles/T-SQL/62867/

From this,

CREATE TABLE #temp

(ID INT, ITEM1 VARCHAR(100))

GO

INSERT #temp

SELECT 1,'123,126,139,203'...

Hi,

This handled by using the dynamical sql updating statement

create table MYTABLE

(

KEYIDvarchar(5),

col1 varchar(10) null,

col2 varchar(10) null,

col3 varchar(10) null,

col4 varchar(10) null,

col5 varchar(10) null,

col6 varchar(10) null,

)

insert into MYTABLE

select 1,'A','AA','AAA','AAAA','AAAAA','AA'

declare @KEYID varchar(5),@col1 varchar(10),@col2 varchar(10)...

Hi,

There little confusion, actually you have to update the column are null in the table is in it, or to update the column by the passing parameters are having the...

Hi,

Even column having the value but the...

Hi jeff,

very nice

Hi,

Post this query in the new thread.

Hi,

Here is the mistake, your inserting repeated data.

XX24DD40

XX24DD40