Recent content by larrydavid

Hello, I am trying to pend to an existing tab delimited flat file (log file) and am not quite sure how to do this. I know how to create regular log file from within the SSIS package but this is custom for the format and the events. Is it possible to add exception handling to a precedence...

Hi, I have already copied the files into a folder, great. Now I want to rename them. Created a foreach loop, set it to the same folder where the files exist, then added a File System Task where I have an expression to replace part of the filename. Can someone please tell me what I am missing...

Hi Olaf, Actually, using your example above with MAX(vw.EventCategory) is giving me exactly the output I need. Thank you so much for your support and sharing your expertise. Another learning experience. Best Regards, Buster

Hi Olaf, ACtually I understand how to use the group by clause but in this case I was a bit confused by the implementation, which I have on a subsequent post now. I'm getting close using an inner/outer query using group by and tried a few things using row number(), partition functions. But, it...

Hello, Here's what I have, which is getting me close... SELECT m.MemberID, vw.EventCategory, vw.EventType, vw.EventEffectiveDate, vw.EventTerminationDate FROM dbo.MemberEligibilityEventVW vw JOIN dbo.Member m ON vw.MemberKey = m.MemberKey JOIN ( SELECT...

Hi Olaf, Thanks for tying to help but this left me more confused then when I asked the question. I was able to get a better guide toward a solution at another forum. Cheers! Larry

Hello, I have a resultset which is returning records that may have two on one MemberID: Current Output: [MemberID] [Category] [Type] 12345 ABC test 12345 XYZ test 12777 ABC test 12888 FGD test Desired Output: [MemberID] [Category] [Type] 12345 ABC test 12777 ABC test...

Sorry, I thought it was pretty clear, If there are two rows with TESTNAME, one will have a FLAG value of VALUE_XYZ, the other VALUE_ABC. If these two appear in a result, remove the one with VALUE_ABC. Otherwise, if the one with VALUE_ABC only exists, just display that one. If the one with...

Hello again, Sorry, I should have mentioned that the results are mixed with other rows, so the output is currently: [PRODUCT] [DATE] [ORDER] [FLAG] TESTNAME1 2008-05-30 354565 VALUE_123 TESTNAME 2008-05-30 123456 VALUE_ABC TESTNAME 2008-05-30 123456 VALUE_XYZ TESTNAME2 2008-05-30...

Hello, Currently I have output like this: [PRODUCT] [DATE] [ORDER] [FLAG] TESTNAME 2008-05-30 123456 VALUE_ABC TESTNAME 2008-05-30 123456 VALUE_XYZ And need to return one row, but only the one with VALUE_XYZ. I was trying a UNION of...

Hello, I am passing a multi-valued parameter into a dataset from a TypeBusiness dropdown list: =join(Parameters!prmTypeBusiness.Value,",") Here is the dataset query behind the TypeBusiness dropdown parameter list: SELECT type_bus_code, bus_desc FROM business WHERE (type_bus_code...

Thank you George. This is what I did and it is working, same concept I guess: [CODE] ALTER FUNCTION dbo.fn_listTestTiers ( @dealItemCode varchar(12) ) RETURNS @tmpTable TABLE ( tierId int, tierItem varchar(12), tierQty int, tierAmt money ) AS BEGIN DECLARE @tierId...

Hello, I have a table-valued function in which I'm trying to return multiple rows per item code: ALTER FUNCTION fn_listTestTiers ( @dealItemCode varchar(12) ) RETURNS @TestTiers TABLE ( -- Columns returned by the function: tierId int NOT NULL, tierItem varchar(12) NOT NULL, tierQty...

THANK YOU BORIS! You're the man! --Larry

Hello, I have 6 possible values that can appear for 6 columns in a join table. Is it possible to return specific column values from a table-valued function and map those values to these columns? If so, could someone please provide a quick snippet or link to where I could see a code sample of...