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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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
  16. edmana

    IPO and VMPro not communicating

    Got it. Thanks everybody for help on this. The reseat has worked for now. It's our internal system so I may just order replacement cards.
  17. edmana

    IPO and VMPro not communicating

    tlpeter, Was there a fix issued for this? Also, if no VCMs are in use, does the IPO just start allocating at the beginning again? Thanks! Ed
  18. edmana

    IPO and VMPro not communicating

    Ok, so I removed one card, tried it, removed the other, inserted the first one, tried it, and both work individually....Perhaps just a re-seat?
  19. edmana

    IPO and VMPro not communicating

    At the start of monitor, I get: 9564631mS PRN: Monitor Started IP=192.168.88.113 IP 500 8.0(43) TODI-IPO-01 (IP Office: Supports Unicode, System Locale is default) 9564631mS PRN: LAW=U PRI=0, BRI=0, ALOG=4, ADSL=0 VCOMP=128, MDM=0, WAN=0, MODU=0 LANM=0 CkSRC=0...
  20. edmana

    IPO and VMPro not communicating

    I get this showing up when I dial *17: 7708736mS CMMap: a=6.1 b=0.0 Mapper::AllocateCodec allocated CMRTVocoder resource busy 1, total 128 I also get (later in the trace): 7708750mS CMMap: PCG::MapBChan pcp[267]b0r1 cp_b 0 other_cp_b 0 type CGTypeSimple 7708750mS CMMap: PCGS...

Part and Inventory Search

Back
Top