Search results for query: *

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...

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...

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...

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

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...

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...

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...

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...

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...

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)) |_ |_ _ | _ _ |, | )(/, |(_)| ) '

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 ? |_ |_ _ | _ _ |, | )(/, |(_)| ) '

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 & "...

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...

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

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...

I have found using sp_executsql to be a bit difficult, but here is an example: declare @tempTable nvarchar(200) set @tempTable = 'SELECT sum(' + @tempTable + ') ' set @tempTable = @tempTable + 'FROM #ReturnStada ' set @tempTable = @tempTable + 'WHERE RoomType<>''Allotments left''' set...

Your right outer join is joining on non matching dates, where it should be joining on matching dates, and then filtered for null values from the rxWorks table. Try this instead: SELECT R.[Subscriber Code], D.[Date] FROM RxWorks.RxWorks.Result AS R RIGHT OUTER JOIN tempdb.#Dates AS D...

I am sure that DTS would be better employed reading your data from one excel workbook, transforming it in temporary tables using SQL, then writing to another workbook. But, as you have invested time in creating your macro, I would suggest creating an autorun macro to run your macro when the...

Stored procedures can be quicker than straight SQL especially if there is conditional processing. Also a query execution plan is created on first running, and cached, so if the Stored Procedure code remains static it reuses the execution plan. |_ |_ _ | _ _ |, | )(/, |(_)| ) '

Try: select convert(varchar(5), dateadd(mi, ([ActualTimeHours] * 60), 0), 8) It creates a datetime of 1/1/1900 + [ActualTimeHours] (1/1/1900 is serial time 0), then displays the first five characters of the time portion. |_ |_ _ | _ _ |, | )(/, |(_)| ) '