Aww shucks. I certainly wouldn't say a genius but thanks for letting me know that worked for you. Make sure before you run that on your production box that you...

Can you create 6 import processes? One for each type of import. That way you can import your data into a table that is appropriate for what you are importing....

Nice job with the sample data and ddl.

Something like this should do what you are looking for.

update dh

set OrigStatus = x.Status

from documenthold dh

cross apply

(

select top 1 Status

from DocumentHold d

where dh.DocId...

Some details would be helpful but why oh why do you want to concatenate values into a single column? This breaks the basic tenets of sql. Have you considered how...

Just use nested replace.

replace(Replace(MyField, '*', ''), '-', '')

The company is call...

There is at least one more table that you did not provide ddl for. PSGADR

This table also appears to be a heap.

Charmer (3/27/2012)

---

Sean Lange (3/27/2012)

---

nvarchar(1)... not actually a performance issue but really???

All columns nullable...

No primary keys...

No indexes at all on at least 1 of the tables...

You pick the performance problems at...

nvarchar(1)... not actually a performance issue but really???

All columns nullable...

No primary keys...

No indexes at all on at least 1 of the tables...

You pick the performance problems at the ddl level....

Here is the ddl...

GO

/****** Object: Table [dbo].[PSAJCK] Script Date: 03/27/2012 21:32:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[PSAJCK](

[AJORI#] [nvarchar](9) NULL,

[AJPID#] [numeric](9, 0) NULL,

[AJJTYP] [nvarchar](1)...

mee.ron (3/27/2012)

---

Thank you everyone for your replies. The simple solution was to create the view that returned the date, job number and extended cost.

Mr Celko, I do appologize if...

If you can provide ddl (create table script) and sample data (insert statements) this is pretty simple. Take a look at the first link in my signature for best practices...

davidandrews13 (3/27/2012)

---

Sean Lange (3/27/2012)

---

davidandrews13 (3/27/2012)

---

Important to note. You are creating the view via SSMS and NOT a create view statement. I am not surprised that SSMS expands the actual sql...

davidandrews13 (3/27/2012)

---

Hugo Kornelis (3/27/2012)

---

davidandrews13 (3/27/2012)

---

bitbucket-25253 (3/27/2012)

---

davidandrews13 (3/27/2012)

---

surely it doesn't matter if you do SELECT *?

every time i...

Please don't cross post. direct all replies here. http://www.sqlservercentral.com/Forums/Topic1273526-8-1.aspx