Search results for query: *

I have a DTS set up that exports a SQL table to an Excel file. By itself it works fine, however I am trying to use a Global Variable to change the name of the '.xls' table. This is my code (in a stored procedure): exec master..xp_cmdshell 'DTSRUN /S ServName /E /N ENN_Var_DTS /A DstTbl:8 =...

Can I use host_name() in a DTS export path? I am trying to export the results of a query to the requestors PC. Thanks JefB

In an "Insert|Database|Result" (from a SQL2K stored proc)is there a way to control either the font color in a single cell or the cell backround color, based on the value in the field? For instance, in a daliy schedule, I would like the unused time slots (field value = "Open") to be a different...

I am using the Calendar Control 8.0 on one of my FrontPage .asp pages. When the page is displayed (in Internet Explorer), the Calendar is visible on some PC's but not displayable on others (just the small "x" box). Is there a setting in either FrontPage, IE or on the individual PC's that needs...

I have a DTS Local Package that imports data from an Access database table. DTS is in SQL2000 on an NT Server and the Access database is on a networked PC. The DTS package works fine if I set it off manually but fails if I set a scheduled execution. This is the fail message (in Job History)...

Is it possible to feed a column name to a query as an argument in a procedure? My goal is a procedure to pull the value(s) from a single field, on the fly using the following code: CREATE PROCEDURE [dbo].[Eval_Test_Proc] @FldName text AS Select @FldName from (SELECT Evaluee...

We run SQL2000 on an NT box. According to my "hardware guy", we cannot do a direct tape backup of the server because "if we try to backup a database that is receiving data, the tape will hang up". This does not make sense to me, but more important, if this is true, how do...

I have a DTS Local Package that exports a query result as a ".txt" file to a secure ftp site. The package works perfectly. However, if I set up a scheduled job to run this, it fails. The history log says the following: >>Executed as user: SQL_SVR_U. ...Run OnStart: Copy Data from...

I use the following code to display data from a SQL2000 database in a spreadsheet as an &quot;.asp&quot; page. <%@ Language=VBScript %> <% 'Change HTML header to specify Excel's MIME content type Response.Buffer = TRUE Response.ContentType = &quot;application/vnd.ms-excel&quot; %>...

Due to an upgrade by one of our software vendors, we need to get up and running on Crystal Reports (linked to an Access database and later to an SQL2000 database). If allowed, can I get some recommendations for Crystal Report training in the Chicagoland area? Thanks JefB

I use FP2K to display data results from our SQL databases. I would like my users to be able to put this data into an Excel spreadsheet (so they can do their own manipulation and reporting). If I try a &quot;copy and paste&quot; from the web page to the spreadsheet, all we get is...

I would like to create a stored procedure that exports the result of a query to an Excel spreadsheet. Ultimately, I want to be able to execute the SP from a FrontPage Database Result so that the data displayed on the webpage can be moved to the spreadsheet by the user (on demand) for customized...

(SQL 2000) I am trying to write a stored procedure to copy a table from one server (SERV1) to another server (SERV2): CREATE PROCEDURE [dbo].[DailyServerSync] AS -- Update CleanSiteData BEGIN TRAN DELETE FROM wbrdata.dbo.cleansitedata INSERT INTO wbrdata.dbo.cleansitedata SELECT * FROM...

I have an Airline table in SQL2K. The fields, all varchar(50), are: AirlineID, AirlineName and AirportsServed. AirportsServed contains 1 or more airport codes: i.e. &quot;ORD,CLE,DFW,DCA,LAX&quot; I need an SP that will return all airlines serving a given airport. In other words; show all...

I am looking for suggestions for a Charts/Graph addin for FR2K. I use a lot of &quot;Insert|Database|Results&quot; in my pages and would like to add some charts and graphs to the tables. Thanks in advance. JefB

We have 2 servers; SR1 and SR2. SR1 is running SQL7 on WinNT and SR2 is running SQL2k on WinNT. Both servers have 'WBData' databases with 'MasterBuild' tables. The tables contain the same data and are designed the same. (We use the SR2.WBData.dbo.MasterBuild table as a backup to the other...

We have a very large table that, unbeknownst to us, created a transaction log that was 26GB (yes, GB) in size. Due to circumstances beyond my control, someone went in and deleted the log file. The only backup we have is from a month ago (don't yell at me, please). We cannot access the data...

In SQL2000 I have the following Stored Procedure: CREATE PROCEDURE [dbo].[DrugLookup] @hint varchar AS SELECT StudyDrug, StudyDrug2, DrugUsage FROM dbo.DrugName WHERE DrugUsage like @hint GO The [DrugUsage] field has key words describing the various uses of a particular...

Is there an SQL equivalent to the Access &quot;IIF()&quot; function? I find myself having to use Access2K queries linked to my SQL7 data when I would rather do it all in one place! JefB

I use a FrontPage2K .asp page to give users access to specific reports. I do this by using the standard database results table requiring the user to enter a &quot;clientID&quot;, &quot;projectID&quot; and password. This links to a SQL7 view (query) that, if the 3 fields match records in the...