Microsoft SQL Server: Programming | Forum profile

Try CODE select S.StudentID,        Min(Review1) as Review1,        case when min(Review1) = Max(Review1) then NULL else Max(Review1) end as Review2 FROM WBLP

First, forget about all the other columns.  Get the rows where there are duplicate Id's. CODE Select this_ID From   YourTable Group By this_ID Having Count(*) > 1 Next, make this a derived table to get your results. CODE Select YourTable.* From   YourTable        Inner Join (...

Using [*] as field list is BAD! I doubt you ALWAYS need all fields from table(s). Use just needed fields in the queries. Also HOW you will join these tables? What is the common field between them? And how do you know if the some customers is still active, or it is enough to have a record in Orders Table for them? What if the last date in that table is 01 Jan 1432? Borislav Borissov VFP9 SP2, SQL Server 2000/2005.

Almost...but not quite. here is what I got when I ran your query. All the Parents repeat. I was hoping for one Parent and then all the children under that parent. It also almost looks like something is duplicating.  I'm going to verify that my data doesn't have duplicates in it.   CODE PARENT       1081074001411C...

This is the code I am working on. CODE SET NOCOUNT ON DECLARE @sql nvarchar(max) SET @sql = 'alter view vw_ABC as ' +'' SELECT @sql = @sql  + ' select ''[Server1].'+''+Name+''' as DatabaseName,E.Directory, E.Title, E.Created, E.WorkStation, E.Status, E.ItemCount, E.ItemTotal, E.RecordsWritten, E.Errors, E.Excluded, E.PartiallyExcluded, E.Incomplete, E.Size FROM...

Yes, I'm using it in SQL Server Management Studio. Haven't tried it from an asp.net script, I was testing it in the 'natural' environment first. Run it thru asp.net just now: Corrected a coupla C&P errors and it works! Thank you Markros!  You've just taught me how to do a multi-joined update query and not to trust what Microsoft products tell me! Have a star!

r937, let me know when you have clarified who's right. I like the idea Celko is suggesting very much, but would appreciate confirmation if this is the case or not. All I know is it works on mySQL and not MS SQL! Is that because mySQL is more standards compliant or less because it's allowing something that isn't in the standard? Is this another case of MS and standards, or a case of their being different standards that no-one...

Looks like you will have to buy the codes.  And it seems they may change and be updated often, so I doubt you are going to get the info for free.

I have a query: select phnID,phnumber from phone where phnRest not in ('1','2','3') Here is some sample data phnID    phnumber  phnRest 1         3239055   5   (shows up)...

One more question.  How do I handle if Review1 is NULL So the data looks like: StudentID   Review1     Review2 228017     12/30/2008    NULL...