querysyntax889.blogspot.com
Query Syntax: query: child of child of child of...: Which are the descendants?
http://querysyntax889.blogspot.com/2012/03/query-child-of-child-of-child-of-which.html
Friday, March 30, 2012. Query: child of child of child of.: Which are the descendants? I have a table like this:. So this table contains parent-child relations, but they can go infinite. What I need is a select-query, that returns me for al the 'original'. Parents, their relatiosn with their cildren, grandchildren, and further. So with this records:. A D (because D is a child of B which is a child of A). A E (same reason). How can I do this? I need to use this select in a join. I have a solution. INSERT ...
querysyntax889.blogspot.com
Query Syntax: Query/Reporting Tool for SQL Server Tables
http://querysyntax889.blogspot.com/2012/03/queryreporting-tool-for-sql-server.html
Friday, March 30, 2012. Query/Reporting Tool for SQL Server Tables. Thanks.Allowing users direct access to tables is exactly the sort of thing good DBAs AVOID doing. Now, Now. Http:/ www.cognos.com/products/cognos8businessintelligence/reporting.html? Lid=/ Products/ Cognos8BI/ Reporting Brett - thanks for the product suggestion. That's the exact type of suggestion I'm looking for and welcome others. Well, I know when I've been snubbed. :(. And great thanks for suggesting another potential tool. Query: ch...
queryassistancefzw.blogspot.com
query assistance: query help
http://queryassistancefzw.blogspot.com/2012/03/query-help_5404.html
Friday, March 30, 2012. Here is a simplified example of what I need to accomplish. I have a table that keeps track of plastic balls in tubs. Based on a bit column the record is either defining balls added to a tub or taken away. When the record is defined as adding balls to a tub it will say how many and what color, but when the flag says they have been taken away from a tub I only know the number removed and not the color. I need a query that will give me the percentages of the different colors in the t...
querysyntax889.blogspot.com
Query Syntax: Query/Report for Owner of all SQL Jobs
http://querysyntax889.blogspot.com/2012/03/queryreport-for-owner-of-all-sql-jobs.html
Friday, March 30, 2012. Query/Report for Owner of all SQL Jobs. Is there a query/report that I can run against all our SQL servers to see who the 'owner' of each job is? If so, can this be run in SQL Server Enterprise Manager 8, SQL Server Management Studio or Hyena? Usual caveats re querying system tables (run at own risk etc):. SELECT J.name AS JobName. FROM msdb.dbo.sysjobs view J. Master.dbo.syslogins L. ON Jowner sid = L.sid. HTH Thank you very much! I'm just a newbie DBA admin :). Query Works in SQ...
querysyntax889.blogspot.com
Query Syntax: Query/View Question
http://querysyntax889.blogspot.com/2012/03/queryview-question.html
Friday, March 30, 2012. I am trying to create a view that returns data from three tables and can't seem to get it to return the data that I want. I am no SQL expert, so hopefully someone can give me some insight into what I need to do. The tables are basically set up like this:. Table 1 and Table 3 are each joined to Table 2 on their respective Primary/Foreign Key fields. I want the view to return all of the records from Table 1, even if there are no matching records in Table 2. HTH, Jens Suessmeyer,.
querysyntax889.blogspot.com
Query Syntax: Query/View: The 2 newest periods for each indicator
http://querysyntax889.blogspot.com/2012/03/queryview-2-newest-periods-for-each.html
Friday, March 30, 2012. Query/View: The 2 newest periods for each indicator. I'm working on a simple performance-program, where I need to extract. Information 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 latest. The Table (Table1) looks like this:. If I want to extract the newest I use something like this (made it in. Table1 as t WHERE t.kpiID=table1.kpiID);. FROM table1 W...
queryassistancefzw.blogspot.com
query assistance: query help
http://queryassistancefzw.blogspot.com/2012/03/query-help_3686.html
Friday, March 30, 2012. I have a name column that contains both first and last. Id like to split it into two columns, a first and. Anyone have any easy way to do this? Do you *always* have two words, separated by a space? Ie, what does your data look like? Tibor Karaszi, SQL Server MVP. Http:/ www.karaszi.com/sqlserver/default.asp. Http:/ www.solidqualitylearning.com/. Rob" anonymous@.discussions.microsoft.com wrote in message news:c07e01c47a31$4e2ec290$a601280a@.phx.gbl. The data looks like this:. THEN ...
querysyntax889.blogspot.com
Query Syntax: Query/Table Join
http://querysyntax889.blogspot.com/2012/03/querytable-join.html
Friday, March 30, 2012. I need to perform a query on two tables that look like this:. I can run this query just fine:. Select m.memberid from members m, attendance a where. Ameetingid = 47 and m.memberid = a.memberid. This gives me memberid's for members that are present. I need members that are not present. Select m.memberid from members m, attendance a where. Ameetingid = 47 and m.memberid a.memberid. This returns a thousand rows when it should return no more than 25. Originally posted by mycoolross.
queryassistancefzw.blogspot.com
query assistance: query help
http://queryassistancefzw.blogspot.com/2012/03/query-help_1659.html
Friday, March 30, 2012. I want to bring up the following data for groups:. Blue, Red, Green and Yellow. I have the following view in sql 7 which brings up the data i want, How can. I bring up the data for the other groups within the same query. Salesorders.srep, SUM(salesitems.sprice) AS Expr1,. FROM dbo.salesorders INNER JOIN. Dbosalesorders.son = dbo.salesitems.sona INNER JOIN. Dbosalesorders.son = dbo.delvitems.dord AND. Dbosalesitems.sonitem = dbo.delvitems.ditem INNER JOIN. 2008-02-01 00:00:00, 102).
querysyntax889.blogspot.com
Query Syntax: Query/test for db_owner role?
http://querysyntax889.blogspot.com/2012/03/querytest-for-dbowner-role_30.html
Friday, March 30, 2012. Query/test for db owner role? Is there a SQL query that can explicitly return the roles that the current. SQL user has been explicitly assigned? I'm trying to find out if the user. Has been given the db owner role (versus it being implied by the user being. What version of SQL server? Tibor Karaszi, SQL Server MVP. Http:/ www.karaszi.com/sqlserver/default.asp. Http:/ www.solidqualitylearning.com/. Blog: http:/ solidqualitylearning.com/blogs/tibor/. Would this work for you? Is ther...