Friday, November 16, 2018
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: philcart
 About  Contact
Joined: 20 Jul 2004 04:09 PM
Last Login: 13 May 2013 01:56 PM
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
Signature: Thanks

Colt 45 - the original point and click interface ;)
Email: Unavailable to anonymous users.
MSN IM: Unavailable to anonymous users.
AIM: Unavailable to anonymous users.
Yahoo IM: Unavailable to anonymous users.
ICQ: Unavailable to anonymous users.
 Post Statistics
philcart has contributed to 345 out of 2,682 total posts (12.86% of total).
Most Recent Posts:
Re: Debugging SP 3/11/2009 2:42:27 PM   (Total replies: 0)
Follow through this walkthrough provided on MSDN [url][/url]

Re: sort by finacial year 1/5/2009 7:33:08 AM   (Total replies: 1)
Firstly, I don't see why you need to do the "tricky" stuff to sort by the month. ORDER BY DATEPART(yy, [ReportMonth]), DATEPART(mm, [ReportMonth]) will sort by year and month. For your financial year sorting, I'd suggest setting up a calendar table. Do a quick Google on "sql calendar table" and you'll find a number of examples.

Re: Upgrade 2005 Standard to Enterprise 11/25/2008 7:55:09 AM   (Total replies: 0)
I'm betting that you're Enterprise install is RTM or SP1. You'll need to get hold of an SP2 install, or uninstall SP's from your Standard edition. Myself, I'd just go for the reinstall. As long as you capture all the logins, jobs, etc... it should be pretty painless.

Re: Local OS Administration Rights for DBA 11/17/2008 9:02:40 AM   (Total replies: 0)
Working in a consulting company with clients in many varied industries. We generally have local admin rights on server, and in some environments we have domain privileges as well. There is only one client were we don't have local admin rights. For that client, we generally have to work through a client contact who then passes the request through to network/admin people as appropriate.

Re: Log Shipping broken 7/10/2008 4:48:52 PM   (Total replies: 0)
Steve Are you using SQL Servers inbuilt log shipping? Looking at your requirements, a custom script solution might have more flexibility for you. We generally use a set of scripts and matching jobs for each part of the process 1) backup locally 2) transfer to standby 3) restore files On the restore side your script can determine if the next file in the folder is a database or log backup and perform the appropriate restore. For the upgrade process, disable log shipping backup ...

Re: Script to split 1 col to 2 4/17/2008 11:42:38 AM   (Total replies: 0)
Something like, create table #tbl (col1 varchar(10)) insert into #tbl select '12345A' union all select '1234' union all select '1356B' union all select '156789' union all select '145767A' select col1 , case when patindex('%[A-Z]%',col1) > 0 then left(col1, patindex('%[A-Z]%',col1)-1) else null end as col2 , case when patindex('%[A-Z]%',col1) > 0 then right(col1, len(col1)-(patindex('%[A-Z]%',col1)-1)) else null end as col3 from #tbl drop table #tbl

Re: Powerpoint Slides for Memory Management Tuning by Greg Linwood 3/28/2008 10:44:05 AM   (Total replies: 1)
They are available at, [url][/url]

Re: Exporting to PDF produces Invalid Argument Exception 7/16/2007 8:59:44 AM   (Total replies: 1)
Daniel Don't you just love the real helpful .Net exceptions :) Buried in all that, the second "ERROR" line says that there is a problem with chart1. Are you dynamically changing the chart in anyway, or have formulas for any of the settings?

Re: Exporting to PDF produces Invalid Argument Exception 7/16/2007 2:40:19 PM   (Total replies: 0)
In that case I'd check the resultset and see if there are any invalid dates.

Re: Exporting to PDF produces Invalid Argument Exception 7/17/2007 10:33:44 AM   (Total replies: 2)
Ahhh ... yeh ... I'm not aware of any specific limitations, but I think 543 charts would be up there :) Who is honestly going to look at 543 charts in one report?

Search for more...