Recent content by smn198

I've got a fairly simple package taking a file, unpivoting it and then sorting it. The problem is, this is taking forever. The file contains about 1.8 million rows and 9 columns (including the pivot) so we end up with 14.4 million rows. It is using stacks of memory (our test and development...

Hello! I've just picking up SSIS but I've run into a problem where I want to do some non-standard string manipulation. I've got a data source with 2 columns. ID and data. The data column is a string but has multiple lines within it seperated by return characters. I would like each line of data...

I didn't explicitly state it be a greater payment id doesn't nessisarily mean that it is a later gift (which is what I'm after). RGA_Activity rga table RecurringGiftID field PaymentID field (fk to WH_Gift.RESystemID) WH_Gift p table RESystemID field Date field For each...

Hi all, I'm trying to improve the performance of a very slow running query. I'm linking master records to child or payment records via an intermediate table. Diagram: http://tinypic.com/view/?pic=ny7lf9 For each master record there may be many entries (or 0) in the linking table and for each...

Never mind then

Thanks swampBoogie Unfortunately I cannot use functions

Sorry. I didn't specify. I need ANSI SQL. Thanks

Hi All I have the following table: ID NAME ----------------------- 1 Bob 1 Chris 2 Harry 2 Joe 2 Tim 3 Tom 4 John 5 Larry Is there any way at all to return this: ID NAMES ------------------------------------- 1 Bob, Chris 2 Harry...

Thanks for the replies. I neglected to mention the SQL is actually going into an application. All I can write are static queries and not Dynamic SQL as what I write is a string to be used as a subquery.

I am trying to get around SQL's inability to use TOP with a variable. I am trying to select the TOP X and order by NEWID() to get X random records in a table. Any ideas?!

Hi Glenn Thanks for your reply I want all the columns in the original table returned and just a few of the rows. It may be easier if I just ask for the ones I want to loose. Then I can subtract them from the original query. In that case I want to select 1 row for each variation of ID, Type...

I've got a little stuck! I as the solution I have doesn't work properly and it is sloooooooooow! I have a table setup with the following data: ID Type Value Date 1 1 Yes 1 1 No 1 2 No 01/01/2004 1 2 Yes 01/01/2005 1 2 Yes 01/01/2005 2...

Thanks very much everyone. Have sorted it out. It was actaully being filtered by something in Crystal.

This has an unexpected side effect. When the Last1stPaymentReminderDate is set to null by the case statement, that row is excluded from the results. How do I keep them?

Thanks, I must be too tired...