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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by paulkeys

  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
See more

Part and Inventory Search

Back
Top