I hope this helps,

CREATE TABLE [dbo].[MOVIMI](

[Balance_ID] [int] IDENTITY(1,1) NOT NULL,

[Codeba] [varchar](5) NULL,

[Order] [int] NULL CONSTRAINT [DF_MOVIMI_Order] DEFAULT ((0)),

[Form] [varchar](1) NULL,

[Codle] [varchar](10) NULL,

[Descrip] [varchar](125) NULL,

[varname] [nvarchar](2) NULL,

[varyear] [nvarchar](4) NULL

)...

Lowell,

Thanks a lot... :w00t:

Thanks again

Hi,

Good Advice to have in mind...Thanks.. in this moment I'm looking the sql server side options, which I think is better for us by now.

I'm writing the following code,...

Hi,

Impressed by all your responses..thanks...

I will try to answer it by order,

1.- Yes, a single account can have many agencies or perhaps only one or none.

2.- I'm interested in latest...

Hi,

🙂

Resuming this task after a pause, I have encountered this situation, I hope you could help me

when I run a job, finish with this message:

Job's error. This job was invoked...

The first query return that columns pivoted and ok same situation second query, but what I need is to mix both query each pivoted column in that place.

Example:

Ba CC Des...

Hi,

Now,I need to pivot from the outer query some row transforms into columns.

Since i need to preserve the order in what data has been loaded I was thinking in

select *...

Ok, perfect that is what i was looking for

Thanks for your help

SELECT * FROM (

SELECT * FROM Query1

UNION ALL

SELECT * FROM Query2

) dtUnionAll

ORDER BY ...

Is possible to pivot this resulting...

Hi,

Yes, we want to schedule a SSIS job project but also we want to allow a specific user to run that project whenever he wants...

Thanks for your response, again....

:w00t: