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

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

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

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

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

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

SQL Server Enterprise 2000 SP3 | Windows 2003 SP2 I have to build up a reporting server to offload the performance impact when users run reports against the production server. ERP server where finance group wants reporting server to be updated a couple times during the day so I cannot rely...

I have a integration utility that takes a tab delimited .txt file and imports the records (purchase Order line item data) into our ERP. Issue is, the one field [Item Description], many of the records have quotes ["} in the description and the import utility is fails on these records. Is there...

SQL Server 2000 Enterprise SP2 Need assistance with a query Need to perform two calculation(s) to return to two new field(s) at end of recordset. Table is "GL Account Trx Data" with GLacct#,TrxDate,TrxAmt as key fields. select constants Sum(Case When ?? then perform this calculation ...

Inherited Crystal Web XI report environemnt, no previous expereince. Figured out how to publish new reports, however, I am unable to delete published reports. Now have populated repository with multiple copies of same report, would like to clean up. Do not know the Crystal admin account...

Getting a division by zero error, cannot resolve formula; Have formula where attempting to divide by field with null value. Field A / Field B (where B is null) Use ISNOTHING to replace null with zero in Field B Here is the formula: =iif(isnothing(sum(fieldB)) = “True”, 0,iif(sum(fieldB = 0...

have a query that returns all the desired data, a profit loss report by GL Account. The parameters are Year, MOnth, and Dept. Dept can have multiple parameters. I now need to have subtotals by specified GL Account ranges. What is the best way to go about this so that the report is driven by...

I have a subscription that I want to run once a week using the previoous week's start and end dates. Is there a function or can someone share the syntax for setting up dynamics dates. The parameters for the report are Start Date and End Date. Thank you, awaria

Working on a report that will show gl summary data by account, per year, per month. Issue is when an account has no activity for a specified year and month, it doesn’t display since there is no records. However, I want to show a record with $0 balance for that specified year and month. Line...

SQL Server 2000 What is the syntax for an update statement where you set the fields values for record 1 equal to the values in record 2, records are in the same table? Thanks, awaria

SQL Server 2000 I have a table with records going vertically that I need to have multiple rows to end up as one record, per GLACCT, per YEAR going horizontically. Table Structure: GLACCT YEAR PERIOD BALANCE 100-1000 2011 1 $100 100-1000 2011 2 $150 100-2000 2011 1...

I have a report that has all the desired data in a one long record set. I need to now subtotal the records by GL account. Not sure of the best practice for doing so. Parameters are date range and dept. Ex: col1 col2 col3 col4 acct 10 $10 $5 $5 acct 11 $10 $5 $5...