You also need to declare 20 variables named dtsCampaign_Code1,dtsCampaign_Code2 .....dtsCampaign_Code20 in the Variables window.

System.Windows.Forms.Form frm =...

Okay we will go step by step.

First what is the out put that you are seeing for this statement

select '[' + name + '] = 0,'

from sys.columns

WHERE...

I would follow the binary tree approach. Comment out fist 100 fields, then 50 .............................

If the column names are similar in both the tables, make a join and figure...

Any specific reason for having the UI. why don't you just put all the 20 variables in a confiuration file and pass those values at the runtime?

Try this. I will not update but generates the script for update columns

select '[' + name + '] = 0'

from sys.columns

WHERE object_id = OBJECT_ID(N'[dbo].[myTable]')

and name != 'CustCode'

Thanks

expert is definitely not the right word. how about someone who is has more knowledge and expretise with the sql server then me.:-)

Thanks Sean for confirming that. I know that is not possible, but i am reading the Offical Microsoft dcoumentation, So wanted to corfirm with experts.

Attached is the script for authors table.

Basically what i am trying to understand is

"You may want to insert data to columns not visible in the view. To do so create...

I just tried to reproduce the problem, but everything is good. Attached are the screenshots.

May be you can post your spreadsheet.

Please see the screenshot

declare @Freqteacher1 table

(

Teacher int,

name varchar(256))

declare @Freqteacher2 table

(

Teacher int,

name varchar(256))

declare @temp table

(

rownum int,

Teacher int,

name varchar(256))

insert into @Freqteacher1 values(1,'Freqteacher1'),(2,'Freqteacher2'),(3,'Freqteacher2'),(3,'Freqteacher2')

insert into @Freqteacher2 values(11,'Freqteacher11'),(12,'Freqteacher12'),(13,'Freqteacher13')

insert into @temp

select row_number() over(order by Teacher) ,*...

Are you trying to do a export or import on this flat file.

Can you post the flat file as an attachment.

thankyou Sean.

;with CTE as

(select ROW_NUMBER() over( partition by CustomerID order by invoiceid) as rn,* from #invoices)

select

t1.invoiceid,t1.customerid,t1.total

from CTE t1

left outer join CTE t2

...

Not a Pro but came up with this query

with CTE as

(select ROW_NUMBER() over( partition by CustomerID order by invoiceid) as rn,* from #invoices)

select t1.invoiceid,t1.customerid,t1.total from CTE t1

...