Viewing 15 posts - 241 through 255 (of 1,079 total)
Are you trying to produce a measure of adding 2 periods? eg. 11 + 12,
or 201301+201302?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 8, 2013 at 11:41 pm
I'd consider kicking of an executable batch job from ssis.
ref: http://ask.metafilter.com/50369/How-to-move-files-into-subdirectories-in-batch-job
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 16, 2012 at 5:30 am
Any information in error log on the failure?
%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 15, 2012 at 11:31 pm
select criteria from yourtable where datecolumn < dateadd(dd, 30, '20110420')
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 15, 2012 at 2:10 am
Example:
select {[Measures].[Amount], [Measures].[Transaction Cost], [Measures].[Transaction Number]} ON COLUMNS,
{ ManualProcessing].[All ManualProcessings].[MANUAL]} ON ROWS
FROM [Transactions]
where
(
except([Product].[All Products].Children,{[Product].[All Products].[Debit}),
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 6, 2012 at 2:48 am
rhythmk (9/6/2012)
Henrico Bekker (9/6/2012)
Define DB Testing Team?Sql database Testing team consisting 4-5 people.
yes, but define "Database Testing" what testing will be done/required? or are you 4-5 developers? Or SQL DBA's?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 6, 2012 at 1:45 am
Define DB Testing Team?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 6, 2012 at 12:26 am
First, more info on your error: http://msdn.microsoft.com/en-us/library/aa337272(v=sql.90).aspx
Possible Fix: http://support.microsoft.com/kb/934396
SQL Backup Simulator for testing http://archive.msdn.microsoft.com/sqlbackupsim
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 6, 2012 at 12:25 am
If all the resources required for the SQL Services are in a group and dependencies have been configured correctly, the yes, move the group and all relevant resources will failover.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 19, 2012 at 6:04 am
"Invalid connection string attribute."
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 17, 2012 at 11:46 pm
Koen Verbeeck (7/12/2012)
But apparently some people still get it wrong.
Or maybe they just sneezed while picking the answer and thus accidentily clicking the wrong...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 12, 2012 at 12:33 am
Error message?
something like...."SQL Server blocked access to procedure 'sys.xp_cmdshell'" ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 11, 2012 at 12:43 am
Hi Gopi
This is a SQL Server Forum, and I doubt anyone here would be able to help you.
Best if you seek a COGNOS specific forum and raise your question...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 10, 2012 at 6:36 am
Use the ":" function
http://msdn.microsoft.com/en-us/library/ms146001.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 10, 2012 at 1:43 am
Don't see how a one answer question has 2 answers. Should be 10.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
July 4, 2012 at 11:48 pm
Viewing 15 posts - 241 through 255 (of 1,079 total)