I can't speak to the travel expectations as I don't do any. However, about the training -- I would say unless you can squeeze it in during work hours...

You could put a trigger on the table but I don't think you can directly pass parameters to it, so there may not be a way to get the new...

We still need more information.

What data type is the column "Deleted"? Also, add it to your select query so we can see a sample of the data...

Wow, that's a lot of tables.

If they are all part of the same app, I'd go with 1 DB.

Mark

You can opt to delete all the existing data in your final table(s) and then import everything fresh. This would eliminate the problem of duplicate records. That or...

It appears that your company does soft deletes by setting the field "Deleted" to 1 when it should no longer be returned in queries.

Your screen shot doesn't include...

Yes, SQL Server will retain the values when you change the data type.

Mark

Luis,

Exactly what I was looking for. Thanks!

Mark

Nice examples everyone, thanks!

Sean - I can only sell items individually and then in a second, pre-set quantity but that second quantity can differ between products. It could be...

micky - I'll check that out.

Sean - what did you have in mind? What can I do to make it more scalable?

Thanks,

Mark

All,

I couldn't query the table regardless of the actual SQL. I tried limiting the return data but that didn't work.

Also tried using DTS to import the table to the...

Thanks to everyone for the feedback!

Mark

Chad,

I looked in to doing the same thing but couldn't find much other than it appears to be incredibly difficult, if not impossible.

An alternative to the out-of-the-box SSRS front-end:

Malcolm,

If your values will always be in that format and lenght, you can try something like this:

select Left(ltrim(rtrim(YourFieldNameHere)), 6) + ' - ' + SUBSTRING(ltrim(rtrim(YourFieldNameHere)), 8, len(YourFieldNameHere)-7) as YourNewValue

from Blah

Just...

I think 2010 is the current shell for SQL 2012. Have a peek at this:

http://www.jamesserra.com/archive/2012/07/visual-studio-2012-does-not-support-bi/

Mark