Recent content by awaria

The result set has detailed and header data elements related to PO and Invoices. Requested to have column added to results set for PO_Amt_Remaining. Not sure how to accomplish that data request. The result set has over 40 columns so I didn't know how to, or want to group on all those columns...

Appreciate some guidance. Apologize in advance, not a programmer, but, tasked with providing this data. Can perform std joins and less complicated queries. Not sure how to store or perform running total. Not sure of best method for gathering this data. Thanks in advance for your input...

That produced 5088161607.00 I used the cast as BIGINT to drop the .00 Thanks

Resolved. Needed to use BIGINT. Thanks, zaw

sql server 2008 R2 initial Query for review; SELECT SUM(CASE WHEN ACCT_UNIT = '90015' AND ACCOUNT = '1251' THEN TRAN_AMOUNT ELSE 0 END) AS AR FROM GLTRANS This returns 50881616.07 desired result is 5088161607. No decimal. Tried using cast as int, query below for review; SELECT SUM(CASE...

Many Thanks!! This is exactly what I needed. Disappointed I didn't figure this out Thanks again, AW

I need the results below to "pivot" so there is a record for each _BAL column for each dept. == COMPANY FISCAL_YEAR DEPT ACCOUNT SUB_ACCOUNT 00_BAL 01_BAL 100 2017 90417 5100 0 0.00 88887.85 100 2017 90417 5103 0 0.00 0.00 100 2017 90417 5200 0...

That is it. Like cte option. see many more uses for this function/expression Thank you both for your posts and assistance! awaria

Not sure how to run a query where a column will be populated with the value for the total number of records in the query results set, for each record in the record set. If query results have 5 records, then the value 5 should be in column C for each of the five records. name | dept | Col C...

(2) Databases, one abut 40GB and one about 5GB I have about a 2 1/2 to 3 hour maintenance window available The largest table has about 6M records.

I am looking for recommendations for a strategy to automate a nightly database update of a source DB from one server environment to a destination server environment. For reporting purpose, mgmt wants a nightly data refresh of a "reporting" server database(s) so users will develop Crystal...

Michael, Env = (VStudio 2008) (MSSQL 2008 R2). In the for loop container I have a script task, then ftp task then a sendmail task (optional). An FTPconnectionmanager and a sendmailconenctionmanager In the script task I have the following code; -- using System; using System.Data; using...

gk53, Got it working. Had to execute script task prior to FTP Task and had misspaelled connection name. Thanks for helping. Andrew

Thanks for reply. Not to sure where to apply the expression. I have the FTP Task withih a For each loop container. I tried to add a script task and put the password in a variable there, but nor sure I did it correctly, it didn't work. I placed the script task within the container as well. Not...

Using Visual Studio 2008 with MSSQL Server 2008 Sp2 on Windows Server 2008 R2 Building a pckg to FTP files to remote server, however, it fails because the connection manager will not save the password. I cab successfully test, but once connection manager closed, pckg saved and closed, the FTP...