Search results for query: *

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

I have a sql job we cannot schedule, it's PR related data, needs to be able to run when ready during payroll cycle process. I want to provide payroll dept utility/tool to run job when they're ready so there is no need to contact IT to run job. Want to remove IT involvement in bi-weekly payroll...

SQL Server 2000 SP2 Working an a query to extract item master data, where tables include item master Table A, item location Table B, item UOM Table C, all to be joined together. All item have one master record, so (1) record in Table A All items have (3) locations, so three records in Table B...

Attempting to add destination server, but, no servers appear to select. I registered the destination server in the source server's console. Could this be due to the destination server is 2000 standard and the primary SQL server is Enterprise 2000? Need assistance in getting log shipping setup...

Question, I have been researching and it seems that folks suggest Log Shipping or Replication. Can someone elaborate on the difference or benefits of using one over the other for this purpose. Thanks again, awaria

Just found out the destination server is SQL Server 2000 Standard, whereas, the source server is SQL Server 2000 Enterprise, will that cause a problem? Also source is on SP3 and destination is on SP4. Thanks for sharing your expertise. awaria