Search results for query: *

I have a Windows 7, 32-bit machine. I need to use both SQL2000 Enterprise Manager and SQL2005 Management Studio. I did the followings -- install SQL server 2000 install SQL2000 SP4 install SQL server 2005 developer version install SQL server 2005 SP4 at this point, both were working...

I have data like this in SQL (server 2000) -- <p class="MsoNormal" style="margin: 0in 0in 0pt"><b style="mso-bidi-font-weight: normal"><span style="font-size: 14pt; mso-bidi-font-size: 10.0pt"><font face="Times New...

I tried to create new alert via SQL Server Agent. keep getting this error. using SQL 2005. HELP!! TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot create new alert. (SqlManagerUI) ------------------------------ ADDITIONAL INFORMATION: Could not load...

I have a table that stores donation information - name, transaction_date, amount, fund how do I select: total amount >= $100 accumulated in one day, by one person? and yet, I need to display details. in other words, display individual records if the total amount belongs to multiple funds. Thanks

We are using Lyris Listsev, which runs on SQL Agent databse. We set up a backup job and code is below (all in one line) -- BACKUP DATABASE [TestLyris] TO DISK = N'E:\Backup\TestLyris.bak' WITH NOINIT , NOUNLOAD , NAME = N'TestLyris backup', NOSKIP , STATS = 10, DESCRIPTION = N'Weekly...

I would like to create a onclick command button for users to duplicate records. However, there is an auto-number (unique ID). How do I set it up to generate the auto-number? Thanks

I tried to use a pass-through query for a subreport and got an error. I found out that pass-through query cannot be used for subreport. Is there a way to work around it? Also, there is filter for the main report and the subreport will display the results based on the filter from the main...

I have 9 tables in a DB and there is a dateUpadated field in each table. We need to find and populate the most recent date in this field and compare among all these 9 tables. How should I do this in a stored proecdure? Thank you

I have a datetime field in the table. In a query, how do I do "group by month and year", discard the date part in that field? Thanks

I need to populate data into a form in Access from a param query. when user clicks on a button -> run param query -> user enter an ID -> find the record from that query -> populate the ID and name of the found record into the form fields I don't know much about the VB code. How do I write...

I have two forms (program and locations) that are linked by programID. Users go into Program Form, enter data, the programID is autoID. Then there is a "Add Location" button, to open Locations Form. And users can enter location information into Locations Form. One program can have multiple...

I created a form in Access for users to enter data. I have an "Add New Record" button, when onClick, it goes to a macro to open the form and open a new record. There is a hidden ID field, not auto-number. I would like to set that ID as "MAX(ID) +1". I tried set this up in the ID...

I am using FM Pro 6. I would like to write script that does "find within find results". For example, find 4 types of Press from a drop down. Then find 5 different status (another drop down) within these 4 types of Press. Thanks

We are using FM 6. Is there a way to insert fields/variables in the email body when using send mail script? thanks

I have a value list (radio buttons) that contains three values (the same field name). Like this, Comment: * comment1 * comment2 * comment3 I would like to make a script that when a user checks one certain value (if check comment2), send an alert email to someone. So far, I made the whole...

I am new to FileMaker Pro. I have a database with one field "Address", which contains "address1, address2, city, state, zip". Is there a way to break the data and put it in 5 separate fields "address1", "address2", "city", "state", and "zip"? There are almost 2000 records in the db. kind of...

I have a database in SQL Server 2000. Is there a way to export those data to Excel "dynamically"? I know I can do DTS, but I think DTS is not dynamic. Thanks

have the following code -- <cfloop list=&quot;#form.disciplineCode#&quot; index=&quot;discode&quot;> <cfoutput> <cfhttp url=&quot;http://www.mysite.com/testExcel.cfm&quot; timeout=&quot;30&quot; method=&quot;POST&quot;> <cfhttpparam name=&quot;discipCode&quot; type=&quot;URL&quot...

I use <cfheader name=&quot;content-disposition&quot; value=&quot;attachment;filename=statusSheet.xls&quot;> <cfcontent type=&quot;application/vnd.ms-excel&quot;> <cfoutput query=&quot;employee&quot;> ... </cfoutput> to create an Excel file from a cfquery. My question is, is there a way to...

I have an Access (XP) database with multiple tables linked from SQL Server2000. In Access, I cannot save edited data in some tables (but not all tables; in some I could.) I don't see any &quot;lock&quot; sign in the records, nor is there another user accessing the database/tables the same...