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...

The way everything is set up there will never be an instance where the field will be null. If it is there is no way to check it, it's a foriegn key.

Thanks a bunch!

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...

Thanks for all the info guys

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#]...

Darn! Why didn't I think of that? Thx.

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.

Thanks a bunch

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?

I looked into some other DTS packages that are run often and noticed the destination file address is on D://... How can I find out which Directories SQL Server can see?

I get the following error when I try to run the sproc in Query analyzer: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Create Table CertegyJob Step DTSRun OnError: Create Table CertegyJob Step, Error = -2147467259 (80004005) Error string: 'H:\DEVEL\CardsInc\Certegy...

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'm getting a NULL when the size pf the data is greater tha 20 when I use : SELECT right(ISNULL(RWAD1,'') + replicate(' ',20 -isnull(len(RWAD1),0)), 30) FROM CertegyImportFile_T_EC where recordtype = 'detail record'