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

    Editing Mappings Data Types in SSIS

    I have a SQL Server 2022 database and Visual Studio 2022. The database has a join table connecting several other tables. There is a view that shows the join table with the joined tables values rather than the keys used in the join table (all keys are uniqueidentifiers). I am a beginner with SSIS...
  2. grnzbra

    SSIS in SQL Server 2022

    Unfortunately, most of the Database Developer jobs out there seem to require SSIS.
  3. grnzbra

    SSIS in SQL Server 2022

    Thank you for the clarification. You say you wouldn't be keen to use SSIS going forward. Is this due to difficulty or is there something wrong with SSIS or other better items out there?
  4. grnzbra

    SSIS in SQL Server 2022

    I've got SQL Server 2022 and am trying to learn SSIS to go with it. However, I can't find any books for SSIS 2022 nor any YouTube videos. When I try to use an old SSIS 2005 book, tries to lead me through SQL Server Data Tools, which don't seem to exist in SQL Server 2022. Am I doing something...
  5. grnzbra

    Using Access Database Without Having MS Access

    Thank you very much.
  6. grnzbra

    Using Access Database Without Having MS Access

    Thank you very much. "Runtime" - that's what I couldn't remember. Is the following done for each table in the database? ' ADOX: create table Set adxTable = New ADOX.Table With adxTable .Name = "Table1" With .Columns .Append "Field1", adDate ' date .Append "Field2"...
  7. grnzbra

    Using Access Database Without Having MS Access

    Not quite. How does one, using MS Access create an Access database that can be used on a computer that does not have MS Access installed?
  8. grnzbra

    Using Access Database Without Having MS Access

    No. How does one create it?
  9. grnzbra

    Using Access Database Without Having MS Access

    I have seen an application that uses an Access database without the user's computer needing to have MS Access installed. Once someone has created the database in MS Access, how do they create this version of the database?
  10. grnzbra

    SQL Server in Windows

    At one time, Windows included a stripped down version of SQL Server. Do the current versions of Windows still have this feature?
  11. grnzbra

    Force Data Entry Format in Excel

    Thanks. I guess the best to suggest that they do it that way. Thank you.
  12. grnzbra

    Force Data Entry Format in Excel

    I don't have any of that information - the user is supplying it. I agree. It is bad form but that's the way I've been instructed to do it. I've had this type of nonsense happen before.
  13. grnzbra

    Force Data Entry Format in Excel

    Unfortunately, I need to present the data as in the form - one field for the three pieces The data going into the field is Building Name/Floor/Room. They are going, eventually, to tblBuilding, tblFloor, tblSpace. I believe that the code is already in place to split these three pieces of...
  14. grnzbra

    Force Data Entry Format in Excel

    Someone, in their infinite wisdom has created a website that connects to a database. This website has a data entry form which has a field into which three pieces of information are to be entered separated by slashes (/). The .sql code in the database then breaks up the three pieces of...
  15. grnzbra

    Set Cell Equal to Selected Value from Dropdown.

    I have a column of dropdowns. I would like to be able to set cell A1 (it can be any given cell) equal to the value selected from the dropdown. Is there any way of doing it with Excel functions rather than using macros?
  16. grnzbra

    How Do I Add Column to Middle of Table

    A column was accidentally deleted from a table and needs to be added back in the same place that it was originally. Using Design from the Object Explorer for the table in question, I can easily add the column wherever I want in the table. However, when I go to leave, I get a message that says I...
  17. grnzbra

    Formatting Full Hard Drive

    I tried with Explorer. Ah. I thought about a DOS prompt but it's been so many years since I used it that I don't remember how to do it.
  18. grnzbra

    Formatting Full Hard Drive

    I am a photographer and keep my photos and associated post-processing info on an external hard drive. I also have a second hard drive to act as a backup of the first hard drive. What I didn't realize was that each time there was a backup, it was added to the second hard drive. I now find that...
  19. grnzbra

    Create Function Within IF statement.

    Thank you both very much. It works fine now. Unfortunately, I need to run these script against various databases that are sent to me, so I need to be able to create the function if it isn't there, but not have the script choke if it is there.
  20. grnzbra

    Create Function Within IF statement.

    I need a function within a script. At any time when this script is run, the function may or may not exist. I have tried writing it in the form of IF EXISTS DROP FUNCTION GO CREATE FUNCTION GO This gives an error saying the function already exists (I guess because they are in separate...

Part and Inventory Search

Back
Top