今天写的一个存储过程

1. begin
3. createtable#table
4. (
5. theIDintidentity(1,1),
6. PriceNamevarchar(1000),
7. theDatedatetime,
8. Pricesvarchar(1000),
9. theCTIDsvarchar(500)
10. )
13. declare@MyDatedatetime
14. DECLAREmycursorCURSORFOR--创建一个游标
15. selectdistinctTicketDatefromConceTablewhereTicketID=5
16. OPENmycursor
17. FETCHNEXTFROMmycursor
18. INTO@MyDate
19. WHILE@@FETCH_STATUS=0
20. BEGIN
22. declare@Myid1int,@thePriceNamesvarchar(1000),@thePricesvarchar(5000),@theCTIDvarchar(2000)
23. set@thePriceNames=''
24. set@thePrices=''
25. set@theCTID=''
26. DECLAREmycursor1CURSORFOR--创建一个游标
27. selectCTIDfromdbo.ConceTablewhereTicketDate=@MyDateorderbyCTID
28. OPENmycursor1
29. FETCHNEXTFROMmycursor1
30. INTO@Myid1
31. WHILE@@FETCH_STATUS=0
32. BEGIN
34. declare@theConcessionsvarchar(100),@thePricevarchar(1000)
35. select@theConcessions=ConcessionsfromConceTablewhereCTID=@Myid1
36. set@thePriceNames=@thePriceNames+'|'+@theConcessions
37. --set@thePriceNames=@theConcessions
38. select@thePrice=[TicketPrice]fromConceTablewhereCTID=@Myid1
39. --set@thePrices=@thePrices+'|'+@thePrice
40. set@theCTID=@theCTID+'|'+CONVERT(varchar(1000),@Myid1)
41. set@thePrices=@thePrices+'|'+@thePrice
42. --select@Myid1,@thePriceNames,@thePrices,@theConcessions,@thePrice
44. FETCHNEXTFROMmycursor1
45. INTO@Myid1
46. END
47. CLOSEmycursor1
48. DEALLOCATEmycursor1
49. insertinto#tablevalues(@thePriceNames,@MyDate,@thePrices,@theCTID)
52. FETCHNEXTFROMmycursor
53. INTO@MyDate
54. END
55. CLOSEmycursor
56. DEALLOCATEmycursor
57. select*from#table
58. droptable#table
60. end