Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: Running a stored proc on table results

    That worked!

    I don't quite understand why though

    I expected that I needed

    to loop around the set statement.

    I was thinking along the lines of

    a regular 'while' like in VB...

    November 14, 2003 at 8:30 am

    #482071

  • RE: Running a stored proc on table results

    Actually you're correct but I was still getting results (26 to be exact) but at this point that wasn't my problem.

    Here's what i've got now

    

    declare @r...

    November 14, 2003 at 8:09 am

    #482059

  • RE: Running a stored proc on table results

    At this point my query isn't really returning anything...i think

    At this very moment i'm running this query on Query Analyzer and it STILL hasn't return yet.

    I thought that maybe initializing...

    November 14, 2003 at 7:26 am

    #482035

  • RE: Running a stored proc on table results

    Ok so I decided to that putting all the addresses in one variable and sending that to xp_mail would be my best bet. Here's how i'm trying to do...

    November 14, 2003 at 6:50 am

    #482024

  • RE: Running a stored proc on table results

    This actually sounds like a good idea! all I have to do now is work on creating the loop. Anybody want to provide a code sample?

    November 13, 2003 at 8:54 am

    #481884

  • RE: joining 2 queries

    First off, i'd like to give a BIG thankyou to JRN . His solution worked! I had no idea you could put a select in an inner...

    May 21, 2003 at 7:36 am

    #457966

  • RE: joining 2 queries

    I'm afraid that didn't work. I'm not sure why but the results seem to be getting multiplied or something. Ex. I know that on my one of the records a...

    May 21, 2003 at 5:58 am

    #457952

  • RE: Forcing a null

    At long last I have finally found my solution!

    Thanx to all that helped out. I really learned a lot! A special thanx to Dan who's little tip helped in a...

    March 24, 2003 at 11:27 am

    #451929

  • RE: Forcing a null

    Once again, I think I may be close to my solution.

    When I ran what dan gave me everything worked ok, but I still had too many dates from my calendar...

    March 24, 2003 at 10:53 am

    #451922

  • RE: Forcing a null

    I know this is going to look weird but is there any to join both of these statements together

    SELECT (dbo.Reps.[Last] + ', ' + dbo.Reps.[First]) as...

    March 24, 2003 at 6:52 am

    #451856

  • RE: Forcing a null

    quote:

    Ok, you must have a lot of actual records where RepWeeklyApp.RepID is indeed null. I assumed that it was a PK...

    March 24, 2003 at 6:39 am

    #451854

  • RE: Forcing a null

    quote:

    You need the date comparison to limit the rows to those weekends you want. I suspect that you have a logic...

    March 21, 2003 at 2:05 pm

    #451762

  • RE: Forcing a null

    quote:

    You need to change the first part of your WHERE clause (before the AND) to this:

    (dbo.RepWeeklyApp.RepID = 'CB909B54-7C0F-4908-B059-52B4027326AC' OR dbo.RepWeeklyApp.RepID IS NULL)

    Jay...

    March 21, 2003 at 1:43 pm

    #451758

  • RE: Forcing a null

    nope. Because in the RepWeeklyApp table there are only 2 records that filter with the where (ie. only 2 records with that repID.) This has been driving me crazy all...

    March 21, 2003 at 1:15 pm

    #451749

  • RE: Forcing a null

    Here's what i've got so far

    SELECT dbo.calendar.weekend, dbo.RepWeeklyApp.RepID

    FROM dbo.calendar LEFT OUTER JOIN

    ...

    March 21, 2003 at 12:56 pm

    #451743

Viewing 15 posts - 1 through 15 (of 15 total)