Ok, in the database, that column will store either a 1 or a 0

Query the table, not open the table, and you will see them

Andrew SQLDBA

I just noticed that the column name of "Successful", that should be a bit data type, not text. A database will have better performance using a numeric value for that...

Do you have a unique constraint on that column / columns? No need to have an ID field. The unique constraint will handle that, so that you have only one...

You really should keep with the tools that come with SQL Server. Who knows the database server better than the programmer that wrote the code. I do not use any...

Thanks Everyone

Good explanation on this

Andrew SQLDBA

Oh Yes, that is perfect, that gives exactly what I expect.

Thank you very much for your help, and to everyone

Thank you

Andrew SQLDBA

Hey Guys

These are really close, but when I use an actual value from the database, I am getting a weird result.

This works perfectly if the date value is '5/15/2010', but...

Hello Everyone

They are still read-only. All the other databases are under the same parent directory. And they are doing fine. These are the only two that are read-only. This is...

I got it now.

Thanks

Andrew SQLDBA

Yes, that is perfect. I was racking my little brain on this one.

Hope that you don't mind if I take the code apart and figure out how it works, and...

This is really close, but when I add in the FirstName column, the query returns all records. I want only the name associated with the Max(ROWID)

SELECT Birthdate, DateID,MAX(RowID) AS RowID,...

My Mistake

My data that I gave you was incorrect. I have modified the DateID

INSERT INTO Birthdate

(

DateID

, Birthdate

, FirstName

)

VALUES

(

1

, '1900-01-20'

, 'Joe'

)

INSERT INTO Birthdate

(

DateID

, Birthdate

, FirstName

)

VALUES

(

1

,...

Sorry, Not exactly. I need only three rows returned. There are only 3 distinct dates. I need the MaxRowID for each of the dates, that persons name, and then a...

Thanks Everyone

Have a good one

Andrew SQLDBA

Ooops, I forgot to add this little tid bit of info that would be helpful

One of the parameters will determine what query to fire off inside the sproc.

a little sample...