Recent content by bjr149

Ok almost there. This works fine but for another record type i have things like this.... PR13023 PR10432-V2 PR13213-V6 Can i re-convert back??

I have a list like this. RC1 RC1001 RC999 When i run a MAX function it returns me the RC999 record when it should be returning me the 1001 records. Is there a way to run the Max function and skip the first 2 letters of the record?

I know this query is out there. Im looking to query a whole database and return a list of all tables with the count of records in each. Is this possible?

I need to have a method in place to delete old records off of a staging table. I have this code that works for records that are over 4 months old delete from vcsv_payment_stage where time_moved < dateadd(mm, -4, getdate()) I want to extend this to years.. Is it just yy instead of mm??

Thanks this worked.

I have a string thats 50 characters. If the length of the string is 14 then i can take the first 14 characters. Which works fine... set @InvoiceLength = LEN(@InvoiceNumber) If @InvoiceLength < 15 begin set @InvoiceNumberFormatted = SUBSTRING(@InvoiceNumber,1,14) End If the String...

Thank you works great.

I have this command : convert(varchar(3),@Counter) As i do this i want to put leading zeroes on the string. So if counter is 5, i want it to print out 005. Thanks for the help

8.0 2 1 SQLCHAR 0 2000 "," 1 MTB_AssetLocations SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 6000 "\n" 2 MTB_SerialNumbers SQL_Latin1_General_CP1_CI_AS

bcp "select AssetLocations,SerialNumbers from AP_Payment_Push_Hold" queryout "D:\TEST.TXT" -f "D:\format.txt" -r "\n" -S ******* -U ***** -P ***** Im printing this to a text file, and on the SerialNumbers field for the field terminator i put a "\n". The problem is it actuall prints the end of...

This is through my DTS package.

In my table the field length is 6000. I take this data and dump it to a text file. The problem is when i dump the record to the table it cuts it off. It cuts off every record to this length and i cant figure out why. The destination fields are ok stating 6000 characters. Here is the field...

The reason why i need to disable the back button is because it screws up the application were running. All the navigation is supposed to be done within the UI screens. The problem is sometimes users accidentally hit the IE back button and it messes up their current session. Then they have to...

also i just want the buttons not to be there. I want to see the address bar and the regular file menu bar.

I noticed he said he liked this idea. "client-side JavaScript code to open a new window that doesn't have the toolbar." I'd like to give this option a shot. How do i remove the toolbar for a new opened window?