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!

Search results for query: *

  • Users: larrydavid
  • Content: Threads
  • Order by date
  1. larrydavid

    Custom Flat File Log in SSIS 2008

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

    Rename a group of existing files in foreach loop

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

    Return distinct record with distinct value if duplicate date range

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

    If two different values are present for a dup id, use one, else use the other

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

    Return One Of Two Duplicate Rows Based on Column Value

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

    Removing Outer Single Quotes for WHERE IN Clause from Join(Parameters)

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

    Return Multiple Rows in Table-Valued Function

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

    Table-Valued Function - Returning Specific Column Values in Stored Procedure

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

    rank() OVER / PARTITION BY vs CTE for numbered groups

    Basically, the solution for this is to order the cat (catalog) sequence sequentially with the next group being renumbered 1, 2, 3, etc. But as you can see here, if the previous value stops at say 12 and the next value only has 1, the following group picks up with 13, 14, 15 and so on. 198879...
  10. larrydavid

    Assign variable to CASE statement with nested variable

    Hello, I am trying to assign a variable in an insert into statement value as such: @Base_ID = (CASE @Category_Type WHEN 'GENERAL' THEN 1 END) I keep getting syntax errors so I know this is wrong. I've been searching for examples and cannot find this so if anyone could tell me what I'm doing...
  11. larrydavid

    Implicit Conversion Problem for String to Double

    Hello, I have a VB.NET function I'm using to pass values, in this case simple addition to test. Here is a small class with the functions: Imports System.Web Imports System.Web.UI Imports System.Web.UI.WebControls Partial Public Class _Default Inherits System.Web.UI.Page Protected Sub...
  12. larrydavid

    Save Changes Per Row in Continous Form

    Hello, I'm updating 2 columns in my back-end SQL Server table based on the value in my dropdown list: Private Sub ComboReturnSource_AfterUpdate() Dim strSQL As String Dim dbs As DATABASE If Me.ComboChkReturnSource = "TEST1" Then Set dbs = CurrentDb() strSQL = "UPDATE dbo_TEST1...
  13. larrydavid

    Run-time error '3265' when executing stored procedure

    Hello, I have the following sub which executes a stored proc which runs great in SQL Server (2008) QA: Private Sub StoredProcedureTest() Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Set cnn = New ADODB.Connection cnn.ConnectionString = "Provider=SQLOLEDB;Data...
  14. larrydavid

    Setting the recordset position to the currently active record in a continuous subform

    Hello, I am trying to use this function (courtesy of Allen Browne) to copy the currently selected record in a subform to a new record at the end. This function was written to copy only the last record. In the CarryOver function (shown below) I think the key at this point is to set the recordset...
  15. larrydavid

    Copy current record to last with popup in continuous subform

    Hello, On my continuous subform I need to have a popup form (preferably acDialog) add two values to the current record, then subtract that amount from the current record. Then, add a new record with the adjusted amount. So, they expected input/input would be: Input: Popup form...
  16. larrydavid

    Data Type Mismatch (3464) in SQL UPDATE string

    Hello, I hope this isn't totally lame, but I've spent the past couple of hours beating my head against the wall (no more hair left) trying to find this data type mismatch. After saving a record I am trying to update a record in anmother table with a form id. I made sure that both ids in both...
  17. larrydavid

    Pulling up record in a popup form based on table join to the current form (record)

    Hello, You've all been so helplful with my recent barrage of questions so I promise I only have one more then I will rest (for awhile). I have a popup form (using acDialog) which is working fine. On load, the popup form takes two unique values from the calling form and saves this into another...
  18. larrydavid

    Can't find form reference in VBA code

    Hello, I have a subform open which has a combobox. AfterUpdate() on this combo box, a modal popup form appears for user input. On the Form_Close() event, I am trying to set the values to controls on the subform: Private Sub Form_Close() If IsNull(Me.cboEntity) = True And IsNull(Me.cboLOC)...
  19. larrydavid

    Update Values in Previous Row in Continuous Subform

    Hello, Using Access 2003 sp3 with lnked tables in SQL Server 2008. I have a subform which uses a vba module (courtesy of Allen Browne) to carry over the values from the current record to a new record. Everything works fine except now I need to update a couple of fields that we're in the...
  20. larrydavid

    Passing Two Possible Values From Two Forms To One Form

    Hello, I have two forms which need to pass a value to a field on another form that open AfterUpdate(): Dim stDocName As String Dim stLinkCriteria As String If [refund reason] = "MCR" Then Me.ComboChkReturnSource.RowSource = "tbl_Test_Source" 'Pass and populate...

Part and Inventory Search

Back
Top