Actually i am try to log the changes using a trigger

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tblStoredProcedureAudit](

[ObjectName] [varchar](256) NULL,

[TSQLCommand] [nvarchar](max) NULL,

[Date_Time] [datetime] NULL,

[Modified_User] [varchar](256) NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING...

declare @rollup table(

id int,

cnt int)

insert into @rollup values(339,15),(340,5),(341,2)

select isnull(cast(id as varchar(12)),'Total'),SUM(cnt) from @rollup

group by rollup(id)

Where did you select this option to show synonyms?

Add 2 derived columns and use the expressions

RIGHT([yearquarter],2 )

LEFT([yearquarter],4 )

Just realized there is not left function is SSIS

better use the substring

SUBSTRING("2014Q3",5,2)

SUBSTRING("2014Q3",1,4)

As suggested in the post http://microsoft-ssis.blogspot.com/2011/01/foreach-folder-enumerator.html

you can use the script task.

A few tweaks like adding a for loop container with in a for loop container should be done...

If i understood the requirment correctly you can use case statement

select

gl_account.id as GLAcct,

gl_account.descr as GLDesc,

case when gl_ledger.transaction_date between '2014-01-01 00:00:00.000' and '2014-01-31 23:59:59.000' then sum(gl_ledger.amount_n) end as P1,

case...

declare @sample table(id varchar(1),

dt datetime,

line_counter int)

insert into @sample values('A','01/01/2013',null),('A','01/01/2014',null),('B','01/01/2013',null)

,('A','01/01/2012',null)

select ID,dt,(select COUNT(*) + 1 from @sample t2 where

t1.id = t2.id

and t1.dt > t2.dt) as line_counter

from @sample t1

order by line_counter

Today to many row_number questions

declare @sample table(id varchar(1),

dt datetime,

line_counter int)

insert into @sample values('A','01/01/2013',null),('A','01/01/2014',null),('B','01/01/2013',null)

select id,dt,row_number() over (partition by id order by dt asc) as line_counter from @sample

Please use the below code for btnCampaignCode_Click

void btnCampaignCode_Click(object sender, EventArgs e)

{

...

i guess you are missing the attachment.

declare @eventid table(Eventid int)

insert into @eventid values(31206),(31206),(31206),(31206),(31206),(31207),(31207)

select CAST(eventid as varchar(12)) + CAST(ROW_NUMBER() over(partition by eventid order by eventid) as varchar(12)) from @eventid

as d_eventid

chage the line

lblCampaign_Code.Text = "CampaignCode" + i + 1;

to

lblCampaign_Code.Text = "CampaignCode" + (i + 1);

Campaign_Code.TextAlign = ContentAlignment.MiddleCenter is already commented in my orgianl code. so you can keep that...

Go to the project explorer window(CTRL+ALT+L). then right click on the references and add the system.drawing reference as show in the previous screen shot.

select 'Task-ID.' + cast(ROW_NUMBER() over(order by something) as varchar(12)) from SomeOtherTable

where something = 'someothervalue'

you have to add the system.drawing reference. Attached is the screen shot.