SalesSponsored by Jamf Now

154

Solutions

344

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Share tech news, updates, or what's on your mind.

Sign up to Post

I want to get a list of sales orders that are 7 years old so I wrote the following query:

SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  DATEDIFF(YYYY, OrderDate, GETDATE()) = 7                            

I am concerned about the effect the  DATEDIFF expression in the WHERE clause will have on the execution plan that is decided upon by the optimizer because I know that one should not   have an expression on the lhs , so I changed it for this query and I gave me exactly the same execution plan:

DECLARE @compdate INT = 7
SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  @compdate = DATEDIFF(YYYY, OrderDate, GETDATE())  

Is there a better way of doing it ?
0
Cloud Class® Course: CompTIA Cloud+
LVL 12
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Using ClickFunnels.com for a Go Fund Me type of funnel

Has anyone used ClickFunnels.com for a funding operation, such as used by Go Fund Me types of programs?

I am wondering if they support this and what kinds of differences there are with normal click funnels.

Thanks
0
I need to subscribe to office365 to access email, office suite online/offline and onedrive for 3 users. I see 10 - 15 month per user, but seems the sales person keeps trying to sale me implementation, deployment and other services. can anybody help me? this is for business and may expend to 9 users in future.
0
Hi、

I would like to use online "Map" service like Google Earth, Google Map, and etc. in order to display about 1000 customer locations on the map.
It is for the internal use, so I do not want to share the data on public, so that our sales staffs can use the tool for analyzing the route or location to set their sales strategies.

Could you share with me how to accomplish it and what are the actual steps?


Thank you,
AW
0
Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.
0
I have a query where I am trying to get one line for each sales agent for a particular month, with total sales for that agent for that month. I can't get the syntax. I have tried everthing I know of and it's probably very simple. the date field is called paid date. Can anyone help me?
I only have three columns in my query, 1. Agent, 2. Sum of Price and 3.  Paid date. The Agent is group by,  the Sum of Price field  is summed and the Paid Date  field is group by
0
Does anyone have a Proposal template that they are willing to share?

I have a client who I am quoting for Windows Server 2016, VMs, Outsourced Exchange etc. The last time I did a complete setup and proposal was SBS2003. Just wondering if anyone might have something that I can use as a start to work from.

Thanks
0
Hello,

Are cloud phones better than an on premise solution?
We currently have a Siemens 4K phone system used with a PRI.
We have about 230 voice over IP phones and about 15 digital line phones.
Most of the ip phones have a basic setup with add on module to configure additional lines.

The 15 digital lines are for our sales department, the have a ACD routing setup(similar to a hunt group). Each sales person has their prime line and 2 secondary lines. We have it configured so that that each sales person is able to answered each others lines. Each sales person has about 50 lines configured on two phones at their desk that they can answer when any line rings. We it setup this way because our president wants sales to try and answer all calls and not have them go to voicemail.

We recently started to look at cloud phones and providers like ring central, 101voice and others. Our main concern is QOS and if our setup in sales will be supported.

We are not sure if cloud phones will be more reliable and if we will have the same quality of service?

Thank You


Let me know if you need any clarification.
0
3 LinkedIn Tools
The LinkedIn platform has been widely used by brands to communicate with the audience and improve their customer service. Similarly, the network has to do it right. Here are 3 tools that make LinkedIn so good.
0
So, I've done some AMAZING research and found...some VERY out-of-the-way places.  I'm thinking of building a Google map.

But, seems like then anyone could take the same data and recreate it.

Don't want to debate the merits of information be free.

Need suggestions about to monetize the work that I've done.  Sharing it puts it out there.  I can see that.  But...what can I consider to do with the page that holds the information?  Or, even the map itself? Should I even MAKE a map?  How can I use what I've got?  One suggestion I can see is...if my page is popular enough, put the map in there and let people who would copy it...go ahead.  A more popular page will always win the day.

Thanks!

OT
0
Free Tool: Port Scanner
LVL 12
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I want to attract sales people to sell my affiliate product, but I don't want to go beyond the limit of a few hours a week of managing the website.

So, I posted my offer on Freelancer and one person applied to the position, and then suddenly the job offer was taken down from Freelancer. (I am not sure why).

