What is the alternative if you are calling the package from a stored procedure?

I use this method becuase you can pass in the variables @@servername and db_name() to the...

Nice article - well explained. I use this method to dynamically assign server / database name for a database connection when transferring data from a text file to a database...

I ran a test on a simple table with 1 datetime column containing 5 million records. Both queries ran at less than 1 second (using a table scan - no...

Do you have an index on your birthday column?

Regards,

Andy Jones

Joins are to return data from 2 or more related tables e.g.

select * from customers c inner join orders o on c.id=o.id

Union is to return multiple result sets of the...

"db2 is the same database as db1, with one difference: it is the restored backup of db1

". If this is the case all settings should be the same. In a...

Hi, this will give all tables with an identity column: -

select distinct o.name

from sysobjects o

inner join syscolumns c on o.id = c.id

where

o.xtype = 'U'

and c.status = 0x80

Regards,

Andy...

Hi,

Where do you want right aligned data - on a report, on screen? The above approach will only work if you are using a proportional font.

Regards,

Andy Jones

Hi, see the post of Klaas-Jan above to get you started.

Regards,

Andy Jones

Hi, I think this will work:-

declare @test-2 int

set @test-2 = 1

select top 10 * from table

where field between

case @test-2

when 1 then 1

when 2...

For the performance of the report I think the stored procedure method oultined above is the best solution. If you create a view and then

filter it you will be grouping...

If you are using a unique index (not a unique constraint) you can check the 'ignore duplicate key' check box on the indexes tab of the table properties in enterprise...

Alternatively you can assign global variables of a DTS package via the dtsrun command line utility.

Regards,

Andy Jones

Hi,

You can create global variables within the DTS package for source and destination. Then you call the package from a stored procedure using the dtsrun command line utility (via...

Good point about using a UDF. With regard to using BCP, my original requirement used files which didn't have a consistent number of fields on each line e.g.: -

1,2

1,2,3

1

etc...

I couldn't...