Well, I think everyone likes a little challenge.

Personally, I like a little champagne. Right about now. It's Friday, after all.

I say we keep this thread going until we've got, say, 6 more ways of solving this problem - OR - until San replies. Whichever comes first.

:o)

If you have an ODBC driver for the AS/400 DB2, you can create a linked server to it from SQL Server. Then you'll be able to query it using the...

San,

Surely you've got your answer by now, eh?

Lynn,

The problem there is the MAX function is still operating on a varchar, so if you have XYZ-11 in the table, XYZ-2 will show as greater than XYZ-11.

We're assuming...

Here's another method.. the charindex is necessary if you don't know the number of characters before or after the '-':

-- using Ken McKelvey's test date table

declare @t table

(

refNo char(5)...

I don't have an answer, and it's hard for us to examine this without the table structures and the data, however..

What I would do here is to break it down...

Very nice!

Dinakar,

To me it looks like the pattern is the changing price value. I don't see a way around the cursor in this case.

Looks to me that you'll have to use a cursor. The reason is that you need to loop through the records in date order to get the data formatted the...

You'll want to use the MySQL Connector/ODBC (also known as MyODBC) available here:

http://www.mysql.com/products/connector/odbc/

and setup a system DSN on the SS2000 server. Then you can connect with DTS.. OR you can...

I'm curious.. what kind of problems are you having with the upsizing wizard?

I'm not an expert on Data Warehousing, so I can't comment too much on the content, but the article needs editing to fix some grammar, etc.

Maybe stripping should be striping?

Good...

I would use the dateadd function with getdate:

select dateadd(m,-1,getdate())

will give you last month..

Also, if I were you I would write your query with the INNER JOIN clause, like this:

SELECT...

I think SQLBill is right on - especially the option of creating a login that only has read permissions.

However, we should also consider that some data is bad, and needs...