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 strongm 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 serializer

  1. serializer

    Retrieve new customers per month

    Thanks, that worked! Here is the query I ended up with using: select Month(o.TradeDate) as TradeMonth, Year(o.TradeDate) as TradeYear, Count(*) as QtyNewCustomer from [Order] as o where paid = 1 and not exists (select 1 from [Order] as s where s.CustomerId =...
  2. serializer

    Retrieve new customers per month

    Thanks, but unfortunately that did not work. I got different errors. Missing group by. Also, the table name is [order] and not [orders]. The column orderid does not exist. I tried to fix to the following but no rows where returned: select Month(o.TradeDate) as TradeMonth...
  3. serializer

    Retrieve new customers per month

    I have an order table with customer id and tradedate. I would like to get statistics about number of new customers for each month. I defined a new customer by an order row with a customerid I have not counted before. I am not sure if this is possible through SQL only. Here is my sample query...
  4. serializer

    Email is moved to Junk folder - which component is moving it and how do I exclude an email?

    What does this output mean, that junk-filter is not enabled: [PS] C:\Windows\system32>get-mailbox webmaster | fl *junk* SCLJunkThreshold : SCLJunkEnabled :
  5. serializer

    Disable password expiration

    Thanks!
  6. serializer

    Disable password expiration

    How can I disable password expiration for one or more users?
  7. serializer

    Email is moved to Junk folder - which component is moving it and how do I exclude an email?

    Hi, an important email is moved to the Junk folder of a mailbox. I do have black listing enabled but I do not think it is that component that moves a specific mail to the Junk folder. 1. what process is moving it? 2. how can I exclude a specific sender? Thanks
  8. serializer

    IIS 7 with Windows authentication fail

    Thanks, sorry for the late reply. I turned off anonymous and it started working.
  9. serializer

    Add new domain?

    Thanks, I found out this link which explains how: http://technet.microsoft.com/en-us/library/cc772007.aspx
  10. serializer

    Store emails on another drive than application?

    Thanks! Please let me know if you can help me with my basic question about adding new domain as well? :(
  11. serializer

    Add new domain?

    I am new to Exchange 2013. I first created a default domain xxx.com. Then I wanted to add a second domain yyy.com. Here is what I did: Mail flow->Accepted domains->Add Mail flow->Email address policies->Added second domain Still, when I try to add a user I only have one domain I can...
  12. serializer

    Getting IMAP working

    Thanks, it was resolved!
  13. serializer

    Getting IMAP working

    I thought I did everything to get IMAP work working but apparently it is not enough. What I have done is to set services to auto start. I am able to telnet to port 143 on that server and it answers ok. I have verified that IMAP is enabled on the user in the administration console. The problem...
  14. serializer

    Installing application on one drive but keep databases on other?

    Great - thanks!
  15. serializer

    Installing application on one drive but keep databases on other?

    Thanks, do you know where to change the drive/folder?
See more

Part and Inventory Search

Back
Top