Search results for query: *

I have inherited a JSP application which needs a lot of cleaning up. Before I chuck the existing code and start from scratch I'd like to know if there is something special about passing integer form variables. I have 2 html select drop boxes. One is populated in while loop with string value...

I need to write a query to insert from one table to another but I want to avoid inserting empty rows. This is what I'm trying: Insert into TableA Select * from TableB where Fieldname Not Null; But this is incorrect. How can I check for null value?

I need to update a field in a table called "RejectCollections" with a value from a temp table with the name "TigerTemp" based on matching fields called "rejectid". Below is what I have, will this work correctly? Update RejectCollections Set RejectCollections.COLL_TOTAL = TigerTemp.COLL_Total...

I have a dts which creates an .xls file but i have to click "create table" everytime just before running it. Is it possible to set this up so that it can be run inside a sproc thats called in a job at a certain time each day?

How can I duplicate a table using SQL in the Query analyzer?

I have the following query that I'm using but I get nothing back. I've checked the "rejects" table and there are records there. The query is: SELECT ' ' AS [Auth Code], CardPreferredQry.BankName, CardPreferredQry.ABA AS ROUTING, Right(RTRIM(LTRIM(CardPreferredQry.ACCT)), 6) AS [ACCT#]...

I need to mask account numbers. I have been asked to mask the first 6 digits to "X". Example: Acct number before mask: 123456789 After mask: XXXXXX789 How can this be done?

I have a field that I need to get the last 6 digits of. How can I do this?

I have a dts package that creates an excel file but it appends to the existing file instead of overwriting it. How can I get it to overwrite instead of append.

I need to write a query which returns all records that don't have a 602 or 610 in a field called subserviceID. This is what I currently have: SELECT * From rejects where SubServiceID Not In (602, 610) But it returns no rows. I have checked the table and the majority of the records have a...

When I run a dts package to create an excel spreadsheet I always have to go into the dts designer and create the table. How can I setup a dts to run in a job that runs on a regular daily schedule. (Like at 5pm every day)Without me having to worry with it?

How can I test the execution of a DTS package in a stored procedure? I'm using the following SQL cmd in the Sproc: EXEC master..xp_cmdshell 'DTSRUN /N TestDTS /E /S Localhost'

I have a query which doesn't show any data for any of the fields which I have set to align to the left as follows LEFT(Replicate(' ', 15) + IsNull(CONVERT(VARCHAR, RWFSTN), ''),15) Why is this and how can I fix it?

I'm getting an error ("syntax error near 'INNER'") with the following sql but I can't find where the problem is. Can some help out with this? UPDATE CollectionAgencyProgram_T_EC INNER JOIN (Rejects INNER JOIN Card ON Rejects.CardID = Card.CardID) ON CollectionAgencyProgram_T_EC.ProgramID =...

I have the following in a select statement that I need to convert to run on SQL Server. Any ideas? NZ([Merchant].[M_NAME],[Program].[ProgramName])

Is it possible to set global variable in a DTS package with data from a table in the database? If so how? Use SQL in activex? Set global variable from a sproc?

I have been able to select the records I need to update using the following Select statement: Select * From Rejects inner join Card on Rejects.CardID = Card.CardID where RIGHT(Card.AccountNumber,6) in (SELECT RIGHT(RWMSMO,6)from Table1)AND Rejects.SentToCollections is null And...

Hello all, I need to place the following qry into a sproc but SQL Server 2000 doesn't like it and I don't understand the query,particularly the words with double quotes...is this setting a variable? The person who designed it isn't available for me to ask. The qry: INSERT INTO Audit_T_EC (...

I have a DTS package that is to import the data from a .csv file into a table in my database. I have set the columns to the specific fields but I get an error when I try run the DTS stating that the primary key field doesn't allow nulls. I looked at the design of the table and the primary key...

Is it possible to import data from 2 different .xls files into one table inside 1 DTS package?