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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chrisssyp82

    Sharepoint 2010 Survey - Create questions from a list

    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?
  2. chrisssyp82

    Sharepoint 2010 Survey - Create questions from a list

    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...
  3. chrisssyp82

    Sharepoint 2010 Survey - Create questions from a list

    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...
  4. chrisssyp82

    Merging together in Stored Proc

    ...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 =...
  5. chrisssyp82

    Merging together in Stored Proc

    ...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...
  6. chrisssyp82

    Merging together in Stored Proc

    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?
  7. chrisssyp82

    Merging together in Stored Proc

    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 ................. ?
  8. chrisssyp82

    Merging together in Stored Proc

    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...
  9. chrisssyp82

    Merging together in Stored Proc

    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...
  10. chrisssyp82

    Multi Part Identifier error

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

    Multi Part Identifier error

    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?
  12. chrisssyp82

    Multi Part Identifier error

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

    Multi Part Identifier error

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

    Stored Proc into SSRS

    Tanks for that mate, makes sense.
  15. chrisssyp82

    Stored Proc into SSRS

    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?
  16. chrisssyp82

    Stored Proc into SSRS

    ...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...
  17. chrisssyp82

    Stored Proc into SSRS

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

    Stored Proc into SSRS

    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?
  19. chrisssyp82

    Stored Proc into SSRS

    ...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...
  20. chrisssyp82

    Vlookup

    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...

Part and Inventory Search

Back
Top