Search results for query: *

Need some help writing a query that will update a fields based on a lookup. The problem I’m having is related to how to perform the lookup table. The based table looks something like this. Stg_CustProfile: RecordId INT, EmailAddr VARCHAR(100), Firstname VARCHAR(100), Lastname VARCHAR(100)...

I help some help writing an sql statement. Lets say I have a table like: Table Structure: CustomerID CompanyID Account FirstName LastName A customer can have up to 4 account codes, so data in the table will looks something like this: CustomerID CompanyID Account[tab][tab] FirstName[tab]...

I need some help in writing a query; I have three tables for example, 1 Parent table, 1 child table, and 1 rules table. The rules apply to all the Childs of the parent. So for example: PARENT_TABLE --------------- PARENT_ID PARENT_NAME CHILD_TABLE ------------- CHILD_ID CHILD_PARENT_ID...

Is there anyway to verify if a file is being written to? I need to verify that the file that I'm downloading has been completely uploaded before trying to download the file. The problem that I running into is the script is downloading the while the file is still be uploaded. I requested the...

Hello All - I was wondering if the below query is possible? SELECT tDate, rCount FROM (EXEC usp_someSP) GROUP BY tDate

I have a requirement to format/round a number in a query to be in the millions. For Example: Original Value New Value 2,939,101 3 120,918,001 121 Does anybody have any ideas how I would accomplish something like this? Thanks in advance for your help!

I have a package that I already created, rather that creating a copy of that package I wanted to call it from another package. I figured out how to call and execute that package from another package. My problem is now before executing the calling package I need to set a global variable locating...

Hello all, I need help writing a query that will sum the Minutes. For format of the time field is: MMMMSST (the field will always contain 7 characters). Where M = min, S = Sec, and T = tenth of a sec. Any suggestion? Thanks

I need some help on how to insert a picture into a cell. The cell (A2) is set up like: =if(A1=B1, "check ok", "Error") I would like to do is insert a picture into A1, instead of the words "check ok" if A1=B1. Anybody have any ideas on how I can perform this action?

Could someone please explain what the differences between these two files are? I know the general difference, what I can not find the answer to is, why use Access Project instead a normal access database and just link the SQL Server tables to the .mdb file ? (performance reason?).

Could you some please help me with this script. The propose of the script is to update about 3 million rows. The problem is that the script is that it is not commiting the transaction after 50,000 updates. here is the code, if anybody has any ideas. --Set rowcount to 50000 to limit number...

A project that I working on requires me to delimit a text file that looks something like Field1|Field2|Field3|Field4 Fields 1 - 3 are delimited by "|" however field 4 contains 220 characters and is fixed width delimited. I need to parse field 4 into 30 columns. I was thinking about...

Hello All, I working on sample code, however when I try to run the DTS I get the following error: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:ActiveX Scripting was not able to initialize the script execution engine. Step Error code: 800403F9...

I have a string that is in the following format: MMMMSST where M = min, S = Sec, and t = tenth of a sec. so for example: 80, would be 8 sec... I need help on how to convert that into HH:MM:SS format. any ideas?

I have two questions, if someone can help me out: 1. I'm getting the following error when trying to excute the below SQL Statement: COMPUTE clause #1, aggregate expression #1 is not in the select list. DECLARE @@totalMOU int Select @@totalMOU = (SELECT Sum(tblCM.MOUs) AS MOUs FROM...

I need some help/idea on designing a table. Background/Requirements: We import a flat file on a daily basis (with about 700,000 Records) that looks something like: PortNo|CycleNo|SeqNum|FirstError|SecondError|ThirdError|FourthError|FifthError|TransactionDetails Layout of the File/Table...

I need some help importing data from Tbl A to Tbl B, the problem is that Tbl A has 780,000 records, so if I do just do a insert statement I'm running into Locking problems. I tried using a DTS...however I get the following error saying that my RecordID can not be null. Here is a layout of the...

I was just wondering if there was a way to start a DTS package from within my Java code...? I been searching...so far with no luck. I would like to use this tools, rather than creating a batch process (perforance reasons).

I have a text file that I need to import, however know they changed the format of the file and I having a some problems thinking up a way to import this in. Here is the layout of the file: FieldOne|FieldTwo|FieldThree|FieldTwo|...and so on to FieldNine. (All fields are delimited with...

I was wondering what methodology people here are using at there works for there software projects. I coming from a large company where there were groups that performed all that work, and I was just handed a set of requirements and I coded them and handed that code to the Unit testers...and from...