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

    Security issue on 2 databases simultaneously

    In VB6 I have a designer report that needs to call some t-sql code to populate the report. The issue is that the t-sql code creates a recordset that pulls from 2 tables that are in separate databases each with their own security. I can run the code from the query analyzer and it returns the...
  2. nuVBer

    Multiple records into single record

    That's it!!! Great work George!! I really appreciate you sticking with me on this and solving this problem.
  3. nuVBer

    Multiple records into single record

    I just changed the type on uid from int to nvarchar on the second line of the function. Nothing else changed. It is now: Create Function Getep (@uid nvarchar(50)) Returns VarChar(8000) As Begin Declare @Result VarChar(8000) Select @Result = IsNull(@Result + ',', '') + ep From UserAccess...
  4. nuVBer

    Multiple records into single record

    After changing the type on the @Result in the function I got the following result: AT000033 MKT562,MKT562,MKT562,MKT562,MKT562 AU001529 MKT441,MKT441,MKT441 CA009436 MKT211,MKT211,MKT211 CH066601 MKT544,MKT544,MKT544 CZ000015 MKT412,MKT412,MKT412 CZ000022 MKT552,MKT552,MKT552 JP001043...
  5. nuVBer

    Multiple records into single record

    Not sure what's going on but here is a partial list of the resulting recordset. AT000033 NULL AU001214 NULL AU001428 NULL AU001507 NULL AU001529 NULL CA009436 NULL CH066601 NULL CH370817 NULL CZ000015 NULL CZ000022 NULL DE010275 NULL DE010298 NULL DE010549 NULL DE010833 NULL ES100946 NULL...
  6. nuVBer

    Multiple records into single record

    Here is the select and result: select distinct uid, ep from useraccess order by uid AT000033 MKT562 AU001214 MKT441 AU001428 R930 AU001507 9987593000 AU001507 Country AU001507 Market AU001507 MKT441 AU001507 R109 AU001529 MKT441 CA009436 MKT211 CH066601 MKT544 CH370817 Market CH370817...
  7. nuVBer

    Multiple records into single record

    Yes, I read through this but I don't see how that can be used in my situation. I may have several columns that need to be concatenated into the single field being returned but this doesn't seem to address that scenario.
  8. nuVBer

    Multiple records into single record

    I have a table with the following columns: userid, ep When I run a simple select query I get something like this: userid ep us0123 mkt1 us4567 mkt2 us0123 mkt3 What I want is this: userid ep us0123 mkt1, mkt3 us4567 mkt2 I can't figure out how to do this...
  9. nuVBer

    Create multiple records from a single record in text file

    I am creating a new text file from an existing one in DTS. Each record I read from the existing file needs to create 4 new records in the new text file with various changes depending on the record read. I haven't been able to determine how to write multiple records in the new file. Is the "Main...
  10. nuVBer

    ActiveX code stumped

    OK, I'm stumped. I've been writing vb code for quite a while now and this is extremely easy code that is failing. Someone please tell me what I am missing here. Function Main() dim new_cc dim new_acct dim period period = mid(DTSSource("Col001"),1, 4) if period = 2003 Or period = 2004 then...
  11. nuVBer

    Exporting to text - checking if file exists first

    Give yourself a star...good post.
  12. nuVBer

    Null values imported from Excel

    Thanks DBomrrsm, That works fine.
  13. nuVBer

    Null values imported from Excel

    I'm trying to import an Excel spreadsheet into a table using DTS. The data I'm importing is a mix of text characters and numbers in Excel that I've formatted into text. When I import it to a SQL table I get values for the text, but NULLS for the numeric data. I am creating the field as nvarchar...
  14. nuVBer

    DTS lookup - How to change value with lookup

    Perhaps I misunderstood what a data driven query is. I did get the process to work and I suppose that is what I used not knowing what it was called. I created the lookup witha simple query: SELECT SAP FROM account_conversion$ WHERE (Acct = ?) and created the connection to the...
  15. nuVBer

    DTS lookup - How to change value with lookup

    Thanks Katy44, I appreciate your response, but I don't understand why the lookup function won't work in this case. That is what I thought this was designed for. I must be missing something. I looked at your response on the "Data Driven Queries" question and that looks like what I need. I tried...
  16. nuVBer

    DTS lookup - How to change value with lookup

    I am creating a text file from another text file and want to copy all the columns except one. This column needs to use it's value to lookup a value in a db that is mapped to the other value and replace it in the new file with the mapped value. I've never used the lookup functionality and can't...
  17. nuVBer

    Using DTS from Access VBA module

    Yes, I looked it up and it is pretty simple really. Here it is: CREATE PROCEDURE [essbase].RunDataTS AS exec ("master..xp_cmdshell 'dtsrun /Smerrick /Uessbase /Pessbase /N Load oper-accrl.txt file'") GO
  18. nuVBer

    How does Essbase and Analyzer flow?

    If your report is set up to drill through to a relational db that contains for instance, details of the summarized data from the essbase cube, then yes it can do that. I'm not familiar with Business Objects, but Essbase has a tool called Essbase Objects that will allow you to use the Essbase...
  19. nuVBer

    Populating combo box with many items quickly

    Well, yea that works, but it is only slightly faster than what I was using...maybe 1% faster. I suppose I was looking at maybe a different concept. Thanks for the help though.
  20. nuVBer

    Populating combo box with many items quickly

    I am building a combo box (drop down) on a html page and using js to dynamically populate it with a recordset. It has approx 5000 records and takes about 2 minutes to load. The code looks something like this: While (!rs.EOF) { frm1.cboCC.options[i] = new Options(rs("cost_cent") +...

Part and Inventory Search

Back
Top