I am truly my own teacher... I got it to work:w00t:

select code, MAX(effective_date) as eff_date

from LIST_PRICES

group by CODE

having MAX(EFFECTIVE_DATE) > 0

This worked just fine. Thank you

Now to continue my "Pain in the butt" questions, what can I do for this same account to "modify" functions?

The reason for the...

Never mind... I figured it out. I was in the wrong database (master) when I needed to be in the actual database. :w00t:

Thank you for the help.

I keep getting the same message either through your suggestion or the cursor.

Msg 15151, Level 16, State 1, Line 1

Cannot find the user 'RptWriter', because it does not exist...

Perfect explanation. Thank you

Here are the tables. There is all kinds of constraints on the DME_ITEM table. The user will populate some or most of the data after the load; therefore,...

Thank you again Lowell for the help. If you don't mind, I would like to tap into your brain one more time on this statement.

Let me lay the...

Excellent... works like a charm. Thank you so much for the help...

The only thing I had to alter was the...

SELECT @SerialNumber = dbo.DME_ITEM.SERIAL_NUMBER

Changed to...

SELECT @SerialNumber = dme.SERIAL_NUMBER

To...

I had a problem similar to this when I installed SQL 2008, but it was on the Enterprise Edition. I forgot to remove Visual Studio 2005. Once I...

This forum is so good at response time. Thank you...

And on a lighter note, I'm an idiot. Just as my chuckleberry notified me of a new post, I got...

I figured it out. I was using a Control Flow Item called Execute SQL Task. That failed for all three users I was trying to drop. I...

I had no problems with this SQL in SSIS until Saturday. I was able to drop and create flawlessly. Something happened and it caused it stop working. ...

Excellent catch... thank you very much! :Whistling:

The DB owner should be okay (at least it appears to be) and I added another step in the SSIS package to synch orphan...

Never mind... I had a "moment"... Sorry

Thanks for the help!

RESTORE DATABASE [HCN_PROD2] FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\197.bak' WITH FILE = 1, MOVE N'HCN_Data' TO N'C:\Program...

I keep getting...

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near 'MOVE'.

Here's my actual SQL

RESTORE DATABASE HCN_PROD2

FROM DISK ='C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\197.bak'

WITH REPLACE

MOVE '197' TO 'C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Data\HCN_PROD2.mdf',

MOVE...