I wasn't sure if the trailing 0 would actually be the last digit in the string or not. If it is then this can be simplified a lot. ...

jerseyeddiem (9/3/2009)

---

This is what i am trying to accomplish, i dont think it will work,, but i think the theory of what i am accomplish is here..

this is what...

No clue if this is what you are asking for but it was the first thing that came to my mind.

CREATE TABLE #temp (test INT, test2 INT, data VARCHAR(10))

INSERT INTO...

You can try the user_name() or suser_name() functions.

But if you are only wanting 1 row per itemID you could do something like this:

SELECT * FROM #tab1 a

WHERE endDate = (SELECT MAX(enddate) FROM #tab1 b WHERE a.ItemId =...

Sorry, what I had assumed too much. Are you sure your query isn't working?

I did this just to make sure and it worked fine.

create table #Tab1

(

ItemId int,

GroupID int,

endDate datetime

)

INSERT...

acogswell (9/3/2009)

---

Good Morning! Signed up for the daily newsletter and finally decided to stop lurking and post something on the forums 😀

I would like to start out by saying I...

No problem, glad it worked. Have fun with the remaining logic in your process. Sounds like it should be fun.

instead of using a second table you could use the pivot function. this is what i came up with. i think it fits your requirements.

/*

Create Temp table #AGED1B...

SELECT create_date FROM sys.databases

WHERE NAME = 'TEMPDB'

EDIT: Sorry this will return the last time the SQL service was started.

The rowNumber is determined based off the row_number() function and it will be in the order of whatever is specified by the order by clause of that function. So...

This is a simple way to start. You might have to adjust the logic to determine what row you want to be returned.

CREATE TABLE #temp (empid INT, empname VARCHAR(50),...

While you are at it go ahead and follow the top link in lynn's signature. Please post the DDL scripts and some sample data.

This worked for me

DECLARE @test-2 VARCHAR(50)

SET @test-2 = 'http://xyz.com/customer/app1.asp'

SELECT REPLACE(@test, 'xyz.com','localhost')

Yep, drew's is much nicer and it handles the logic correctly. I don't even know what I was thinking now that I have read through a much better implementation.