Hi Bob, its your Bengal friend again 🙂

I have another SQL Server question, wondered if you could help me with?

I need to "join" the output of several queries so the...

One other quick question... Does anyone know how (if I can) once the results from this query (below) are done, I want to rerun a query that will check and...

close but what it needs it to use the date from .01 since that is the first date it hist going up.

here is a before and after... it is somehow pulling another date...

ProjProjID ...

Thanks Bob.... We are fairly close, I am from Dayton.

Have a good Thanksgiving....

thanks... I will give that a try, I am about ready to leave for the day but will be back in tomorrow... thanks for your help and I will let...

yes, the way it should work (sorry if I did not explain this better), is find the last one that has a date (in this case 11256.001.01), and then use...

oops... with out the "[/size]"

BEGIN TRAN

DECLARE @Dummy smalldatetime,

@id VARCHAR(50),

@dt smallDATETIME

UPDATE #proj

SET

@Dummy = proj_start_dt = CASE WHEN (

...

yeah, below is what I have....

BEGIN TRAN

DECLARE @Dummy smalldatetime,

@id VARCHAR(50),

@dt smallDATETIME

UPDATE #proj

SET

@Dummy = proj_start_dt = CASE WHEN (

...

awesome it works!!

THe only thing it is doing is the last date is not getting populated...

11256.001 1995-07-05 00:00:00

11256.001.01 1995-07-05 00:00:00

11256.001.02 NULL

11256.001.03 NULL

11256.001.04 NULL

it is flowing down to .03 and stopping.

thanks Bob... Let me give that a try... I appreciate your help... just looking at your code and playing with it you have taught me alot already.

Thanks.

thanks.. I must be missing something... below is what I have.

11256 ...

ok, I think I am just dense or something.

Below is what I have, it is not updating.. I am really lost and dont know what to do next... Sorry. Should...

Hi Bob... Did not mean to change things. The example I gave now is what I got after I implemented the changes. I am going to give your suggestions a...

ok, this is what I have, but it does not seem to be updating for some reason...

DROP TABLE proj_id_11256; -- my temp table

SELECT * INTO proj_id_11256

FROM PROJ order by...