Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

What is the best tool and/or technique to compare between a Dev and a Production DB? I need to migrate objects from Dev to Prod, but I only want to move objects that have changed. TIA, Sven

Hi All I have the query below. If I comment out DISTINCT I get 6446 records. If I include DISTINCT I get 6859 records. ANy ideas how this could be? TIA, Sven select count(*) from (SELECT distinct fcst_signature, NVL (interim_sku, lowest_sku) sku...

Hi All, I have a report with cascading prompts. I am looking for a way to allow users to reset the report, returning all prompts to their initial state, after selecting one or more prompts but prior to running the report. This seems like it should be easy but I can't figure it out. Any...

Hi All, I am new to SSRS. Can someone tell me how to use values from the Globals Collection in a query? I want to capture the UserID and use that as a filter in a sql where clause. TIA, Sven

Newbie question: Can I change the SQL inside an SSIS package by opening in Notepad and editing directly? TIA, Sven

All: I have two tables, one contains Inventory, the other Orders. The Orders are associated with a specific time period but Inventory is not. I want to join the tables and decrement Inventory from the Orders across the periods I have orders for. Any suggestions on SQL to accomplish this would...

Hi All, Can anyone suggest a query that will tell me how many times a given weekday occurs within a month. I want to know that in Jul 07 there are 5 Mondays; in Aug there are 4 Mondays; etc. TIA, Sven

All: In SQL Server 2000, how can I query the data below to get the parent and all the children on one row with the children in order from left to right based on the values in the Pctage column? Table: Parent Child Pctage --------------- -------------- -------- 50985...