Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. General Programming
  3. C#
  4. Stored Procedure

Stored Procedure

Scheduled Pinned Locked Moved C#
helpdatabase
10 Posts 6 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • I Offline
    I Offline
    It_tech
    wrote on last edited by
    #1

    Hi all, I have a problem in getting the one below to work. I think i have used the right syntax. But keeps coming with error on EXEC Lline... CREATE FUNCTION Summary (@Month varchar(30),@Year varchar(30),@ShowType varchar(30)) RETURNS TABLE AS RETURN With EXECUTE C_WEB_sp_RevenueSummaryByShow 'April', '2010', '3' Go Thansk for your time

    L D A 3 Replies Last reply
    0
    • I It_tech

      Hi all, I have a problem in getting the one below to work. I think i have used the right syntax. But keeps coming with error on EXEC Lline... CREATE FUNCTION Summary (@Month varchar(30),@Year varchar(30),@ShowType varchar(30)) RETURNS TABLE AS RETURN With EXECUTE C_WEB_sp_RevenueSummaryByShow 'April', '2010', '3' Go Thansk for your time

      L Offline
      L Offline
      Luc Pattyn
      wrote on last edited by
      #2

      It is bad enough we have to endure LINQ, but these codez are not acceptable here at all. :~

      Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


      I only read formatted code with indentation, so please use PRE tags for code snippets.


      I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


      P 1 Reply Last reply
      0
      • I It_tech

        Hi all, I have a problem in getting the one below to work. I think i have used the right syntax. But keeps coming with error on EXEC Lline... CREATE FUNCTION Summary (@Month varchar(30),@Year varchar(30),@ShowType varchar(30)) RETURNS TABLE AS RETURN With EXECUTE C_WEB_sp_RevenueSummaryByShow 'April', '2010', '3' Go Thansk for your time

        D Offline
        D Offline
        dan sh
        wrote on last edited by
        #3

        This belongs to General Database forum.

        modified on Thursday, June 3, 2010 10:28 AM

        1 Reply Last reply
        0
        • I It_tech

          Hi all, I have a problem in getting the one below to work. I think i have used the right syntax. But keeps coming with error on EXEC Lline... CREATE FUNCTION Summary (@Month varchar(30),@Year varchar(30),@ShowType varchar(30)) RETURNS TABLE AS RETURN With EXECUTE C_WEB_sp_RevenueSummaryByShow 'April', '2010', '3' Go Thansk for your time

          A Offline
          A Offline
          Abhinav S
          wrote on last edited by
          #4

          Please remove this message from here. If you want an answer to your question, please post this in the General Database forum.

          My signature "sucks" today

          N 1 Reply Last reply
          0
          • A Abhinav S

            Please remove this message from here. If you want an answer to your question, please post this in the General Database forum.

            My signature "sucks" today

            N Offline
            N Offline
            Not Active
            wrote on last edited by
            #5

            No, do not remove the message! 6. Do not remove or empty a message if others have replied...


            I know the language. I've read a book. - _Madmatt

            A 1 Reply Last reply
            0
            • L Luc Pattyn

              It is bad enough we have to endure LINQ, but these codez are not acceptable here at all. :~

              Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


              I only read formatted code with indentation, so please use PRE tags for code snippets.


              I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


              P Offline
              P Offline
              Pete OHanlon
              wrote on last edited by
              #6

              You see, you can pour the scorn when you want to (in a very polite way of course).

              "WPF has many lovers. It's a veritable porn star!" - Josh Smith

              As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

              My blog | My articles | MoXAML PowerToys | Onyx

              L 1 Reply Last reply
              0
              • P Pete OHanlon

                You see, you can pour the scorn when you want to (in a very polite way of course).

                "WPF has many lovers. It's a veritable porn star!" - Josh Smith

                As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

                My blog | My articles | MoXAML PowerToys | Onyx

                L Offline
                L Offline
                Luc Pattyn
                wrote on last edited by
                #7

                I am aware I still need to learn a lot, that is why I pay attention to my Masters at every occasion. "His Master's Voice", one of my very first replies to you, you remember? :)

                Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


                I only read formatted code with indentation, so please use PRE tags for code snippets.


                I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


                P 1 Reply Last reply
                0
                • L Luc Pattyn

                  I am aware I still need to learn a lot, that is why I pay attention to my Masters at every occasion. "His Master's Voice", one of my very first replies to you, you remember? :)

                  Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


                  I only read formatted code with indentation, so please use PRE tags for code snippets.


                  I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


                  P Offline
                  P Offline
                  Pete OHanlon
                  wrote on last edited by
                  #8

                  That was a while back.

                  "WPF has many lovers. It's a veritable porn star!" - Josh Smith

                  As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

                  My blog | My articles | MoXAML PowerToys | Onyx

                  L 1 Reply Last reply
                  0
                  • P Pete OHanlon

                    That was a while back.

                    "WPF has many lovers. It's a veritable porn star!" - Josh Smith

                    As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

                    My blog | My articles | MoXAML PowerToys | Onyx

                    L Offline
                    L Offline
                    Luc Pattyn
                    wrote on last edited by
                    #9

                    yep. LINQ did not even exist back then. :)

                    Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]


                    I only read formatted code with indentation, so please use PRE tags for code snippets.


                    I'm not participating in frackin' Q&A, so if you want my opinion, ask away in a real forum (or on my profile page).


                    1 Reply Last reply
                    0
                    • N Not Active

                      No, do not remove the message! 6. Do not remove or empty a message if others have replied...


                      I know the language. I've read a book. - _Madmatt

                      A Offline
                      A Offline
                      Abhinav S
                      wrote on last edited by
                      #10

                      Mark Nischalke wrote:

                      Do not remove or empty a message if others have replied..

                      Oh sorry. Will make sure about that before posting 'remove the message' next time.

                      My signature "sucks" today

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups