how about this

declare @t table(yr int,mon varchar(32))

Insert into @t

select 2011,' December ' union

select 2012,' July ' union

select 2012,' June ' union

select 2012,' March ' union

select 2012,' May '...

Based on my understanding, you have a stored proc with those "if" constructs that acts as source, you want to have a CSV format flat file as destination based on...

@sam-3, can you test this one too, just curious, not sure if this helps performance wise..

;with cte1(part,leftover,textid) as

(

select left([text],CHARINDEX(' ',[text])),RIGHT([text],len([text])-CHARINDEX(' ',[text])), id from #Text

union all

select left(leftover,case when CHARINDEX('...

this should suffice

declare @mn money=-1000000

select replace(CONVERT(varchar(50),@mn,1),'.00','') as mn

Is this what you wanted, I doubt you'd need ORG_ID value twice there..

SET @OrgName = 'SELECT ORG_ID+''' + CONVERT(varchar(10), @orgid) +''' '+ '+[Description]+' + ' ' +'''('''+ + '+CONVERT(varchar(20),pol_id)'

+'+'')'''+ '...

type casting that column to dt_dbtimestamp should work

try this , you could always play with datatypes once you have data in your table..

string constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Documents\\Book1_3.xlsx;Extended Properties='Excel 12.0;HDR=NO;'";

...

That's right. I'm looking for an oracle solution. Perhaps, I'm at wrong place. Thanks.

Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.

try using multi cast transformation and add both tbls as destinations. not 100% sure though..

have a job that runs every 15 mins. in job step add a ssis package that checks file if exists and today's date is not in the table then insert...

can you elaborate more on what you require. why can't we create tables before hand? if they are to be created for every 10K, then what is the structure of...

try creating a stored proc and pass this column as a parameter (varchar(max)) and use exec @param

Figured out why it is odd. It has been querying the same table(local) in Server B instead of Server A. When I deleted some rows and ran a query for...

Yes. I ran a select to see data is updated in Server A. That's the queer thing.