Recent content by normm

Thanks for the responses, BlueJay was correct, it required vbNullstring. I am the SQL developer, I rebuilt/ expanded the database that works with a new c#/xml front end. All stored procedures using this legacy spreadsheet have now been re-created but with parameters to scope them to the data...

Hi all, I am dealing with a piece of legacy code in an Excel spreadsheet. The following code has worked successfully for years however we have recently moved to a new SQL server and our stored procedure now requires a parameter. The code retrieves stored procedure names from the database which...

Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a TVF. I am not a fluent C#...

Thanks RiverGuy, that was essentially my issue with it! As a self taught SQL developer I was just worried that I was being "dumb" and had missed some feature that lets you reference to a component of a primary key rather than the entire key. It seems that after much procrastination on my part...

Thanks for responding Borislav, that was my initial suggestion and was discussed as a solution however It was decided that the insert method was better for our needs (I agree with this after being talked round). The issue boils down to, "Is it possible to maintain a referenced relationship...

Hi All, I wondered if you could clear something up for me. I have a database that we are currently attempting to roll out as a web app. Large scale changes are happening to the schema and we are currently working on provision for recording history within the database concentrating on the...

To follow on from my last statement I have just got this working declare @db_name varchar(max) select @db_name = top1 dbName from dbases declare @q varchar(max) set @q = 'select * from ' + @db_name + '.[dbo].infoSchema' exec(@q) infoschema definition create view infoSchema as select * from...

Hi bborissov, I know the names of the databases, that isn't the problem. Are you suggesting that I use a stored procedure to retrieve the data from Information_schema.columns by building a string? i.e. exec 'select * from ' + @db_name + '.Information_schema.columns'

Hi all, I need to create a view of Information_schema.columns for a particular set of databases, all located on the same server. The project is to improve the data documentation manuals that we currently hold as word documents, I Intend to create a database that contains a view listing all of...

Sorry I possibly should have said I am purely a copy and paste VBA programmer and I generally guess how to do these kinda things and google it. If that would be the way to do it I would appreciate direction to a tutorial, especially the referencing the field element bits. I'm guessing from...

Hi all hopefully someone can help me with this, I think it should be possible but I'm not sure how to do it, my access experience is limited. If this is a question that has been answered somewhere else a link to a guide would be appreciated however I cannot currently find one. I have a very...

Hi all I would apreciate some generic help with the following problem as it's probably far too complex to document and solve on a forum but I need some more ideas on how to diagnose this problem. situation: PHP running on a Hiawatha server using an mssql 2000 database. all of my queries run...

Thanks Chris, Mental block - I am officialy dumb! worked first time. again thanks!

Hi all, I'm having a little bit of a problem making my table look as intended. I am attempting to make a table to display data with a fixed header. After adapting the example at http://web.tampabay.rr.com/bmerkey/examples/nonscroll-table-header.html for my purposes I have inserted some form...

Thanks Denis I will look into that. Normm