Search results for query: *

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

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.

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

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

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

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

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

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

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.

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

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

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)) + '/' +...

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

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

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

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.

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

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?

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

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