jezza101 (3/26/2013)

---

Great, thanks guys.

Very interested to see the recursive CTE solution as that is what I've been trying to get going most of this morning! I wasn't...

Another version:

declare @t table

(

SaleId int

,Discount int

,Sequence int

)

insert @t (SaleId, Discount, Sequence)

select 1,15,1

union all

...

Excellent - so everything...

But you want them all in the same file - presumably, then, with new column...

Are the output columns always the same, or do they vary by proc?

Phil Parkin (3/25/2013)

---

In my opinion, the lookup is unlikely to be the main culprit here. I'd be looking...

In my opinion, the lookup is unlikely to be the main culprit here. I'd be looking at the...

Check out the T-SQL Year(), Month() and Day() functions - you can do this at source.

From Access to SQL Server, presumably?

So you want to create a loop which iterates around all tables in a selected Access database, and for each table it should create the...

Good answer Sergiy.

Can you provide a bit more background?

What do you want to do with the schema once it has been extracted?

Shaira (3/18/2013)

---

What is the best way to share an SSIS package? I have a sister office who receives all the same data I do, but they have a completely...

opc.three (3/14/2013)

---

Have a look into EncryptSensitiveWithPassword the option. You could also look into using a Package Configuration (of some kind) to store the connection string with the password in it...

AllanP999 (3/13/2013)

---

Thankyou for you reply.

grps can be updated many times on many dates, so can appear in the table many times.

The table is ordered by date, so I am only...

happycat59 (3/13/2013)

---

Coincidentally, I had a similar problem just this morning with a sproc that calls msdb.dbo.sp_help_job

Have a look at http://connect.microsoft.com/SQLServer/feedback/details/737341/sql-server-2012-openrowset-on-msdb-dbo-sp-help-job-throws-error

In particular, the syntax used in the first workaround. The...