Post reply

repeat clients

  • October 14, 2010 at 12:53 pm

    #388009

    Hi guys,

    I can't solved some problem ,

    I have report where I show technician working hours,scheduled appointments etc,and I need to show in the report repeat clients.It meas clients which saw the same technician before.

    Report running by date range

    thanks

  • October 14, 2010 at 2:14 pm

    #1237200

    natalie_orlovsky

    In order to receive a tested reply please post table(s) definitions, some sample data, and any T-SQL statements that you may have attempted to use to solve your problem.

    Please click on the first link in my signature block for a method to perform all the above items, without excessive effort on your part.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 15, 2010 at 10:33 am

    #1237683

    Also explain what you mean by "Show repeat clients".

    Do you want a special column or flag or count? Or do you want the actual record to show for each time it's in the database?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • October 15, 2010 at 10:35 am

    #1237685

    Hi all

    Thank you guys,but I solved the problem,was too tired yesterday

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply