I hope you are looking for this 🙂

CREATE TABLE #TABLE_1

(

job_cdvarchar(20),

permit_nbr int,

reference_nbr int

)

CREATE TABLE #TABLE_2

(

job_cdvarchar(20),

permit_nbr int,

reference_nbr int

)

INSERT...

Tried with both the options below. It seems to be working fine.:-)

SELECT * FROM

(

SELECT '"DFDJFDJLKLK"FSC"' COL1

)a

WHERE COL1 like '%FSC%'

----using replace

SELECT * FROM

(

SELECT '"DFDJFDJLKLK"FSC"' COL1

)a

WHERE REPLACE(COL1,'"','') like '%FSC%'

SELECT a.action as [begin],a.date,b.action as [end],b.date,a.Name

FROM(

SELECT * , ROW_NUMBER()OVER (order by action,date desc) as row_Num

FROM #SAMPLE_DATA

WHERE action='begin'

)a

INNER JOIN

(SELECT * , ROW_NUMBER()OVER (order by action,date desc) as row_Num

FROM #SAMPLE_DATA

WHERE action='end')b

ON a.row_Num=b.row_Num

select

substring(Filename,1,charindex('Bytes',Filename) -1) as Filename,

replace(substring(Filename,charindex('Bytes',Filename),charindex('Record',Filename) -charindex('Bytes',Filename)),'Bytes:','') as Bytes,

replace(substring(Filename,charindex('Records',Filename),len(Filename)),'Records:','') as 'Records'

from control_Total

This can be achieved by sub-query also 🙂

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH,OUT_PUNCH,HOURS) AS

(

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3' UNION ALL...

Hi ,

Run this script hope you find out a solution to your problem :-

create table Acc_count

(

Acc_row_no int identity(1,1),

acc_dt datetime ,

acc_count int

)

Go

insert into Acc_count(acc_dt,acc_count)

select convert(datetime ,'apr 13 2008 1:00')...

use the buit in sp of sql server :

sp_foreachtable 'delete from ?'

it will delete the values from all the tables.

Thanks ,

Amit Gupta

(MCP)

Hi ,

Here you can intoduce one more table that will contain the flagging like "DP" (Duplicate In Production Table) or "GR" (Good Records that not exists in Production) and after...

It means you want when stage 3 then perior to stage 3 (stage 1 & stage 2) should be inserted.

if i m right , then you can create a script...

To implement this you can create one extra table , and transfer all the records from your source to that table and after completion of this you can write the...

Hi ,

Try this !!!

select sum(case when app_amount = 0 then app_amount else 0 end ) '-ve Sum'

from AutoMail_Salary

Thanks,

Amit Gupta

^MVP

Thanks Terri ..... its workng....:)

Hi Try this solution,

Its working.........

declare @STR varchar(30)

declare @str1 varchar(30)

set @STR='select * from tab_ind'

set @str1='''' + @STR + ''''

print @str1

Thanks & Regards ,

Amit Gupta

Oh........

U r calling a proc with an Output parameter...

Declare @computername varchar(50)

Exec proc_name @computername output

Thanks.

Hi ,

Use this sp..

sp_depends <Table Name>

ex. sp_depends 'authors'

Regards ,

Amit Gupta

MVP