quote:

---

I just need the file names into to a table

---

If you don't mind using...

I don't think I'd use GROUP BY unless you need to use an aggregate function on Price1.

SELECT DISTINCT

(SELECT ISNULL(MIN(Date), d.Date)

FROM Dummy

WHERE MW1 = d.MW1 AND Date >

...

In SQL 6.5, I'd use a cursor unless you know the maximum number of Dats to be concatenated, in which case I'd use CASE with self-joins if that number is...

quote:

---

Jonathan,

I ran your ALTER TABLE

and got this error:

Server: Msg 1778, Level 16, State 1, Line 1

Column 'User.Username' is not the same data...

SELECT ServerId, JobName, MAX(ProcDate)

FROM DisjObEvt

GROUP BY ServerId, JobName, CAST(ProcDate AS int)

--Jonathan

quote:

---

Hi Jonathan!

Thanks for quick response.

That's exactly what I try to do

only in GUI

I create a RELATIONSHIP

USER.UserID -- COMPONENTS.UserID

What would be ALTER TABLE...

quote:

---

Any ideas? Thanks in advance!

---

Call Microsoft PSS, but be prepared to prove to them...

It sounds like only one column references the Users table, so the foreign key would also be only one column, e.g.:

CREATE TABLE Users(

UserId int PRIMARY KEY,

UName varchar(40))

CREATE TABLE Components(

UserId int...

DECLARE @mo tinyint, @sql varchar(8000)

SET @mo = MONTH(GETDATE())

SET @sql = 'SELECT ptdCol' + STR(@mo, 2) + '

FROM Abc'

EXEC(@sql)

DECLARE @mo tinyint, @sql varchar(8000)

SET @mo = MONTH(GETDATE())

SELECT CASE @mo

WHEN 1 THEN...

If there will always be just one logical server (i.e. no replication) and the "login time" is being calculated at the server, then it matters not.

--Jonathan

I saw something like this once. After much analysis we discovered that the client had two databases for the application, one Live and one Test, and the user had...