Viewing 15 posts - 31 through 45 (of 48 total)
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...
December 11, 2007 at 10:36 am
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...
November 21, 2007 at 7:11 am
close but what it needs it to use the date from .01 since that is the first date it hist going up.
November 20, 2007 at 12:55 pm
here is a before and after... it is somehow pulling another date...
ProjProjID ...
November 20, 2007 at 11:51 am
Thanks Bob.... We are fairly close, I am from Dayton.
Have a good Thanksgiving....
November 20, 2007 at 11:07 am
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...
November 20, 2007 at 10:55 am
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...
November 20, 2007 at 9:31 am
oops... with out the "[/size]"
BEGIN TRAN
DECLARE @Dummy smalldatetime,
@id VARCHAR(50),
@dt smallDATETIME
UPDATE #proj
SET
@Dummy = proj_start_dt = CASE WHEN (
...
November 20, 2007 at 8:56 am
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 (
...
November 20, 2007 at 8:55 am
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.
November 20, 2007 at 6:42 am
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.
November 20, 2007 at 6:35 am
thanks.. I must be missing something... below is what I have.
11256 ...
November 20, 2007 at 5:40 am
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...
November 20, 2007 at 5:09 am
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...
November 20, 2007 at 3:39 am
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...
November 19, 2007 at 10:54 am
Viewing 15 posts - 31 through 45 (of 48 total)