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!

Register Log in
  • Congratulations Rhinorhino 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 TheJon

  1. TheJon

    Add a search control to an ASPX page

    This is quite a quiet forum... Found it. Build a query string to pass the search term from a form field to the /_layouts/searchresults.aspx page. /_layouts/searchresults.aspx?k=sandwich%20cheese where k = the search term and optionally u = the list or library to be searched. Simple...
  2. TheJon

    Add a search control to an ASPX page

    WSS3.0 - Want to add a search control to the main body of a page in addition to the search control in the default master. Don't seem to be able to copy the <SharePoint:DelegateControl runat="server" ControlId="SmallSearchInputBox"/> code into any zones on the main page. Can't find the control...
  3. TheJon

    Split a document library into two - retining version history etc

    Steve, I came across the same problem the other day where the client wanted the library split for performance reasons. I created a template from the source library and created several target libraries using this template. Using SharePoint Designer I was able to move the files to the new...
  4. TheJon

    Mobile Camera Device

    Thanks everyone, that has given me some good information to go on. |_ |_ _ | _ _ |, | )(/, |(_)| ) '
  5. TheJon

    Mobile Camera Device

    I have a business need to supply camera devices to a mobile workforce to take photos of plant items in the field for simple editing / annotation and transmission via GPRS. I have come up with a solution which uses a wired webcam into the existing Panasonic Toughbook CF18, but our IT manager...
  6. TheJon

    Date Results Broken Out by Month

    You are trying to create a cross tab, grouped by customer. Not knowing your table structure, try something like this, which will show the last n months grouped by customer, showing each month across the table: declare @rptdate smalldatetime set @rptdate = getdate() select custname...
  7. TheJon

    Cursor output to sys_refcursor

    Engi, Thanks for your continued help. The procedure on the linked server requires individual parameters to be passed to it. This is why I am using a cursor to call the procedure line by line from the recordset. What I want to be able to do is replace the "DBMS_OUTPUT.put_line" section with...
  8. TheJon

    Cursor output to sys_refcursor

    I have no problem interfacing to MS reporting Services, however it needs a sys_refcursor type as the output parameter to the procedure. What is confusing me, is that I need to somehow store the results from each line of the cursor loop, then output the lot as a sys_refcursor at the end of the...
  9. TheJon

    Cursor output to sys_refcursor

    Hi, I'm used to MS T-SQL, and the concept of temporary tables and table variables. I have an oracle database serving data for MS reporting services, and one procedure I am trying to run does the following: Opens a cursor populated with a list of work requests, and associated data. Loops...
  10. TheJon

    Advance help sql query

    Watch out for the hanging spaces: txtsql= txtsql & " Where " either use txtsql=left(txtsql, len(txtsql) - 6) or try my code from above (observing DotNetGnats fine comment about placement of spaces (about 4 posts up)) |_ |_ _ | _ _ |, | )(/, |(_)| ) '
  11. TheJon

    Sum data with several grouping levels

    Is this more than: select dx_cd, person_id, sum(chr_allow_amount) from myTable group by dx_cd, person_id having sum(chr_allow_amount) >= 500.00 ? |_ |_ _ | _ _ |, | )(/, |(_)| ) '
  12. TheJon

    Advance help sql query

    Rather than taking the last 3 characters off your query to deal with an unsatisfied "AND", try building the query with a true statement and for each additional clause add it as "and blah = blah". e.g. txtsql= "SELECT a.PhysicianId, a.PhySpecialty," txtsql= txtsql & "...
  13. TheJon

    Tidier SQL code

    Where you should be using unique occurrences of the composite key, you are actually looking for permutations of the key fields which match your IMPORT table, even though they do not appear in the IDF table. Imagine 2 tables, each with 2 fields which make up composite keys. TableA...
  14. TheJon

    DTS trying to import empty Excel rows.

    Is there any data after row 29 in your excel file, (check rows and columns outside your expected range as well)? |_ |_ _ | _ _ |, | )(/, |(_)| ) '
  15. TheJon

    Function at lowest level and aggregate its results

    I have a cube showing customer debt where the fact table grain is based on customers. Each customer may have a debt value over the previous 4 years. Where a customer only has debt in the current financial year they are known as a "non hardened debtor". If they have debt over previous financial...
See more

Part and Inventory Search

Back
Top