Search results for query: *

Is there a way to deploy a custom web page created in SharePoint designer on a development SharePoint server to our production SharePoint server? We are using WSS 3.0 and Sql 2005. Thanks in advance, Dan

I need to figure out a way to pull a random sample of 5 calls per day per user. TableA (ID INT, UserID INT, CallDate DATETIME, CallDesc VARCHAR(100)) So far: select userid, callDesc from TableA where callDate between yesterday and today order by NEWID() But how can I pull just 5 recs per...

I was wondering if anyone knew if there was a limit on the number of reports run through Reporting Services (both scheduled and user run), before it either starts queueing reports or something else. Or is there even a limit (other than resources)? This is for Sql Server Standard 2005 SP2...

I am trying to modify the system stored procedure sp_addlogin, but getting the following error: "Msg 208, Level 16, State 6, Procedure sp_addlogin, Line 73 Invalid object name 'sys.sp_addlogin'." I can obviously see and open the stored procedure in Management Studio but not alter it using the...

Is it possible to execute a store procedure from with in a query? Example of what I would like to do: select emp_id, last_name, first_name, (exec sp_Get_Overall_Incentive_Score @emp_id = em.emp_id) as score from employee_master as em where term = 0 Thanks in advance for the help, Dan

I have the following SP I am trying to create... create Proc procDirectoryFilter ( @Filter nvarchar(1) ) AS ( SELECT * FROM Users WHERE SUBSTRING(LOWER(LName), 1, 1)=@Filter ORDER BY LName ) Everytime I try to compile it in Query Analyzer, it...

I need to print out the table structures of all the user tables of a particular database for documentation purposes. Is there any stored procedure or tool that will allow me to do this?

I am writing a stored procedure and would like to call another stored procedure and place the results into a Table data type. I know this can be done using temp tables.. Insert #tmpTable exec sp_StoredProcedure But since this causes more frequent re-compiles of the stored procedure I would...

Does anyone know how to change pages in the Visual FoxPro 8.0 image control for multi-page tiffs? Thanks in advance

Does anyone know what the escape character is for Visual FoxPro 6.0. For example when updating tables through SQL commands (Insert/Update) there might be times when we need to escape certain characters such as " and '. Thanks in advance, Dan

We are developing a web application using FoxPro as the backend. We have recently come across a problem, previously undiscovered by us. It seems that when you are using SQL statements to update a memo field in a table, you are not allowed to update it with more than 255 characters. This goes...

Does any know how to use the "Save As" feature in Internet Explorer when using either the Internet Explorer object or the Web Browser control. Are there any other tools that can download a web page from the internet? Thanks in advance, Dan

Does anyone know of a function or api call that will not return the list of files in all Upper Case? We have tried Sys(2000), ADIR(), DIR, and LIST FILES, and all of them return the file names in uppercase. It is imperative that we are able to return the filenames in their proper case...

After we create the IE object, by using: oIE = CREATEOBJECT([InternetExplorer.Application]) and navigate to whatever page using: oIE.navigate("www.tek-tips.com";) We would like to be able see what page the user has navigated to. Is there a property that shows what the current URL...

After we create the IE object, by using: oIE = CREATEOBJECT([InternetExplorer.Application]) and navigate to whatever page using: oIE.navigate("www.tek-tips.com") We would like to be able see what page the user has navigated to. Is there a property that shows what the current URL...

Is there a way to keep a table header static? This would be so that when you scroll through the rows of a table that extends past the length of a page, the headers will remain visible at the top. I would like to be able to do this without splitting the headers into another frame. Any...

I am haveing a problem with my CF app not being able to load frames when the Application.cfm file is in the directory. As soon as I take the application.cfm file out, the frames work as they are supposed to. Below is the code to the application.cfm: <!DOCTYPE HTML PUBLIC &quot;-//W3C//DTD...

I have an application that creates an instance of Internet Explorer as an object with the following lines of code: mLookup_Address = 'www.tek-tips.com' &&or whatever oIE = CREATEOBJECT('InternetExplorer.Application') oIE.navigate(mLookup_Address) oIE.visible = .t. I need to know if the user...

Can anyone offer some advice on embedding a Word document inside a form. The word document is the end result of an OCR'd image. What I need to do is to have the word doc on the left hand side of the screen and the original image on the right hand side, so that the user can compare them. I am...