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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. hawkpie

    Outlook 2003 spell check only working some of the time

    Morning Got a weird problem with Outlook 2003. I have it set up to use Word as my editor and when I am typing in a new email it flags up any spelling errors with the red underline in the usual way. However, if I reply to an email and start typing, then this does not flag up any spelling...
  2. hawkpie

    Really weird problem with PC booting

    hiya unfortunately it's an onboard card :(
  3. hawkpie

    Really weird problem with PC booting

    Got an old Tiny PC in the loft and decided to give it to the local school. Got it all set up and cleaned down for them and was working champion last night. Takes it into the school this afternoon, sets it up, but the monitor won't on. PC seems to be fine, but the monitor just wont switch on...
  4. hawkpie

    Seeing the source of dynamic stored procedure

    cheers SQLDenis you're an absolute star. thanks for bearing with me. pie
  5. hawkpie

    Seeing the source of dynamic stored procedure

    that's cool for the event, but which column do i need to add to be able to see the sql output. ta for the info. pie
  6. hawkpie

    Seeing the source of dynamic stored procedure

    cheers for the info. will give that a try. you mentioned using the profiler too. do you know what fields/columns I would need to add to see the output SQL. (sorry to be a pain) cheers pie
  7. hawkpie

    Seeing the source of dynamic stored procedure

    cheers SQLDenis, but where do I do this? do I change this at the bottom of my stored procedure? but when I call it from my code (which pass parameters in) where does it get printed out to? my exec code at the mo is: EXEC sp_executesql @SQLString, @strParams, @address, @minprice...
  8. hawkpie

    Seeing the source of dynamic stored procedure

    Hi Everyone I have a beefy stored procudure which takes in 6 parameters and then does a bit of logic on the where clause. However, there is a problem with the results that are returned. Is there anyway I can see the final SQL code that is generated from this logic, so I can see what is going...
  9. hawkpie

    Should be an easy select, shouldn't it?

    vongrunt, you are an absolute star!! popped that into the stored procedure and it worked a treat. cheers pie
  10. hawkpie

    Should be an easy select, shouldn't it?

    Sorry if this is an easy one, but it just has me stumped. I have a table with 2 columns, here's a quick snapshot of the data: applicantid skillid 387 1 387 2 387 5 387 7 388 1 388 2 388 3 388 5 388 7 I need to write a Select statement that selects all applicant ids...

Part and Inventory Search

Back
Top