Printing Out Transfer Rates
Dec 19, 2007Hi All,
I would like to print out a dataflow's tarnsfer rate (row/sec) to the output window and refresh it in each 5. second. Could anybody help me?
Thanks in advance.
m
ADVERTISEMENT
Transact SQL :: Printing Report - Capture Actual Pages In A Duplex Printing Job
Aug 10, 2015So I have been asked by our sustainability person to create report from our printing data that actually shows the number of pieces of paper used. This is easy enough for single-sided printing, but when printing in duplex the software does not take into account that 3 printing pages actually equates to 2 pieces of paper. I know this sounds simple, but say I have a print job record that looks like this:
Submitted printed total_pages duplex
8/10/2015 8/10/2015 42 1
This is a print jobs that if done correctly is actually 21 pages( duplex printing). If the job is say total_pages =5 I cant just divide by 2 because its actually using 3 pieces of paper ( yes they are wanting this data don't ask why). How can I adjust some sql to accurately depict 5 pages, front and back, as 3 pieces of paper?
Landscape Printing From Report Manager Not Printing All Displayed Columns On Each Page
May 3, 2007I have deployed a report that is configured for landscape printing. It does print in landscape, however, only the first seven columns appear on the first page and the other five columns appear on the next page. Is there a method, like in print preview setup in MS Excel, where we can scale down the print (like to 80%) so all columns appear on each page?
Thanks!
Rates Of Change...
Jul 20, 2005Hi,Is there an easy way to determine the rate of change for table? I realizethat I could do periodic select count(*) from XXX, but that would onlydetermine the size of the table. It would ignore updates.What I'd really like to do would be able to determine the number of non-readoperations over a table so that I can determine the rate of change for thattable.Thanks for any help..
View 1 Replies View RelatedAverage Download Rates For SQL Server
May 4, 2007I have a SQL Server hosted on a Win2003 server. I have a monitor on the server letting me know the average download speeds. When I do a large select from a remote connection, it looks like the download rate maxes out at around 10 kb/sec.
Is this an average download rate for a server hosting sql server?
Latest Known Exchange Rates MDX Query
May 29, 2008Hi,
I have this specific problem, that has been causing me alot of headaches for the last couple of days, and I can't seem to fiure it out on my own.
Basically i am working on a many to one currency conversion setup, where I have a fact table with exchange rates for periods and for all input currencies. The reporting currency is USD. Here is a demonstration of the data in it:
Valid Date Source Currency Rate
2008-01-01 GBP 2.0563
2008-01-01 EUR 1.4634
2008-04-01 GBP 1.9968
2008-04-01 EUR 1.5197
Normal period by period conversion is easy enough, but I want to convert the measures at the latest known rate, based on the period selected. Lets say I run an analysis without slicing on time, then it want it to convert at the last entered rate of all time, and if the user wants to run the analysis as of March 08, then it should convert all data to the rate as of January, since this is the latest one known.
I have tried to set the measure to a semi-additive behaviour, with "lastnonempty", but the problem with that is the conversion over time. Here is an example:
I want to show a measure summed "all to date" as of June 08. What I want is it to convert everything at the rates entered in April 08, but what I get is that it convert everything up until Jan 08 and the rates entered in January, and thereafter it starts to use the rated entered in April.
Period Amount LCY Currency Code Exchange Rate
Dec 07 100 GBP 2.0563 (Wrong, should be 1.9968)
Dec 07 100 EUR 1.4634 (Wrong, should be 1.5197)
Jan 08 100 GBP 2.0563 (Wrong, should be 1.9968)
Jan 08 100 EUR 1.4634 (Wrong, should be 1.5197)
Feb 08 100 GBP 1.9968
Feb 08 100 EUR 1.5197
Mar 08 100 GBP 1.9968
Mar 08 100 EUR 1.5197
Apr 08 100 GBP 1.9968
Apr 08 100 EUR 1.5197
May 08 100 GBP 1.9968
May 08 100 EUR 1.5197
Jun 08 100 GBP 1.9968
Jun 08 100 EUR 1.5197
How do I create a measure containing the latest known rates based on time selection?
Thanks in advance
SQL Server 2012 :: Get List Of All Workers Having Same SET Of Rates?
Feb 3, 2014 I have attached some test data for you that has two temp tables "#worker" and "#worker_rate".
The issue is to find all workers who are sharing SAME SET of rate_codes.
I'm able to get the output as "workers sharing same rate_codes", but unfortunately I could not get the list of workers sharing same SET of rate_codes. Also definition of SAME SET is not defined.
I don't know what I'm missing.
T-SQL (SS2K8) :: Comparing Various Currencies Hedged Rates
Jun 13, 2014I have a task to provide users with a list of currency rates in the following format:
Base Currency
Hedged Currency
Base to Hedge Rate
Hedged to Base Rate
E.g.
"Base Currency"..."Hedged Currency"..."Base to Hedge Rate"..."Hedged to Base Rate"
GBP....................USD.......................1.70.........................0.59
GBP....................EUR.......................1.25..........................0.80
(the dots are for the visual only)
The table I have been provided in SQL has the following structure:
Currency Code
Currency Rate (Rate against the Base Currency)
Base Currency (BIT to recognise which currency is the base one as it can vary from site to site. Only once currency can be Base per a given site)
I have started to implement, but ended up with cursor and temporary table, where I insert the data.
SQL 2012 :: SELECT Query On Currency Rates
Jun 20, 2015I have this query to select the highest currency rate from a currency table:
SELECT
Target_currency AS [Currency]
,rate_exchange AS [Rate]
,date_L AS [Date]
FROM
rates
WHERE
target_currency IN ('USD','GBP','JPY')
ORDER BY
target_currency desc
,date_L desc
My output is something like this:
CurrencyRateDate
USD 1,13572015-06-20 00:00:00.000
USD 1,37952014-03-31 00:00:00.000
USD 1,28352014-03-24 00:00:00.000
USD 1,28522013-04-05 00:00:00.000
JPY142,37552014-03-31 00:00:00.000
JPY1202014-03-24 00:00:00.000
JPY119,32013-04-05 00:00:00.000
GBP 0,82872014-03-31 00:00:00.000
GBP 0,08482014-03-24 00:00:00.000
GBP 0,084392013-04-05 00:00:00.000
How can I get the top 3 of the most recent rates from every rate in the WHERE filtering?
So:
USD 1,13572015-06-20 00:00:00.000
JPY142,37552014-03-31 00:00:00.000
GBP 0,82872014-03-31 00:00:00.000
I have tried many solutions, but I can't get it to work.
SQL Statement To Compute Employee Pay For A Year At Different Pay Rates
Nov 23, 2005I would like a single SQL to return all employee's total billablecompensation for a year. Their billable rates change throughout the year sounder the employee table (one), there is a compensation table (to many)which has the employee id, effective date, billable hourly rate. So in agiven year calendar year they could have many different (though usually 2 atmost) rates. These rates then have to correspond to and e multiplied bytheir corresponding billable hours from the time sheet table.I know I could create a series of UNIONs and hard code the effective dates,i.e.select from time sheets where employee=john and timesheet.task_date betweenjan 1 and jun 1, compensation.billable rate * timesheet.billable hoursUNIONselect from time sheets where employee=john timesheet.task_date between jun1 and dec 31 compensation.billable_rate * timesheet.billable_hoursI'd have to do that for every employee in a very large SQL.Is there an easier way using straight SQL? If not could it be done with astored procedure?Thanks for any insight.
View 2 Replies View RelatedSSIS Package Fails In A Job - Currency Rates Updater
Oct 12, 2006Ok so I created a SSIS package to get currency exchange rates from web service - http://www.webservicex.net/CurrencyConvertor.asmx . Everything works fine I can run it successfully - i uploaded to SSIS package store - runs successfully./
BUT when I put it in a job - it FREAKING fails every *dem time.
In addition to run it the JOB as SSIS package from store - also straight from the File System = still same freagging error - and SQL 2005 has gotten more stupid than SQL 2000 & DTS - they provide no clue as to y you get an error
Help please?
Data Collection On Production Server To Capture Growth Rates
Mar 18, 2015I setup data collection on a production server to capture growth rates.
When I run the dis usage report, it shows a daily growth rate of over 500 megs. This seems excessive to me.
As a troubleshooting step I then ran sp_space used and got these results:
database_namedatabase_sizeunallocated space
rgc_prod 273442.63 MB3648.48 MB
reserved data index_size unused
265345488 KB164385384 KB99826072 KB1134032 KB
What should my next steps be to try and determine why there is so much growth? And isn't the index size rather large?
T-SQL (SS2K8) :: Import Data From XML Feed To Get Daily Exchange Rates
Aug 26, 2015I'm trying to find a way to import data from this data xml feed to get daily exchange rate. I' tried:
select *
from
openrowset(bulk 'http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml',single_blob) as x
Which is a feeble attempt at a start; however, am getting this error message:
Cannot bulk load because the file "http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).
How to parse this file using SQL.
Power Pivot :: Calculating Exchange Rates Depending On MONTH
Apr 23, 2015I have created a spreadsheet using powerquery and powerpivot. Loading the data on powerquery from different spreadsheets was a charm, the problem is calculating the exchange rates per month.The structure is as following:I have 3 tables, they are:
Dates– Just a dates (loaded directly on PowerPivot).
Invoice – Details of invoices for all customers, gross totals are in different rates (loaded through power query)
Customer – Detailed information of customers (loaded directly on PowerPivot).
Currency – exchange rates (loaded directly on PowerPivot).
Note: I mentioned where they were loaded because I do not know if that really matters, I guess it does not... but extra information will not hurt. Now, let's go to how these tables are connected between each other and their key columns.The Invoice table has information on invoices dates, invoice gross total and customer code. This table is related to Customer table, which has the actual name of customers and other details. This link is done through the Customer Code column. The Currency table have a relationship with the Customer Table through the Country Column.
What I want to achieve is a formula to do the exchange rate based on the Invoice Date column present on the Invoice Table. So I have created a column on the Currency Table named at each month of the year and populated it with the exchange rates for all countries (countries listed using ISO3 format).My problem is while I am able to select a column from the Currency table to do the exchange rate calculation using the below formula, I fail to realize how to do it per month:=CALCULATE(sum(invoice[Gross Value])*SUM(Currency[Reverse]))*Reverse is the column with the exchange rate for the country money to USD.What I am failing to do is how to make that calculation to also consider the month of the invoice and pull the exchange rate for the same month from the Currency table
Get the invoice date then find the column on Currency[Month] and multiply, providing me the USD amount.I was unable to figure out a solution using the filters parameters from Calculate. If some of you ask why I am using SUM inside Calculate, is because if I only use SUM and try to do the math between the two tables I get an error saying that it was not possible to determine the value on Currency[Reverse]. Same happens with SUMX. It worked out with Calculate, but then I cannot create other formulas using CALCULATE on that table because it will give that error on redundancy, unless I add a filter on it, which worked last time (but I do not remember which thing /parameter used to filter, so do not ask it right now.I do not really need that level of accuracy, but my Virgo perfectionist side demands me to find a solution to that, that will not use a single exchange rate, but consider which is the correct exchange rate for the month of the invoice and calculate it correctly for all invoices. Just so you know, the Invoices tables has more than 1million lines.
SQL Server 2012 :: Calculate Failure Rates Of Systems Based On Cases Opened Through Support
Jun 5, 2014I am trying to build a query which will be used in an automated report to calculate failure rates of systems based on cases opened through support. Here is where I am stuck. Some systems may have multiple cases opened within the same span of another cases however we would consider this one failure:
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase22013-07-12 16:27:50.0002013-07-12 16:29:12.000
System ACase32013-07-12 17:30:32.0002013-07-12 17:40:11.000
System ACase42013-07-12 19:00:24.0002013-07-12 19:04:14.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
Lets say System A generated those 5 cases however Case 2,3 and 4 all happened within the same period as Case 1 so those 4 cases should count as one failure so my end result should be
System ACase12013-07-11 13:17:09.0002013-07-15 12:05:03.000
System ACase52013-10-01 18:02:23.0002013-10-01 18:11:26.000
And that system should show me 2 failures. I was thinking of using a temp table but not sure if that is possible as I am stumped on how to compare the dates to be able to validate if they fall within the range of an older case and whether or not to include them into the new Temp Table.
Transfer Manager Does Not Transfer Stored Procedures
Oct 22, 1998I am using transfer manager in SQL 6.5 to copy a database and
all objects with data to another server. Transfer manager is not recreating all stored procedures. This even happens when I used it to another database on the same server. Any ideas??
Transfer Data To New Table Then Transfer Indexes
May 30, 2008Is it possible/advisable when transfering very large amounts of data from server to server to:
trasnfer the data to a new table first
second alter new table adding indexes, defaults, ets based on original table
if it is what flow item would be used to transfer/alter the indexes and defaults?
I'm very new to ssis so the more detail you can give the better.
Thanks
Transfer Manager Transfer Dying?
Feb 16, 1999Hello:
I have been trying to run transfer manager to transfer all of the data
from the production database on one server to a test database on another
server(to refresh it). In order to make sure it runs on the server, I have
been scheduling it under EM to do so and I am pointing to the log on the
destination server on the EM Transfer panel.
For some reason, I am getting the following message in the destination
server error log:
99/02/16 10:24:41.42 ods Error : 17824, Severity: 10, State: 0
99/02/16 10:24:41.42 ods Unable to write to ListenOn connection
'.pipesqlquery', loginname 'sa', hostname 'TEMP09'.
99/02/16 10:24:41.42 ods OS Error : 232, The pipe is being closed.
99/02/16 10:24:41.42 spid17 Error : 1608, Severity: 21, State: 2
99/02/16 10:24:41.42 spid17 A network error was encountered while sending
results to the front end. Check the SQL Server errorlog for more
information.
I checked the event viewer error log and see no messages for today.
Can any one advise me what I need to do for this to run successfully?
Thanks. Any information furnished will be greatly appreciated.
David Spaisman
Printing
Jun 5, 2007I looked through a couple of database books I have and I really didn't find anything about printing.
My question is can you print the data directly from a database in C# or do you have to write it all to a textfile then print the textfile?
Be easier just to do it from the database and eliminate the text coding, just not sure you can do that.
Printing From Pocket PC
Mar 1, 2004Hi,
I am developing an applicaiton through which, i want to print from pocket pc emulator 2003. I am using PrinterCE.NETCF SDK to do this task. I am able to print from my applicaiton like we do in ASP (Printing one line at a time). In PrinterCE, there is an option of printing the output to a file. But, I am not able to find how we do it.
So, I want to know how we can print the output through PrinterCe into a file. Can anybody help me??
thanx and regards
ramesh chandra
Printing ™ Character
Apr 23, 2008does anybody know why trying to print ™ character in 2005 does not work while same works in SQL 2000? The ascii value is 153
SELECT CHAR(153) returns ™ in sql 2000 but Ö in 2005.
Printing To Txt Files
Nov 5, 2005Hey all,
I'm new to SQL and am having some troubles w/ a problem I was given.
I have two tables (OrderTableA & OrderTableB) which are linked by an OrderID. What I need to do is have the two tables printed out to two txt files. Below is the code I have so far.
CREATE TABLE OrderTableA(
OrderIDNUMBER,
OrderDateCHAR(24),
CustomerIDCHAR(8),
TotalDEC);
CREATE TABLE OrderTableB(
OrderIDNUMBER,
QuantityNUMBER,
DiscountNUMBER,
UnitPriceDEC);
SELECT OrderID, "#" + OrderDate AS OrderDate, "&" + CustomerID AS CustomerID, Total
FROM OrderTableA;
SELECT OrderID, Quantity, Discount, UnitPrice
FROM OrderTableB;
The txt file for OrderTableA has to look like this:
!!OrderID OrderDate CustomerID Total
---------- ----------- ----------- ------
123456 #123456 &123456 123456
with the !! before OrderID in the header, the # before OrderID in the table and the & before the CustomerID in the table.
I'm not sure my code above is correct so far, and I've no idea how to print this to two txt files.
Any help would be greatly appreciated!! Thank you!
SRS Printing Only One Of Two Columns
May 9, 2007I have a report with two columns. It works fine in SQL Reporting Services, but when I push it to the Report Server it only prints one column instead of the two that it's set up to print.
What am I missing?
D-Monk
Printing Problem
Oct 29, 2007Hi i'm having a problem in printing a reporting services report. Between each page it's giving me a white paper. What can i do in order not to get the white papers anymore? Any help?
View 4 Replies View RelatedCan I Force Printing?
Sep 1, 2005I have a script or SP that takes a very long time to performmultiple tasks, and after each one there is a PRINT statementthat shows the time and what was just accomplished, to help memonitor what's happening and estimate how long it will take.In a script, I can put a GO after each PRINT to cause the outputto appear immediately, but that's not possible inside an SP.Instead, it seems the output goes to a buffer, and the bufferis only output when a PRINT causes the buffer to become full.Sometimes there is a long delay before the buffer fills. Isthere a way other than GO to cause immediate printing? (Iguess I could just use longer messages, and fill up thebuffer with every one, but that's not very elegant.)Thanks,Jim GCountrywide Home Loans
View 2 Replies View RelatedProblem With Printing
Jul 25, 2007Hi! I recently begin to use reporting tools of SLQ 2005 instead of AR or CR. I found the DUI very easy to use and I'm partially sastify beause when I try to print my report, the printer always blow out a second white page. For one page report I can live with that but for 156 page report it's becoming a lot annoing. Is there somebody who experience the same problem? And by the way resolve it?
Here the dexcription of the report:
Is a list grouped by clientId with a sub report getting the clientId from the parent one as the parameter. Event with the insert page break after list true or false the result is the same while printing.
Thx you very much
Daniel
Printing Issue
Apr 24, 2008I have created a blank report in VS 2005. I set the pagesize to 21cm x 29,7cm (A4) and margins to 1cm. Body size is 19cm x 27,7cm. I set the body border to 1pt. When I print this blank report I won't get printed as I expcted. The printed margins are very different from the margins which I set. Hos can I solve this problem?
View 1 Replies View RelatedImages Does Not Appear In Printing
Oct 24, 2007
Dear All,
Kindly I need to infrom you that i make report in reporting service 2005 and there is an image in this report that i retrieve it from database
im sure that the error not in retrieveing and not the sp because that in report preview the image appear but in printing not appear
i put the some image propertise like:
mimetype:image/bmp and sizing :FitProportional
the second point :
i need to ask if can i make the report when printing can make it as default that appear in A4 not letter
I need Help as soon as possible
With my best regard
khalil hamad
Printing From Web Application
Apr 10, 2007Hi,
We are displaying the reports in Web Application using Report Viewer control.When we run the report and want to take printout we are clicking on Print button of Report Viewer then it is giving error "Unable to Load Print control" Install some activex control.
With out this error how can we print the report. How to overcome this waring.
Thanks in advance.
Printing Problem
Nov 12, 2007Hi All,
We have created reports with page size width : 11in and height : 8.5in so that we get pages printed in the landscape mode. We use HP LaserJet 3500 and reports were printing correctly in landscape format.
Everything was working fine till we introduced a new printer Dell 1110 laser printer to the environment.
When we have our Dell 1110 laser printers set as default, the page setup IS NOT set to landscape and when I manually change it to landscape, it prints in a compressed portrait image rather than landscape.
However when the HP LaserJet 3500 is set as the default, it prints correctly in landscape.
As the client is using Dell 1110 laser printers i need to fix this issue immediately.
Can someone guide me in resolving this issue..
Thanks!
PRINTING REPORTS
Jun 21, 2007Is there a way to save print settings with the report so that settings such as the size of paper (A4, legal...) and layout (landscape, portrait) do not have to be specified by user everytime she wishes to print the report?
Footer Not Printing
Oct 1, 2007
Hi everyone,
For some odd reason the footer of my report never gets printed. The footer contains the page number and report name and is very important to my report. I made sure the margins are 1 inches for all sides, made sure Footers printing in first and last pages are checked in the properties section, and gave it a large amount of space around the textbox. Is there anything I am doing wrong? Also, the header and body prints correctly.
Thanks
Printing Reports
Feb 6, 2007Hi
Iam able to print only the first page in the local reports!!!
Also, can I give the user the choice of using the local version or the enterprise version of the reports?
Any suggestions plz help
Thanks
contractor