Forum Replies Created

Viewing 15 posts - 46 through 60 (of 69 total)

  • RE: Query Help

    Aw heck, I'm in over my head! :crying: I don't know what to do.

    Jeff, your script work perfect, and I was basically able to understand it. So...

  • RE: Help ! Seeing SQL Server from MS Access ?

    Interesting... I've never tried it. I've always just used Intergration Services. Is the Migration Assistant just as robust as IS?

    Michelle

  • RE: Query Help

    Wow, thanks guys! 🙂 This has been really helpful and thanks for taking the time to explain this!

    I'm going to work on this now and see if I...

  • RE: Help ! Seeing SQL Server from MS Access ?

    Hi jdowski,

    So many people have helped me through the way that I feel like I should try to pass it on. Do you have a request from an end...

  • RE: Best way to set up SQL Server 2005 to work with ASP.NET 3.5

    Hi smallbytes_99,

    I've sucessfully setup sql server on aspnet. You probably want to make sure that you're using the right version of IIS. IIS 7.0 only works with Vista,...

  • RE: Help ! Seeing SQL Server from MS Access ?

    Hi jdowski,

    I'm a newbie too. I've been working with sql for over a year, just doing simple lookups, but until just recently the requests have become much more complicated....

  • RE: Query Help

    Hello,

    This is a good post. I'm actually working on the same thing. I've messed around just a bit with transposing columns into rows, but this is something I...

  • RE: nested row_number () function

    Florian Reischl (5/14/2009)


    mmunson (5/14/2009)


    Can I get your opinion? Is my script pretty beginner stuff? I was just wondering because I have no frame of reference, I'm the only...

  • RE: nested row_number () function

    Florian Reischl (5/14/2009)


    mmunson (5/14/2009)


    Can I get your opinion? Is my script pretty beginner stuff? I was just wondering because I have no frame of reference, I'm the only...

  • RE: nested row_number () function

    Thanks for the reply GSquared. I appreciate your opinion!

    I continue to learn new functions based on the requirements from the users, and well, they can be pretty demanding! ...

  • RE: nested row_number () function

    Flo, I tried it again and I got this error. :hehe:

    Msg 4104, Level 16, State 1, Line 1

    The multi-part identifier "CRM_Orders.CREATED_AT" could not be bound.

    No worries though, I...

  • RE: nested row_number () function

    Hi Flo,

    I tried the new script and I got some errors. I noticed some typos with crm_statuscodes so I fixed all of them and now I just get this...

  • RE: nested row_number () function

    Can I get your opinion? Is my script pretty beginner stuff? I was just wondering because I have no frame of reference, I'm the only one in my...

  • RE: nested row_number () function

    Hi Flo,

    I tried your script and I got a 'Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '('.' error.

    It looks very interesting though, I'd like to try...

  • RE: nested row_number () function

    Wow, Holy Snap! I think that's what I wanted GSquared. I didn't know about CTE's.

    I'm going to take a closer look now and make sure I got everything...

Viewing 15 posts - 46 through 60 (of 69 total)