Search results for query: *

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

...to fix to the following but no rows where returned: select Month(o.TradeDate) as TradeMonth, Year(o.TradeDate) as TradeYear, Count(*) as QtyNewCustomer from [Order] as o where not exists (select 1 from [Order] as s where s.CustomerId = o.CustomerId ) group by...

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

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

Thanks!

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

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

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

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

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

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

Thanks, it was resolved!

...with Thunderbird and it just returned wrong username or password. Then I wanted to telnet myself to test what happens. This is the information I get: * OK The Microsoft Exchange IMAP4 service is ready. ? LOGIN Administrator@domain.com myPassword ? BAD Command received in Invalid state Any...

Great - thanks!

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

Is it possible to control where the actual emails are stored?

Is it possible to control where the data files are stored?

I have a folder on my website I want to protect with Windows authentication. The problem I get is that the prompt is re-appearing - like the credentials are not correct. But when I look in the event viewer I see an audit success. I am using a local Windows user to authenticate. In IIS->On...

I was recently demoed prweb.com solution for entering a number of keywords and then be presented with twitter posts, rss feeds and other sources (do not remember now). I wonder if there is any good service for this, except prweb (maybe you have comments on that service as well). I basically...

Ok, thanks for the suggestion!