The only way to do what you want is to explicitly list all the column names from both tables and then alias one or both of the column names that...

lmu92 (1/12/2010)

---

It's still an insoluble...

How do I know if I have the correct answer if you don't show me what the correct answer is? How do I test with out test data?

lmu92 (1/12/2010)

---

Just for the sake of it (since the business reason is still a secret to me):

DECLARE @TheColumn INT

SET @TheColumn = 1

SELECT left((2009 + @TheColumn / CASE WHEN @TheColumn...

If we were working with character data, then we could have done 2009.1 and 2009.10. However, working with real (numeric) data we actually had modify the requirement and precede...

BH-428850 (1/12/2010)

---

Okay here is a pretty simple example. Keep in mind each client could have different columns within these tables as some of them can be user defined. There are...

lmu92 (1/12/2010)

---

Tara-1044200 (1/12/2010)

---

great, Lynn's query

worked for me.

For the same real data type how would i...

Does the order of the data in the record matter?

Edit -- Never mind. I got sidetracked. My development servers finally came back up and I had work to...

GilaMonster (1/9/2010)

---

Lowell (1/9/2010)

---

for aesthetic reasons (meaning it looks right to you), it's probably easiest to use SQL Server Management Studio to do this, because the designer lets you change the...

Chicken Fajita Burrito. That was lunch yesterday at Chipolte.

Not only that, but IIRC, you should be able to connect Visio directly to SQL Server 2005/2008 and create the tables directly.

If they have the DDL in scripts (text files?), you should be able to open those and run them in SSMS (SQL Server Management Studion) which is a part of...

update dbo.TheTable set

TheColumn = 2009 + (TheColumn / 100.00)

How about this?

What is...

Can you provide a simplified version of what you are attempting to accomplish including table definitions (CREATE TABLE stements), smaple data (INSERT INTO statements for each table), and expected results...