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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Rows to Columns
You can use a CASE statement for this. In an example grouping by months, you could try something like... SELECT state, --GET JANUARY TOTAL CASE datepart(mm,DateField) when 1 then SUM(AmountField) ELSE 0 END JanuaryTotal, --GET...- MKP900
- Post #3
- Forum: Microsoft SQL Server: Reporting Services
-
Tarpit/IP Screen
Thanks for the tips jpm121. You were a big help!- MKP900
- Post #3
- Forum: - General Groupware/Mail server discussion
-
Tarpit/IP Screen
Hey folks. We are using MDaemon v.8.0.2. I have a user that regularly checks his email out of the office. He is now unable to check the account and is receiving a message that says the request to the server timed out. On the mail server I am seeing a lot of attempts to connect that are blocked...- MKP900
- Thread
- Replies: 2
- Forum: - General Groupware/Mail server discussion