The job offer was a good offer, it said that sales person would earn 80% of the commissions. That's a good offer for someone to earn from the website. But the statistics
reveal that only that one person applied for the position.

If I have to spend many hours soliciting the job offer in order to get a sales person, then instead, I should close the website(s) because there is no time to deal with that.

Can anyone tell me where I can find such a sales person who will work in that scenario so as to expedite the sales of the website? (but without exceeding three hours a week
of management).
0
I have plotted sales revenue graphs on all the items under a certain brand.

From the graphs that I have plotted, can you help me identify any patterns or trends in the sales of each of the items under the brand? :)

Charts.xlsx
0
I am trying to write a query in oracle for sales vs received per day of the same item.

Basically I have two identical tables with the exception of one column - one tables shows sales per day, the other shows received per day.

I need to write a report showing the sales AND received per day on the same line, even if one or the other is zero.

How do I write this particular query?
0
I have a table (tMain) of sales... one entry for each sale.  In this table is the model (FrameModel) and an office (Office, currently just testing for all offices in the table.)  I would like to run a query that will pull the max similar model sold and display their count and also find their percentage (based on the total number of FrameModels sold) .  I am using the following query to try to pull this and a date range based on a form for the user,  (Basically trying to find models that have sold over 1 to find out "top model" sellers.

Its returning results but  I know for sure that there are other fame models not even showing up that have many sales (over 10)

SELECT tMain.DOS, tMain.FrameModel, Count(tMain.FrameModel) AS CountOfFrameModel, tMain.FrameLine, tMain.Office
FROM tMain
GROUP BY tMain.DOS, tMain.FrameModel, tMain.FrameLine, tMain.Office
HAVING (((tMain.DOS) Between [Forms]![FReportSelect]![DateStart] And [Forms]![FReportSelect]![DateEnd]) AND ((Count(tMain.FrameModel))>1))
ORDER BY Count(tMain.FrameModel) DESC;

Thank you.
0
Hi,
I am building an integration for Microsoft Dynamics 365 especially for Sales product in it.
The plan is the following -
Any user within a company who is using Microsoft dynamics 365  can install my application. My application i have registered on Azure portal.
After doing OAuth for a particular user i intend to send him data for example the number of leads created in last month etc..
For this i will use the dynamics 365 Web APIs.
My question is will any organization be able to use it ?
Does any application registered through microsoft Azure portal allowed to do OAuth for any dynamics 365.
And will Microsoft dynamics 365 CRM allow to use the web APIS to access its data.

As i see that there are many versions of Microsoft Dynamics 365.
I have doubt regarding this.
I have also heard about developer service account.. Where does that fit into here.. If i have to build such an application.
Thanks
0
Hi there,

I am looking for a partner portal which enables my company to organize and streamline questions and requests from partners. Moreover, things like static technical sales and technical information, ticketingsystem, partner status (level & training), onboarding process are very welcome. My company is active in the contact center industry where it sells its contact center solution through partners.

Any advice will be appreciated!

Kind regards,

Joep Vreeswijk
0
Dear Experts

Our organisation has decided to implement ERP -   our management is convinced with SAP to be chosen however not yet finalized, our objective is to have one unified solution across the organisation at present we are using sales force.com for marketing and sales function,
1. would like to understand does SAP has capability for sales force automation and does it support the integrations like CTI, web, face book, mainly does it allow web API integrations
2, if not SAP please suggest other ERP product which can handle sales force automation and other process, we are in real estate vertical (we do not construct we only sell the flats).
3. what all the measures to be taken to implement ERP,  is CIO needed as the technology is one part, do we require Consultant who has implemented in our vertical and project manager who leads the implementation,
4. please help me with the list for the need of technology and IT head role in detail for this project similary consultants and Project Manager and what are various types of roles to be put in place to choose and start ERP implemtetion who can drive and implement successfully.
5. Please let me know the approach or methodology for implementing the  ERP what top management should do and what all the roles to be created to implement the ERP, thanks
0
Has anyone managed to tap into 365 Client Management tenant details including subscription renewals with PowerBi. I dont want to give my sales team full delegated access to 365 to review subscriptions.
0
How do i use macro to auto update my formulas and cell references? I have a pivot table containing sales data, with the columns stating months from January to March. But for every start of the month, i need to update the latest month (i.e. update to April when it's May) to show to a new column. I cant use getpivotdata because i need to track the cell reference, and the data will change for each month so i cant pre-count April's values. Beneath the pivot table, I have a normal table stating sales data total [i.e =sum(Jan-Mar)] which i have to manually update. Is there any way for macro to automate the normal table to update =sum(Jan-Mar) to Jan-Apr? Example like =sum(b1:d1) to =sum(b1:e1) and for subsequent months?
Book1.xlsx
0
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Getting started with EventBrite

I am new to the web seminar business and need to rely on proven platforms for max guidance, so I cam spend my time prepping my seminar.

Has anyone used EventBrite for ticket sales?

Promotion?

Organizing event schedules and attendee lists?

 would be happy to hear from you and perhaps with some guidance about the steps I need to take.

Thanks
0
The high PR profile creation sites are very helpful to improve your site ranking and traffic as well. These days when site ranking is very important factor for all websites therefore profile creation is another useful method to gaining ranking. Creating profiles on different high PR sites not only benefit for site ranking also it helps you to engage and communicate with sales leads. We all want better result and engagement on search engines therefore profile creation is must for better diversity. Also profile creations provide you dofollow backlinks that would be 100% helpful for your site ranking.


Here is Top 100+ High PR Dofollow Profile Creation Sites List 2018 - https://www.snkcreation.com/high-pr-profile-creation-sites-list

0
Hi, I am using Access 2010. I want to learn advance and complex queries writing to manipulate data in tables, in VBA, which can perform on some events of form / report. I am familiar with query builder and basic queries.
Now I have an assignment to prepare a periodic summary for stock inventory, filtered by date and/or stock item. View, in datasheet on form / report, format as follows:
Filters applied: Date Range, Stock Group
Columns: StockItem, PackSize, PreviousQty, PreviousAvgRate, PreviousStockAmount, PurchaseQty During Date Rate, AvgRate of Buying During Date Rate, PurchaseAmount in Date Range, SalesQty During Date Range, AvgRate of Sales During Date Range, SalesAmount During Date Range, Qty of Balance Stock, AvgRate of Balance Stock, Amount of Balance Stock. AvgGain (AvgRateSale)-((PreviousStockAmount+PurchaseAmount in Date Range)/(PreviousQty+PurchaseQty)

Tables & Columns: (Interlinked columns only mentioned here)
tblStockItem: StockId, StockGroup, StockLabel, PreviousQty, PreviousBuyingAvgRate
tblStockPackSize: PackSizeId, StockId, PackSizeLabel
tblPurchase: PurchaseId, StockId, PackSizeId, Qty, Rate, Amount
tblSales: SalesId, StockId, PackSizeId, Qty, Rate, Amount

I am looking for expert guidance to write queries and how to set its recordset to any object to display data, in Access VBA. I will be thankful for your help.
0
Employee Tracking - GPS - I want app to web solution for tracking my sales employee and location with form to be filed when they reach that location.
0
I have a client with an office365 account with a single e-mail address 'user@hisdomain.com'.  This user does outside sales work for other companies that have their own e-mail systems and domain names, and they have created e-mail addresses for my client in their domains 'user@theirdomain1.com and user@theirdomain2.com'.
My client uses office365 OWA, Outlook and Outlook for Mobile to access email
We currently have forwarded 'user@theirdomain1.com to user@hisdomain.com'.  When my client receives an e-mail from 'user@theirdomain1.com' they want to be able to reply to the e-mail and change the 'from' address to 'user@theirdomain1.com'
How can I set this up in office 365 so they are able to change the 'from' address to the proper Domain for the reply to keep e-mail continuity?
Thank you
0
Hi,

We are working with a marketing strategy  for assisting surveying certain areas.  The front end is a screen with a series of questions which will later be analyzed.  Our concern to EE  is how can we protect or make sure that visitors are not repeating the questionair.   Also, detect if same ip or if the visitors somehow hiding their ip.  We are trying to assure the visitors is one visit per actual visit to the pages, no repeats.

Please advice.
0

SalesSponsored by Jamf Now

154

Solutions

344

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.