Search results for query: *

I'm currently using SQL Server 2005. Sometimes, when I export a file in delimited format, there are trailing spaces included in some of the fields. Is that a bug? Doesn't exporting in delimited format normally trim the trailing spaces? If not, is there an easy way to trim every field without...

I found this macro on the internet that allows me to use interactive checkboxes in my Word document without having to protect the document. The only problem is that when I double-click on an unchecked box, it turns to a checked box but I can't double-click on it again to turn back to an...

I have a table called MASTER with 10K records: id segment 123 A 346 B 478 B 316 A I have another table called URLS_A with 6K records. This table has only one field "URL" -- every record has a unique URL value assigned to it. I have another table called URLS_B...

I don't know if VBScript is the best solution for my problem so feel free to suggest other options. I have a text file containing 100K+ records. I would like to delete all rows in the file that start with a space or double-quotes (") or the words "Grand Total". Would a VBScript be the best...

I'm not sure if this is the right forum, but I need help with an Excel Macro. I'm interested in creating a macro that will go through column A of a spreadsheet. If the value in column A equals "Total" (not case-sensitive), then the macro will highlight the entire row in yellow. Could anyone...

I have a cross-tab SQL function that is dynamic -- the number of rows and columns can vary each time I run it. Is there a way to output the results to an excel or csv/txt file through DTS given the dynamic rows & columns?

I was wondering if anyone could be so kind to help me create a user-defined function that would do the following: The function would take an input number from 1 to 9999999 and spit out every possible letter combination of these numbers based on the number-to-letter equivalents displayed on...

I have a DTS package that runs a query and creates an output file (with header). I'd like to know if there's a way to modify the package so that the output file is deleted if the query produces zero results. The reason I'm trying to do this is because the output file gets e-mailed to me to...

I need help figuring out how to do the following: I have a table that I want to remove duplicate records. However, my definition of a duplicate is any record that has the same Agent_ID and ANI values, but also have a Call_Date value that is within 1 hour of each other. (Call_Date is a...

I am totally new to Visual Basic and VBA. I created a Sub in ThisOutlookSession that takes any unread messages in a particular folder in my Inbox and downloads the attachment to a couple of places on the network. When I run the macro manually, it runs fine. When I let it run on its own in...

In my DTS package, I have a step that zips a file in a certain directory and another step that places the zipped file on the ftp. The 2nd step occurs upon completion of the 1st step. When I run the package, it runs fine. However, when I download the file from the ftp site and try to unzip it...

I'm brain-dead and can't think of how to write the following insert query. Need help. Thanks! I have 2 tables. Table A and Table B. The layouts of the 2 tables are different but for purposes of this exercise, I'm only concerned with 2 fields that both tables have in common: TFN and...

I have about 100 queries that I want to run as part of a DTS package. Do I have to set up up each query as a separate step, or is there an easier way to get them all executed in one step?

I created a DTS package that pulls a file and then puts it on an ftp site using "Execute Process Task Properties". The file transfer is done using FTP Command Line. My problem is that the ftp site requires the password to be changed every month or so (not on a regular schedule). However, the...

Not sure if this has been posted already, but how do you create a function or query to calculate the median of a set of values?

Here's my sample data: Campaign Market 1 Los Angeles 1 New Orleans 1 St. Louis 2 Orlando 2 Seattle I want to create a temporary table which will only have one record per Campaign value. All the Market values corresponding to...

Could someone help me write a stored procedure that will take a tab-quote delimited file (with header) and load it into a table? Thanks in advance! Here's some sample data from the text file: "Name" "Value" "Brian McMillen" "1722" "Anthony Adams" "8532" "Erik Jenner" "7209" "Terrance Walker"...

I'm clueless about VBScript so I'm hoping someone can help me modify this script. This script was generated by an application I'm using. I'd like to do 2 things: 1) Output the file in text format instead of HTML 2) Change the output file naming convention to reflect the creation date...

I would like to be able to do some conditional formatting in Excel, but I'd like to do it through a Macro since this will give me the flexibility to have as many condition statements as I want. Can someone help me with the VB script? Here is what I want to do through the macro. 1) Look at all...

I would like to be able to do some conditional formatting in Excel, but I'd like to do it through a Macro since this will give me the flexibility to have as many conditional statements as I want. Can someone help me with the VB script? Here is what I want to do through the macro. 1) Look at...