use the Copy Database Wizard in the enterprise manager

Hi,

try this

select seqNo,Auth_type,Amt1

from #DailyTran

where Auth_type = 2

and seqNo not in (select seqNo

from #DailyTran

where Auth_type = 1)

Users who are not members of the sysadmin fixed server role cannot execute xp_cmdshell

what type of process you would to do thro xp_cmdshell?

Repeated post, discussion already started,

Link: http://www.sqlservercentral.com/Forums/Topic767384-338-1.aspx

SELECT IDENT_CURRENT('MYTABLE')

Hi,

try this

CREATE TABLE #Gender

(ID TINYINT IDENTITY (1,1) ,

Gender_Name char(1))

CREATE TABLE #Hair

(ID TINYINT IDENTITY (1,1),

Hair_Name varchar(10))

CREATE TABLE #Eyes

(ID TINYINT IDENTITY (1,1),

Eye_Name varchar(10))

INSERT INTO #Gender Values...

chandresh soni (8/4/2009)

---

ORDER_NO | ORDER_TITLE | ORDER_DETAIL | ORDER_DETAIL_no | AMOUNT

1 ...

Hi,

only possible like this

insert into show

exec chekck 1

insert into show

exec chekck 2

insert into show

exec chekck 3

select * from show

However we are waiting for jeff mark on this (any performance issue?)

select * from

(

select a.ref,

(case when (select isnull(b.StartStop,'Start') from #TempTable b where b.ref = a.ref -1)= isnull(a.StartStop,'Start')

then 'ERROR' else isnull(a.StartStop,'Start') end)StartStop

from #TempTable a

) as X

where StartStop 'ERROR'

Hi,

also try this

select replace('JCP - P0209',(left('JCP - P0209',6)),'')

Hi,

try this

select * from

(

select a.ref,

(case when (select b.StartStop from #TempTable b where b.ref = a.ref -1)= a.StartStop

then 'ERROR' else StartStop end)StartStop

from #TempTable a

) as X

where StartStop 'ERROR'

Hi, then try this

declare @result varchar(15)

set @result = '200908010011'

select replace(@result,left(@result,8)/*Your fixed left char*/,'')

Hi,

you have any AuditDb for the applicationDB?

the workstation name, you can't see in the DB tables unless you store it in the table

or use this

select HOST_NAME ( )

to see thro the application