Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CarlsonB100

  1. CarlsonB100

    Insert multiple results into a Text column....

    If you already have a text column to store the results, you can use the UPDATETEXT command (or you can create a temp table with a text column if you don't have one). You would still be doing your looping/cursor processing, but you could get around the 8000 character limit. The following example...

Part and Inventory Search

Back
Top