Something like this:

Select POBuyersItemKey

, substring( POBuyersItemKey, 1, 7)

, substring( POBuyersItemKey, 8, 1)

, '5967241' + '|' + '19-62006-9-20'

from ISFfactory

order by POBuyersItemKey

Be...

I read that gem. Had to read it twice to be sure that I wasn't misreading things.

Shaking head here all the while. Some days I think I should just go...

Here's the thing. You can use a hash to try and determine if you have a duplicate. Not for encrypting.

What I'd suggest is that you use a separate column...

[drive by post]

I'm lost again

[/drive by post]

Try also printing out the intermediate values. Either with PRINT or a SELECT to your query results. It will help you figure out what's being compared. You can also...

I think MS found it easier to say "varchar" rather then "charvar"

jay holovacs (5/28/2009)

......

SELECT * is typically resolved at compile time, and expanded to be the columns. So over time, if you've modified the schema, and a plan exists, this might not return...

AFAIK, you cannot create an instance programmatically using SMO. The setup program for SQL Server has to run, which is what VS does. It has a setup file set that...

Use the data import wizard to set up a basic package. From there, you can add to it.

there are lots of SSIS articles here on the site (http://www.sqlservercentral.com/Articles/SSIS) as well...

When someone said they ran the SQL, I said with the corrected question they couldn't get those results.

The newsletter is what the question goes out as, but it could potentially...

How does the job work? Why not just use Integration services to move the data.

You can take code off the Internet, IMHO, and use it in your systems, but I would not think that you can take it and resell it, meaning put it...

Luke,

thanks, but it shouldn't have mattered. now I need to check and see what else has changed

Ahhh, no more horses! They're everywhere.

I think Tia could get a horse to drink. She does some amazing things with horses. she got one to play fetch (http://www.youtube.com/watch?v=Xd6pxo1qYgE) and bow...