Search results for query: *

I'm thinking now a workflow from a list maybe the only route. Is it possible to create a workflow similar to the "Collect Feedback" workflow, but caputure feedback from multiple users?

There is about 300 reports and we're trying to determine which ones are in use and which ones are not. I think doing a survey for each report would for one take a lot of time and two wouldn't be very user friendly. It may turn out that sharepoint may not be the answer to this issue, but i'm...

I have a list of reports in our business and what i want to do is send out a survey to every user asking them a set of questions per report. For each report we want to ask the following questions: Do you use the report? Y/N How often do you use it? Daily/Weekly/Monthly/Quarterly/Annually Is...

...TransactionType = 'BBA' OR (ProceedsLocal = 0 AND RecordType = 'T') -- Do not show transactions with no proceeds ;;with needed as ( select * from #Workbook w WHERE w.CashAccountType = 'CCY' AND w.CashAccountSubType = 'SET' AND w.TransactionType In ('Opening','Closing') AND w.CcySettle =...

...From #Workbook Where TransactionType Not In ('Opening','Closing') select * from #Workbook ORDER By ID, PortfolioID, CashAccountType, CashAccountSubType, CcySettle, DateItem, Sequence drop table #Workbook and as i said above i want to merge the opening and closing balances and include...

Unfortunately this seem to make no difference. I still have the same table as i started with. Would not only want to merge the records where certain fields met a certain criteria?

I'm guessing the code would start something like this: IF(SELECT Count(distinct w.AcctID) FROM #Workbook w WHERE w.AcctType = 'CCY' AND w.AcctSubType = 'SET' AND w.Curr = w.Curr) > 1 BEGIN ................. ?

Basically in an ideal world you have one capital account per currency, but as we all know this isn't an ideal world and on occassions we have two capital accounts per currency. So basically as a step in my stored proc i want to be able to check for more than one capital account, and if there is...

SQL Server 2008 Hi I have an issue where i have two of the same accounts which i would like to merge together, the list looks like below: AcctID AcctType AcctSubType Curr TransType Amount 1 CCY SET EUR Opening 1000 1 CCY SET EUR BUY...

Cool i understand what you're saying now. Thanks for your response, was very helpful.

thanks for the response, however i'm confused as to why you have added this piece of code: WHERE Rt.Pk IS NULL What is rt.pk?

I've tried that and i still get the same error message.

..., [Date] DATETIME , [All in Market Value Base] FLOAT , [All in Market Value Converted] FLOAT , [Portfolio Base Ccy] CHAR(3) ) /*------------------------------------------------------------------------------------------------------ Set default values...

Tanks for that mate, makes sense.

Right sorry, i've got the list now in my list of fields in SSRS from the select i've added above. So how can i get this to link to my @Worktable table?

...IF 1=2 SELECT '' as Stringfield1, '' as Datefield1, 0 as ValueField1, '' as Stringfield2 I added this like this: AS BEGIN SET NOCOUNT ON /*------------------------------------------------------------------------------------------------------ Declare variables and worktable...

Do you think i need to restructure the stored proc in any way for the fields to be shown in report builder?

I've tried all of the above and i still get only "Section" under field names. It doesn't make any sense to me, surely i should be getting all the columns from @Worktable in my list of fields?

...a load of Crystal Reports over into SSRS. All of the reports are based upon SQL stored proc's. I have this stored proc USE [InfoPortal] GO /****** Object: StoredProcedure [dbo].[usp_Report_MonthEnd_NAV] Script Date: 02/06/2012 16:50:43 ******/ SET ANSI_NULLS ON GO SET...

Excel 2010 I've got a list of reports which give the report number, report description and the stored proc which goes with it. example below: RPT_NUM RPT_NME SP_NME 1 Report1 SP1 2 Report2 SP2 3 Report3 SP3 4 Report4 SP1 5 Report5...