I think this relates.

I heard a story about a mother that was teaching her daughter how to cook. When teaching her how to cook a roast, she told her...

The reason it shows master as the default database is because master is the default "default" database. When your login was set up, someone didn't take the time to...

Could you post the file layout of the table in question? You may need to normalize it instead of breaking it into separate tables based upon artificial criteria.

Steve

The only time I found an Instead Of trigger useful was when I normalized a table by pulling out the Name field into its own table. I renamed the...

It sounds like you want to see the data in a different way than it is stored. In that case, just use a format statement when you retrieve the...

You said that if each client had a staging table you could use truncates. What is preventing you from doing this? If the application requires the staging table...

Have you considered try to parse the address1 field into its components? Then the parts of the address that are more relevant (house number, street name, etc.) can be...

Do you have a test database to try this out on? If not, restore a full backup to another database and try out the conversion safely against it.

Steve

I haven't started using 2005 yet, but I'm sure someone on the forum can help you.

Steve

The query works for me in SqlServer 2000. What version do you have?

Steve

Are the tables in jb1 and jb2 identical and you want to keep them that way with replication? If that is the case, why don't you just create a...

Your design, as others have suggested, cries out to be normalized. This from Books on Line:

"Normalization

The logical design of the database, including the tables and the relationships between them,...

In a small shop (1-2 developer / dba / system support) we have had occasion to contract out software to our specs when it is too much to do on...

I forgot to say that I worked at IBM less than a year but have had many computer related jobs since. Having a degree seemed to help getting jobs,...

I squeezed 4 years into 5 and graduated in '73 with a BA in Psychology after exploring majors of Math, Music, Engineering, Geography and Elem Education.

After no jobs to speak...