Recent content by grnzbra

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

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

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?

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

Thank you very much.

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

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?

No. How does one create it?

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?

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

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

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.

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

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

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?