Thanks to all who tried to help me on this one. The final solution ended up using a CTE and a row_number function similar to the code below. ...

See updated script above. I had an incorrect alias specified in my max where clauses. If you run the script that i provided, you will get two records....

Thanks for the suggestion Sean. See newly edited post above.

JS

i get this error when running that code.

Msg 156, Level 15, State 1, Line 4

Incorrect syntax near the keyword 'FROM'.

i have a system that tracks people and space. i am creating a stored procedure that takes a snapshot of some of the data on a regular basis. ...

Thank you for the links. I am already familiar with the RS Config Manager.

My problem now is that when i try to deploy my SSRS project or even a...

has anyone else had this issue with a local 2005 installation?

Ok, so after uninstalling anything that resembles SQL Server, I reinstalled SQL Server 2005 again. I ran all the service packs and updates and was able to get the...

thanks to all for your help. i have a second question but let me know if i should start a new topic. how would you extract part of...

is there anything wrong with using the below statement? it seems to give me the results i'm looking for.

SELECT SUBSTRING(field3, 1, 3) AS 'trimmed last field' from...

yep gotcha on the string length parts. does the value that i set for the variable matter?

Set @MyVar = 'abcdef';

would this approach require that the field containing the data to be truncated is all the same value? in the below sample, i just need the double quotes removed.

field1,...

i think i'm on at least SP3 but am downloading SP5 to make sure i have all the hotfixes to date. will let you know how that goes.

nope, no records being kicked past the destination. no errors or anything at all.

how would one go about tracing the connection as you mentioned? it's just...

yes it definitely is mapped correctly. i even deleted the OLE Destination and recreated it to make sure SSIS hadn't "forgotten" to update something. it's also coming through...