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 Chriss Miller 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. thermidor

    Issues Converting String to Decimal

    Hi All: I have varchar values like '01234560' that I need to convert to decimals like 123.456. The length of the varchar values change, so I'd like to be able to do something like: DECLARE @var1 varchar(8) , @var2 int SET @var1 = SUBSTRING('0123456', 1, 4) + '.' + SUBSTRING('0123456', 5, 3)...
  2. thermidor

    Modify Input Param Value in Function

    Hi All - Probably easy question: How do you modify the value of an input param in a function? I am passing in an Int and I want to conditionally increment the value. TIA - Sven
  3. thermidor

    Conditionally set values passed to IN operator

    Thanks for the pointer Dagon. SantaMufasa has helped me many times!
  4. thermidor

    Conditionally set values passed to IN operator

    Hi All: I want to write a query to conditionally set the values passed to an IN operator. Using the code below, I want to pass ('A', 'B') when someVariable = 'someVal'. Else I pass ('C', 'D', 'E'). Whatever I pass should filter the cur_data table on the key_letter column. Any thoughts how to...
  5. thermidor

    SSIS to Copy File to Multiple Directories

    Why can't I use a foreach container with a file system task in it? My thinking is the foreach would read the destinations into a variable and the file system task would use the variable to copy the file to the destiantions. I tried this but it doesn't seem to work...
  6. thermidor

    Mildly Complicated Use of Min()

    Thanks. I was having serious brain freeze...
  7. thermidor

    Mildly Complicated Use of Min()

    Hi All: I need to query the table below to get the Part_Nos that have the earliest Create_Dt, grouped by UPC. In cases where there is more than one matching result, I want the one with first value returned based on an alpha sort of the Part_nos. Based on the table below, I want to return...
  8. thermidor

    Use SSIS to Run Exe on Remote Machine

    Can you provide some detail how you did that?
  9. thermidor

    SSIS to Copy File to Multiple Directories

    Hi All - I would like to use SSIS to: 1) Read the names of multiple subdirectories 2) Copy a single file to each subdirectory (Same file to different destinations). Can anyone suggest how to approach this? TIA, Sven
  10. thermidor

    Use SSIS to Run Exe on Remote Machine

    Hi All: Can someone tell me if it is possible to use SSIS to run an executable on a remote machine, and if so how? For example, if I am running SSIS on MachineA, how can I run an executable on MachineB? Thanks, Sven
  11. thermidor

    Newbie Q: Change Tracking Comments in SSIS

    We do use source control, but I was curious about other places for comments...
  12. thermidor

    Newbie Q: Change Tracking Comments in SSIS

    Hi All: I am new to SSIS, but thave a lot of Oracle SP experience. In Oracle I would put a block of comments in the head of my packages to track change history. What is the best/suggested to do this in SSIS? TIA, Sven
  13. thermidor

    Conditionally Copy File

    Simple answer to my own question: copy-item H:\PS H:\PS_target -Recurse -Filter "*xyz*
  14. thermidor

    Conditionally Copy File

    Hi All - I want to write a PS routine to recursively search a directory. If that search finds files with a certain string of characters ("xyz") in the name, the file should be copied to a target with the directory structure on the source replicated (if it does not already exist) on the target...
  15. thermidor

    Newbie ? on Filtering Results of Get-ChildItem

    Hi All: I am new to PS. The line below almost does what I need... I want to recusively look in $Path and return every file that has the string "(1)" - open paren, digit one, close paren, in that sequence - in its name. With the command below, my results include files that have all three...
  16. thermidor

    Possible to Join Datasets ?

    Hi All - I would like to have a report where I can join data from a cube with data from a relational store. Can this be done in SSRS? TIA - Sven
  17. thermidor

    Use SWITCH to Format Strings and Ints?

    Hi all: I have a query that returns strings. However, I would like to conditionally format the data as a string or int. The following renders "# Error" in my report when it encounters data I want to format as string. =Switch( Fields!SORT_FLAG.Value=0,Fields!C1.Value...
  18. thermidor

    Join Multi-dimensional and Relational Data?

    What I want to do is expose data from a cube and a relational store, together. For instance, I have sales data in a cube and planning data in a relational store. Both have SKUs. I have full control over the relational store, but am only a consumer of data from the cube. I want to show the sales...
  19. thermidor

    Join Multi-dimensional and Relational Data?

    All: I have access to some cubes that I want to join to relational data. Can anyone suggest how I could/should go about that? TIA, Sven
  20. thermidor

    Compare Objects Between Dev and Prod DBs

    Thanks all for the great info!

Part and Inventory Search

Back
Top