Populate Indicator To Be Displayed By Using Timestamp
Jan 6, 2015
I have data as below, I want the indicator to be displayed by using timestamps
Id task_id tsk_complete_ts task_due_date Id_end_ts tsk_indicator id_indicator
50 2001 01-01-2015 02-01-2015 10-01-2015 GREEN
50 2002 03-01-2015 04-01-2015 10-01-2015 AMBER
50 2003 07-01-2015 06-01-2015 10-01-2015 RED
50 2004 NULL 09-01-2015 10-01-2015 GREEN
I need to calculate the indicator for the whole id considering all the tasks by using the below conditions,
1) if tsk_complete_ts > id_end_ts, display id_indicator as RED
2) if any task is in RED or AMBER and id got completed before id_end_ts, the display id_indicator as AMBER
3) Else GREEN
I want the id_indicator to be populate dynamically in view without using stored procedure, id_indicator should be common for whole id.
Task indicator also getting populated in the view using the case statement.
I am populating oracle source in Sql Server Destination. after few rows it fails it displays this error:
[OLE DB Destination [16]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Invalid date format".
I used this script component using the following code in between the adapters, However after 9,500 rows it failed again giving the same above error:
To convert Oracle timestamp to Sql Server timestamp
If Row.CALCULATEDETADATECUST_IsNull = False Then
If IsDate(DateSerial(Row.CALCULATEDETADATECUST.Year, Row.CALCULATEDETADATECUST.Month, Row.CALCULATEDETADATECUST.Day)) Then
dt = Row.CALCULATEDETADATECUST
Row.CALCULATEDETADATECUSTD = dt
End If
End If
I don't know if my code is right . Please inform, how i can achieve this.
I'm working on SQL Server 2005 & Reporting services to create a Projet model to deploy it on the server.
To explain me, i 'll recreate simply my problem on the the database "AdventureWorksDW".
I woudl like to see information on my product dimension.
In a matrix tab, i put "Product name" in row value and "customer name" on column.
I would naturally know the "Sales Amount" for my product by customers.
But, as i had not create aggregate, i can't put my numerique value on the cells indicators. It just allowed me to put the SUM(SALES_AMOUNT) by exemple, but it's not what i want.
Hi,I'm working on a simple performance-program, where I need to extractinformation from the 2 newest periods for every performance-indicator- And from there calculate a trend between these results.The problem is, that I can't find a simple way to extract the 2 latestresults.The Table (Table1) looks like this:kpiIDperiodIDActualAcceleration23Acceleration54Speed1100Speed4200Speed7220Speed9180Weight122Weight332Weight721Weight1033If I want to extract the newest I use something like this (made it inMS Access, so the syntax might differ slightly from SQLServer):SELECT table1.kpiID, table1.periodID, table1.ActualFROM table1 WHERE table1.periodID = (SELECT max(t.periodID) fromtable1 as t WHERE t.kpiID=table1.kpiID);BUT - how how do I get the second-newest period as well?Preferably I would like the final result to be a View with thefollowing fields:kpiID, periodID_newest, Actual_newest, periodID_sec_newest,Actual_sec_newestAlternatively a View with 2 posts for each performace-indicator.Thanks in advanceRyan
I hope you can help as I am really scratching my head on this one. I am pulling together an assessment of the Disaster Recovery readiness for an organisation I am working at. Part of the assessment I am doing is the recovery model of each of the databases.
I have scripts that are already pulling lots of data from 40+ servers and 500+ databases. However, I cannot seem to find anywhere within the MASTER or MSDB or the database itself where the Recovery Model flag is held. Obviously I can right click on the database and click properties and it is there, but I need to automate this task (as it will probably be a weekly assessment).
I have checked sysdatabases and almost every other table, but nothing obvious as to where this flag is.
I am in the process of training a Neural Networks, which could take significant iterations in the process of getting trained. While using other tools like I can visually see the convergence (in terms of error for the model). Is there a way to see any progress while training while using Analysis Server - Neural Network training? It would be useful to see the accuracy, interation number and timeout while in the process of training etc...
For starters, please feel free to move this if it is in the wrong forum.
The issue I have is this. I have been asked to delete all information from a table that was inserted before May 12 this year. The issue is that when the DB was created, whoever designedd it neglected to add a timestamp column for the user data table (the one I need to purge). Does SQL, by default, happen to store insert times? Would it be something that might hide ina log file somewhere?
I have just installed MS SQL in my computer and I am trying to run MS SQL and Visual studio for the first time. However I have run into a problem that I can't solve. Basically the problem is that the data I fetch from the database is not being displayed/bound to the ddl I have on the page.
I have used VS to configure the sqlDataAdapter, DataSet, sqlConnection, and the sqlCommands. Basically the data is being fetched from the Northwind sample database. From the preview option on the sqlDataAdapter I am able to preview the information from the database. So it seems to work. I have also configured the ddl settings so that the Categories table is the datasource. I have also set the ddl.DataTextField = "CategoryName"; ddl .DataValueField = "CategoryID";
When I compiled and run the page, no error messages are generated, but the ddl is still completely blank and I can't understand why.
We have a SQL Server 2005 database which holds all the companies scanned documents (in image fields). I have developed a report which allows the user to search for a contract and all relevant scanned documents are returned.
When I preview the report with Visual Studio Report Designer...SOME of the images are not displayed, I get the little red cross icon in the top left corner.
When viewed using Report Manager with a browser... The report displays ALL images... However, when I click on the print button and then the print preview button in Report Manager, some of the images do not appear (the same images that don't appear in the Report Designer preview.
Can anyone tell why I can see all the images through Report Manager and my Browser (IE7) but only some of the images when in Report Designer preview or Print Preview?
I have setup Merge replication with 2 publishers and one subscriber. On the subscription machine I can see publisher 1 listed under local subscriptions but not publisher 2. I have created the second subscription on publisher 2 and also tried to create the subscription again on the subscription machine but i get an error saying the 'Subscription already exists'.
Neither do I see the second subscription nor does it work as if it is subscribed to Publisher 2. What could be going wrong.
No se encuentra la secuencia. No se encuentra el identificador de secuencia proporcionado a una operación en la base de datos del servidor de informes. (rsStreamNotFound) Obtener ayuda en pantalla
This is the code
the problem is that I need to know the streamid, and to know the streamid I first have to render the report where the image is to be placed.
I have a stored procedure which uses a column of a table. Unfortunately, the table exists, but the column does not. Still when we create or alter it, it shows 'completed successfully'.
Also, when this script is executed on another server, it gives the respective error, correctly.
Is there any database option or setting which has been tampered or changed by mistake.
Your helpful suggestions are welcome. Thanks in advance.
I have the following query where I want to add more user friendly names to the column names that are selected in the query. For instance, I want to display the field Articlegroupname as Product Category. How do I do this ithout altering the underlying field name in the database?
LEFT JOIN HIP.dbo.POHeader ON POHeader.poHeaderId=POLines.poHeaderId LEFT JOIN HIP.dbo.Article ON Article.articleId=POLines.articleId LEFT JOIN HIP.dbo.articleGroup ON Article.articleGroupId=articleGroup.articlegroupid LEFT JOIN HIP.dbo.Articlegroup_2 ON Article.articleGROUPid2=Articlegroup_2.Articlegrou p_2_Id LEFT JOIN HIP.dbo.articleStock ON Article.articleId=articleStock.articleId LEFT JOIN HIP.dbo.Brands ON ARTICLE.BRANDID=BRANDS.BRANDID LEFT JOIN HIP.dbo.Location ON POHeader.locationID=location.locationID LEFT JOIN HIP.dbo.Sesong ON Article.sesongID=Sesong.SesongId LEFT JOIN HIP.dbo.Supplier ON Article.supplierID=supplier.supplierID
I am creating a report in Reporting Services 2000. I have a stored procedure that returns 4 columns with one column having 21 weeks of entries in it. I am using matrix to group these 21 weeks as 21 week columns created dynamically but when I preview the report it is only displaying columns for first 5 weeks.
Any idea why Reporting services is not displaying the rest of the columns? Any limitation on maxiumum number of columns that can be generated dynamically in SSRS 2000?
I have a Sales cube and I want to be able to display Products and the Price at which they were purchased in a given period. I have a Product dimension while Price is a measure in my Sales Fact Table. Is there a way to have a "Group By" aggregation instead of a Sum? This way, I can show Products grouped by their list price.
My Product Dimension consists of product_numbers (such as 100, 101, 102 etc...) My Sales Fact Table consists of sales data (such as product_key, price, net_sales, returns, etc...) at the transaction level.
where Net_sales and Returns are "summed" and Price is simply a "Group By". In other words, this report would show the net sales and returns by product for a given price.
I'd rather not use a Price dimension since we have hundreds of products at hundreds of different prices. Moreover, this data is already in the Sales Fact table.
Create PROCEDURE sp_child2 @inp int, @out int output AS SELECT @out = @inp * 10 GO
In the report screen i want the following:
A text box which will take the @inp(this will come automatically) When i click the "view report" the output value should be displayed in the textbox i have in the report.
But the problem i am facing is with the above sp is its creating two text boxes automatically asking for @inp and @out.If i dont give anything in @out text box and press the view report an error is thrown asing me to fill the output box.
Isnt it supposed to be a output value?Am i doing something wrong?
If i use ODBC to connect to my SQL server some text values are not displayed (I'm using nvarchar and ntext data types). But if I use OLEDB everything works fine.I'm creating a normal table in html. I display an image next to the text. If the text comes before the image it works but if it comes after it doesn't work when using ODBC. Does anyone have any idea on how to solve this problem without changing the html?
Thanks for your help.
J:C:
<body> <% Dim sqlstmt sqlstmt = "select top 3 * from News order by ID DESC" set rs = connection.execute(sqlstmt) %> <table border="0" cellpadding="0" cellspacing="0" bordercolor="#111111" width="100%" id="AutoNumber7"> <% do while not rs.eof %> <tr> <td width="100%" valign="top"> <div align="left"> <font face="Verdana" size="1"> <a href="news.asp"> <img border="1" src="<%=rs("imagem")%>" align="left" width="32" height="87"> </a>
I have a table which displays years (2007, 2006, 2005, etc.) as one of its fields. I need to have it display Year + " and prior" for the last row. Any thoughts on how I might do this? Thanks!
I have a Reporting Services report which must show photographs stored in a SQL Server database. The trouble is that the photos just don't display. The report just shows the little red cross icon.
When I use MS-Access forms and reports it works fine. But I need this to work with Reporting Services!
I had a set of working reports on a test server that we are moving to the production box. One of these reports has web based embedded images which are pulled from share point (2003).
DomainSSRSAcctName is the account for:
The application pool for the web site with eports and eportserver virtual directories. the SSRS and SQL service account The SSRS Unattended Execution account
This account has read access to the SPS 2003 document library. I have verified this by using the account in IE to browse to the folder.
When I view this report from the production server I get a broken image link and not the image. I don't see any errors in the eventlog or the SSRS logs.
HiI'm not sure if this is a .net or a SQL issue. My development machine is using SQL 2005 while the live server is SQL2000. I have a smallmoney field in the database for holding a house rent. The following is used to display the contents on the page<asp:Label ID="lblrent" runat="server" Text='<%# Bind("rent", "(0:0.00)") %>'></asp:Label>In development, the number is displayed correctly, with the decimal place, .e.g. 200.50 but on the live server the number is displayed as 20050,00. What I have noticed in the database is that the number is held differentlySQL 2005 - 200.5000SQL 2000 - 20050Is there a difference between SQL 2000 and 2005? How do I get around this problem?
I have a website that works OK on my local machine when I test it within Microsoft Visual Studio's debugging mode. However now that I have copied it over to a remote server it is failing with an error message of:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)As far as I'm aware I have never used SQL Server with my webpage. All connections to databases are to Oracle with connection strings and providers set up in the webconfig file. The website does however use a login control to recognise authorised users. Does this mean I've unknowingly been using SQL Server (to support the login control) and I therefore need to install this on the remote machine? Or is it something simpler? Wondered if anybody had seen this error message before?
