SQL authentication requires more user admin than Windows authentication - but in a mid-sized company that might not matter so much, as it's not that much more when there are...

If you replace your SELECT * INTO and ALTER TABLE statements with a single CREATE TABLE statement containing the new column and constraint, your problem will go away.  But why? ...

Just following this one up.  So this query:

SELECT a.Municipality_No, a.Id_No

FROM TableA a

WHERE not exists (select x.Municipality_No from TableX x join TableA a on x.Municipality_No = a.Municipality_No)

Is faster than this one

SELECT Municipality_No,...

Is it about time that your users started using something like Access instead?

With that much data (as you've found), Excel just starts getting ungainly.

The Excel row limitation is way more than 10,000 - 65,535 rings a bell - so I am surprised that you are getting an error.

It may be possible to do all of this in one step through DTS, but my DTS is not good enough to know.  What I would do is

a) Create a...

Is the primary key an identity field?  If not, you need to populate it (uniquely) as part of the import - otherwise SQL Server tries to create multiple records with...

Convert your month to an integer between 1 and 12 (1 = Jan, 2 = Feb etc) using datepart and then use that in your ORDER BY clause:

select datefield

order by...

I know - but your original post quotes 'an identity column called row id' - you cannot insert 'to the middle of the table' with such a design.

Disagree.  INSERTS won't hurt a clustered ID index, as the records just go in at the end and no reorg required.

Try running this code and you'll get the idea:

declare @a varchar(120), @b-2 varchar(120)

set @a = 'COMPUTER CORP                                    45474'

set @b-2 = 'SQL IMAGING, INC     90159S'

select reverse(left(reverse(@a), charindex(' ', reverse(@a))-1))

select rtrim(left(@a, len(@a)...

Hi Jesper

I was actually answering the previous message; not yours, which made perfect sense.  Your solution effectively replaces my view idea with a standard (non-corelated ?) subquery and is the...

This is not strictly a corelated subquery - the subquery runs independently of the outer query, as the subquery's results do not depend on values from the outer query.  I can't...

Yuk, your problem here (if you hadn't already realised!) is stripping the filepath out of medialist.media to leave you with just the filename, which you can then join to MobileVideo.

Here's...

I think that your requirement for row aggregation rules out a simple join query directly.  However, why not create a view of

select orderID, sum(quantity) from [order details] group by orderID

and...