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!

  • Congratulations strongm 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. paulkeys

    Get Middle Initial from a Name field-SQL Server 2008

    Hi, How about this... create table #temp(Name varchar(50)) insert #temp(Name) values ('Smith,Jane Ron'),('Dow,John L'),('Ali Welsh,Mary Jane') select Name, SUBSTRING(Reverse(Name),charindex(' ',REVERSE(Name),1)-1,1) from #temp drop table #temp
  2. paulkeys

    Switch command

    Sorry - missed a comma; = Switch( Fields!Disposition.value="Repaired","Completed", Fields!Disposition.value="NotRepaired","Not Completed", Fields!Disposition.value="MoveToNextLine","Not Completed", True,"UNKNOWN") )
  3. paulkeys

    Switch command

    You could trick the switch function - something like = Switch( Fields!Disposition.value="Repaired","Completed", Fields!Disposition.value="NotRepaired","Not Completed", Fields!Disposition.value="MoveToNextLine","Not Completed" True,"UNKNOWN") )
  4. paulkeys

    How to get a total after using the switch statement?

    You should just be able to wrap this in a sum function - have you tried this approach?
  5. paulkeys

    How to convert a statement done in Crystal Reports to SSRS

    Couple of ways i can think of... Switch expression in cell =switch( sum(Fields!whatever.value)=0," ", sum(Fields!whatever.value)=60,"24/36" ..... ) or write a custom function in the report based on vb Select Case, and then call the function from the cell, passing in the sum() value - may be...
  6. paulkeys

    SSIS Solution doesn't work with SQL SERVER Agent Job Scheduler

    Hi, No, running them from the file system is fine. Are you trying to run them from within the solution folder, or are you deploying the packages to a 'deployed' area? The package protection level is set within BIDS - can be thinks like 'Don't save sensitive', 'encrypt sensitive with user key'...
  7. paulkeys

    SSIS Solution doesn't work with SQL SERVER Agent Job Scheduler

    A few questions... Where are you running the package from - File System, SQL? What is the package protection level for the package you're trying to run. What version of SQL Server are you using (2005/2008) and is it 32-bit or 64-bit. What are the data sources being used in the package (are...
  8. paulkeys

    MS BI online training

    These look pretty good. If you dig around a little on the website you can also view training videos from previous months. http://www.sqlservercentral.com/articles/webinar/71273/
  9. paulkeys

    SSIS to Copy File to Multiple Directories

    I'd probably approach this using a script task - iterate through the subdirectories of a particular root folder (which could be stored as a variable), and then use something like System.IO.File.Copy to copy the file from its original location to each of the relevant subdirectories.
  10. paulkeys

    Select All Records Before Today In An SQL View

    how about select * from table where sdate <= getdate()
  11. paulkeys

    Variable Drill through

    Assuming your doing this via textbox 'Go to report' action you can set the report to 'go to' via an expression. To carry on your example, the expression would look something like; iif(Fields!Type.Value="Widget","widget report",iif(Fields!Type.Value="Product2","Product 2 Report",""),"") If you...
  12. paulkeys

    SQL queries by data type.

    Not sure if i'm missing something here but would the ISDATE() function not achieve what you need.... SELECT * FROM Modules WHERE ItemID = 123 AND ISDATE(SubItemContent)=1
  13. paulkeys

    Mystery variable in connection string

    As MDXer says - DT_WSTR is the Unicode datatype in SSIS. The function you posted contains lots of (DT_WSTR,2), which is the type cast to convert data to Unicode string, length 2
  14. paulkeys

    Previewing a report

    You can set default parameters within the report that will be used each time the report is previewed for development purposes, then remove before deployment
  15. paulkeys

    SSRS Training?

    My book of choice was the wrox press one
  16. paulkeys

    Comparing Values In Adjacent Rows

    There is a "previous" function that returns the data for the previous row, so could potentially be used for what you're trying to achieve
  17. paulkeys

    How to get back using &quot;Jump to Report&quot;

    you could use a textbox in the sub report header with a jump to report set to get back to the previous report - this would depend on having all the required parameters available to provide to the parent report.
  18. paulkeys

    sum text field

    think you should be using =sum(CInt(Fields!Value.Value)) instead, as the int() function int() you've used will extract the integer part of a number as opposed to converting to integer - CInt()
  19. paulkeys

    [expressions] replace the second character in str 2 in the result?

    =replace(Fields!Name.Value,"#","") should work
  20. paulkeys

    Export Report to Excel 2000

    I've found on occassion that when excel is shutdown the process remains running in the background (only sporadically). If you open task manager, and look for excel.exe it may be worth tracking what is happening to this process when you're trying to open the report. If the excel processs is...

Part and Inventory Search

Back
Top