Search results for query: *

Hi All, I have a simple DTS Package which executes a stored procedure and exports the result to an Excel file. In the stored procedure I use two dates like: Select * from Table1 where ScanDate betweeen @StartDate and @EndDate. Now I want to schedule the DTS Package so that it runs once every...

Hi All, This is related to one of my previous posts but different issue. This stored procedure has two select statement which returns two different sets of data, (one may return 200 rows, the other may return 400), but I want to have both on a single report for comparision. I have tried union...

I have a stored procedure. It takes two parameters @StartDate and @EndDate. When any date range is entered, @startdate always selects the closest monday and @enddate always selects the closest sunday(some one helped me out). It works fine as I did this for weekly results. Now they want to enter...

Hi All, If I have two dates in a stored procedure, like @StartDate and @EndDate, if the user puts in any dates for these two parameters, how can I round it to the nearest monday. Let's say user inputs: @StartDate = '06/04/2004' and @EndDate = '06/12/2004' I want @StartDate ='06/07/2004' and...

Hi All, How do I update a temp variable of table data type in SQL stored procedure. What is the syntax for that. Thank you, Shal

Hi All, I am trying to create a report, for which I need suggestions to write the query. I have a table1 which is shown below. Below that are month1 and month2 which are the reports I want to create, I have left the last column empty, which should be filled. If you see the table1, for the...

Hi all, I have a select statement with a text field along with other fields with aggregate functions. If I use the text field in my group by I get the following: "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator" If I don't use...

This is related to the query that I had posted earlier. The table is like: -------------------------------------- TYPE DOCUMENTNUM TRANDATE ---------------------------------------- TFO 06305 2004-03-01 TFI 07231 2004-02-12 TFO 07231 2004-02-10 TFI...

Hi all, I have a table which has rows like below: ----------------------------------- Documentnum TYPE TRANDATE ------------------------------------ 907837 TFI 2004-02-25 907837 TFO 2004-02-23 907688 TFI 2004-02-24 907688 TFO 2004-02-20...

Hi all, I have created a package using export wizard, which exports data to a text file by executing an SQL query. It works fine when I execute it. Now in the query I added an input parameter, this also works fine when I put a default value to the input parameter(global variables). Now I want...

Hello everyone, I used the wizard to export data from a table to a text file. I have given the path for text file as C:\testwrite.txt It works fine, but the file is created on my local machine, how do I specify the path so that it is saved on the database server? Thank you, Shal

Hi all, I am using the stored procedure below to send emails. It was posted by Colin Leversuch-Roberts on the web. It works very well, I get the emails, but without the attachment. Is it because of the file path I have given which is on my local machine? Should the file be on the database...

Hello, > > The cookie from the file below seems to work fine if all of our code > files are on a one machine. But if it is moved to the server and the > webpage is accessed from a client machine, the cookie is not being > set. > > Below is the code, could anyone please give some more...

Hi All, I have an application which writes (php script) the cookies to the client browser. I would like to access this using visual basic code from another application. Could any one let me know how to do this. Or is there any other way to do this,like if I have session variables how could I...

Hi all, I have a table which has 3 columns with values like shown below: Style Region Price 1 NZ 10 1 AUS 10 2 NZ 20 2 AUS 20 3 NZ 30 3 AUS 30 4 NZ 40 4 AUS 50 Now, is it possible to just display the last two rows using...

Hello, I am using ASP to run a SQL Server Stored procedure and then write the output to a text file using FSO. It is working fine. But I am having difficulty formatting the result in the text file. I want the output to be "Unicode text format, tab delimited". Could anyone help me...

Hello everybody, I have two tables, table1 and table2. Both have "barcode" column as primary key. Both have also got a column called "Weight" I want to update "table1", column "Weight" with values from "table2", column "Weight" where...

Hi, I have two forms.Contacts and Events. I am opening Events form from Contacts form and the form link criteria is Contactid.So right now I am able to open the Events form form contacts and see the one particular record.But I want to be able to see all the records in the Events form, not just...

Hello, I have a data entry form with data type check box.Let's say if I have about 500 records in the table and if I want to check a certain checkbox for all those records at once(which is empty at the moment), what is the best approach, appreciate help, thank you, Shalini