|
Re: Debugging SP
11/03/2009 2:42:27 PM
(Total replies: 0)
|
| Follow through this walkthrough provided on MSDN
[url]http://msdn.microsoft.com/en-us/library/yet1b7by.aspx[/url] |
|
|
|
Re: sort by finacial year
5/01/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
25/11/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
17/11/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
10/07/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
17/04/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: Exporting to PDF produces Invalid Argument Exception
20/03/2008 11:29:24 AM
(Total replies: 0)
|
| vidival
Firstly, I'm presuming you're talking about producing an 18 thousand page PDF file. Have you run this report and got an error, or are you just asking if it’s feasible? What is contained in the report that makes it so long? Are people honestly going to look at 18 thousand pages? Can the report be broken down into smaller chunks?
Secondly, it's good etiquette to start your own forum thread and not post a reply to a thread that is nearly 12 months old.
|
|
|
|
Re: Exporting to PDF produces Invalid Argument Exception
16/07/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?
|
|
|
|
|