Leads By Rating Breakdown
May 5, 2007
i currently work with a microsoft crm which works over an sql database. however i need to pull out some reports but i am having a hard time.
Sales Person Leadname adress rating
------------ -------- ----- ------
john doe mary doe 12 1st street hot
jane doe example 21 mary st cool
how do i pull out the total of hot or cold ratings per sales person and present all the information on one table.
Please help
Melvin Felicien
IT Manager
DCG Properties Limited
View 6 Replies
ADVERTISEMENT
Jul 20, 2005
this is probably a simple sql solution, but i could use some help.i've got one table that has rows of documents, and another table withany number of ratings for each of the documents. The rating table islinked with an id column. the issue i am running up against isreturning a single average rating for a document.SELECT document.title, (SELECT AVG(scale)FROM Rating, documentWHEREdocument.pkDocumentId = rating.documentId)FROM Documentreturns the same avg for all the ratings.So i'd ideally like to return the values of the document columns(tableA.*), with an additional column containing the average rating ofthat document (avg(tableB.Scale) where pkDocumentId = documentId).thanks in advance.
View 1 Replies
View Related
Sep 2, 2006
I am trying to build a voting system. Website visitors will rate a pictures from 0-10.
This value should update the amount of points already stored is SQL.
I think the way to do it is passing the value of a field to a varible, performing the operation and updating the database, but I don't know how to capture a value in Sql and pass it to variable...
Does anybody there could post a piece of code or point to a link where I could find this information?
thanks
View 8 Replies
View Related
Dec 22, 2005
Let's say you a 1000 records in the Employees table, who are spread over 40 different cities.
How would you get a breakdown of how many employees in each city ?
Do I have to loop with a Count(*) for each CityID, or something ?
There must be a more straightforward method.
View 1 Replies
View Related
May 12, 2008
I need to send a report in excel format that will breakdown the report by managers per sheet. I have a table that contains the following:
Manager OfficeName Note
Cindy Exxon Text here
Cindy Chevron Text here
John BP Text
I found this sample on another site but I'm do not want to follow the fetch syntax...
SET @SQL = @SQL + 'select OrderID,ShippedDate, Freight,ShipName from northwind..orders where EmployeeID=' + cast(@EmployeeID as varchar(10)) + '/ *<title>' + @Name + '</title><comments>Orders for ' + @Name + '</comments>*/;'
Thank you for any suggestions...
View 3 Replies
View Related
Sep 20, 2007
I'll give a basic example of my table.
OrderID, ProductID, Quantity
1,1,4
I would like to display the above row 4x (hence qty of 4)
1,1,"item 1"
1,1,"item 2"
1,1,"item 3"
1,1,"item 4"
Any suggestions? Thanks.
View 7 Replies
View Related
Apr 30, 2007
Can anyone please explain how this line of SQL will give me the first day of the week of the date passed in. With 7 being the parameter at the back end dateadd parameter that will return sunday as the first day of the week but I don't get the datediff portion.
Select dateadd(wk, datediff(wk, 6, '04/09/2007'), 7)
View 3 Replies
View Related
Oct 24, 2007
Hi all,
We are developing some reports in Reporting Services 2005 (deployed in Sharepoint). We are having a bit of a problem with the drill down functionality:
When drilling, the report page "jumps", repositioning itself so that the item I drilled is at the top of the page. Not what I wanted, I want it to expand the item without repositioning it.
So, any ideas on what my problem is? I am in kind of a hurry to fix this problem (as always ...).
Regards,
Daniel
View 7 Replies
View Related
Jan 10, 2007
Hi all. I have ran into a annoying situatin on sql cluster. Config is:
w2k3 EE x64 r2 - two nodes
sql 2005 x64 standart v2153
2instances, active-active cluster.
While changing tcp port configuration of one instance (using configuration manager) I have acidentaly created that setting:
- All IP dynamic port and All IP port was set to same number while separate IPs have enabled dynamic ports and does not have static port set.
This situation leads to unability of starting the instance anymore. There is no need wide explanation, its quite clear - while starting instace, it was configured with static port and with dynamic port with the same number, so port conflict error takes place. Problem was how to escape from this situation. On non clustered sql is quite easy, because these settings are stored in registry and also can be changed thorough Configuration manager, easy solution. Nor on the cluster.. Modifying the registry even on both nodes was unefective, every try to start instance fails with port conflict error and bad config was saved to registry again. I wasnt able to find where this config resides and change it to corect values. I have revealed only that it is not stored in instance master DB (restoring it from backup). Looks like its held somehow by cluster service itself, but I didnt find where it should be and how to edit it. So the last possible option take place (time was against me) - reinstalation of whole clustered instance. Nice example of how one click can create you a 2 days of work... Iam still interested if there is a smooth and easy way out of this situatin:-) So if anyone knows..... If there is not, I realy warn everybody.
DAvid
View 1 Replies
View Related
Nov 8, 2007
A report is picking up some values from the body and displaying them in text boxes within the Page Header, via the ReportItems collection. The text boxes within the body have their format specified as #,###; (#,###) - so displaying negative values within brackets. If the following value is set for the Page Header text box:
="My Value" & " " & ReportItems!variance.Value
the value displayed is, for example:
(My Value (1,123
Hence the requested trailing bracket has been swapped to become a leading bracket. Whatever I've tried I cannot get the bracket in the correct place. Am I missing something obvious or is this a bug?
View 3 Replies
View Related
Oct 12, 2015
I've question about how to handle structural datamodel changes in a datasource of PowerPivot. Suppose I'm developing a starmodel in SQL Server and sometimes a datatype changes or a name of a field changes in a table. It seems to me that PowerPivot handle this not gracefully as Analysis MD does (mostly). I received an error because of a wrong fieldname or even no error when a dattype changes in PowerPivot. Is this common or do I something wrong here. Does this mean that every time the datamodel changes the PowerPivot should be recreated? Or am I missing the clue here?
View 6 Replies
View Related
