Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by edmana

  1. edmana

    Help with dynamically creating columns from rows in another table

    Olaf, I got this to work as a stored procedure. How do I get this into a table in SQL as I need to bring into a view to link to other data? I tried a bunch of stuff and am stuck I am using a version of SQL >= 2012 Thanks! Ed
  2. edmana

    Help with dynamically creating columns from rows in another table

    There is no report. I need this for import into another application. I need a query that will dynamically give me: All contact columns in the contact table and a column for each row that makes up the groups table with a 1 or a 0 whether it is in the group or not.
  3. edmana

    Help with dynamically creating columns from rows in another table

    Hey everyone, I have two tables: Contacts Number Name Address ... Groups ContactID Group Name I need to create a query that outputs a single list of all info for contacts and a column for each group which can change over time (Group names and whether a contact is in the group) Here is what...
  4. edmana

    Bar Chart w/ Date X Axis and Time Y Axis

    Greetings, I am stuck on this one. I have a table: Date Hour Attribute Value 1/1/2016 1 A 0 1/1/2016 1 B 1 1/2/2016 0 C 1 1/3/2016 23 A 1 ... I need to produce a chart that shows dates on the Y axis...
  5. edmana

    IPO500V2. Can't get into Basic Mode

    Greetings, I have an IPO 500 V2 out of the box that appeared to be on 9.0.x. I upgraded firmware to 9.1.1. The firmware loaded fine and shows as 9.1.1. I go into the IPO for the initial config using Manager and it prompts me for the type. I select Basic and when the config opens, I get a bunch...
  6. edmana

    Trouble sorting a Group By in a query

    Yes, and time. Sorry for wasting your time Skip.
  7. edmana

    Trouble sorting a Group By in a query

    Actually, I figured it out. This query was part of a larger stored procedure and the dataset returned came from a different place. I moved the above ORDER BY I created above and all is good. Sorry for wasting the electrons on this post. Ed
  8. edmana

    Trouble sorting a Group By in a query

    SELECT Sum(ColumnValue) AS SOCount, ColumnPK INTO #TT1010 FROM (SELECT SUBSTRING(DATENAME(mm, DT.dtime), 0, 4) AS ColumnLabel, Data.ColumnValue, CASE WHEN datepart(mm, DT.dtime) < 10 THEN '0' + CAST(datepart(mm, DT.dtime) AS VARCHAR(1)) + '/' + CAST(datepart(yy, DT.dtime) AS...
  9. edmana

    Trouble sorting a Group By in a query

    Skip, I can't get the data to sort with an order by after the group by. It doesn't change the sort order regardless of what I try to order by. Hence the reason I posted.
  10. edmana

    Trouble sorting a Group By in a query

    You are correct; that is not the result I ultimately want. I was using that to see if I could get the data returned to change the sort order from what I was seeing. The returned rows did not change sort order. I want it sorted by ColumnPK by year and then by month. Since ColumnPK is returned...
  11. edmana

    Trouble sorting a Group By in a query

    Skip, I see your point. However, I tried to ORDER BY ColumnLabel which is a 3 letter string showing the month for testing of the ORDER BY after the GROUP BY and it didn't work either. Ed
  12. edmana

    Trouble sorting a Group By in a query

    Greetings, I have a query: SELECT Sum(ColumnValue) AS SOCount, ColumnPK INTO #TT1010 FROM (SELECT SUBSTRING(DATENAME(mm, DT.dtime), 0, 4) AS ColumnLabel, Data.ColumnValue, CASE WHEN datepart(mm, DT.dtime) < 10 THEN '0' + CAST(datepart(mm, DT.dtime) AS VARCHAR(1)) + '/' +...
  13. edmana

    SQL Join w/ Group By

    Frederico, That seems to work. Thanks so much! I was struggling where to put the left outer join. Ed
  14. edmana

    SQL Join w/ Group By

    I have a query: SELECT O.Range, COUNT(*) AS NumOfOpportunities, CAST (SUM(O.ExpectedAmount) AS MONEY) AS ExpectedAmount FROM ( SELECT CASE WHEN DATEDIFF(D, EstimatedCloseDate, GETDATE()) BETWEEN 0 AND 30 THEN '0-30 Days' WHEN DATEDIFF(D, EstimatedCloseDate, GETDATE()) BETWEEN 31 AND 60 THEN...
  15. edmana

    Avaya Partner Repair

    Group, Does anyone have a company they can recommend to have a Partner R6 and a 308 module repaired? I am also going to look for refurb but I figured since they are no longer made, getting the ones I have repaired for a client would be good too. Thanks! Ed
See more

Part and Inventory Search

Back
Top