Search results for query: *

I'm looking to develop a basic website to administer a sports league. I'm an experienced SQL Server database developer but am new to web development. I wish to make full use of my database skills in manipulating data so will be preferring to use the efficiency of pre-compiled stored procedures...

No, that's the same object library I mentioned in the initial post. The point being that it doesn't work for SQL Server 2008 and has been "replaced" in some way by SMO. How to make some alien contact with the elusive SMO is what I seek.

I use Access 2003. For many years I was able to dynamically manipulate the structure of objects in my network SQL Server 2000/2005 databases (i.e. tables, views, stored procedures etc.) by creating a reference to the SQL Server DMO object library (Tools, References). The network SQL Server...

Having experimented a bit on this, I opened two separate instances of IE (not two tabs within the same instance) on the same machine and accessed my site via two different login IDs. Behind the login script there is a piece of code which sets the session("username") value. So, in IE instance 1...

Thanks Chris.

There's probably something basic I'm missing here but, if my ASP page contains the following: <% rsProducts.Close Set rsProducts = Nothing objConnection.Close Set objConnection = Nothing %> If User 1 runs the page and, whilst executing and having set the recordset and connection object...

Thanks for the response. I think I've either understated the problem or you've overlooked something. I'm trying to use the script contained within the actual .sql file itself, i.e. not hard-code the "SELECT ..." statement as per your example. So, I need something which accepts the path to the...

I'm looking to execute a SQL Server script which I've saved as a .sql file, from Excel VBA, and export the results into another Excel workbook via ADO. Could someone please supply a simple example? It's the referencing of the .sql file which I can't get my head around. Presumably, I also need...

Thanks guys for the update and the revised function coding. I guess I started off with the wrong assumption, i.e. that there were 53 weeks in 2010 when in fact there were only 52.

MajP - sorry if there's any confusion on this. In the subject line of the thread I tried to state that I'm looking to return the date of the first day (assuming the week runs from Monday to Sunday) for the stated week. For example, week 1 in 2011 would return 3 Jan. Likewise, week 53 for 2010...

I picked up the following two functions as a means of determining a date from a week number in Excel VBA. Unfortunately, when used together, they return the same date for both week 53 of 2010 and week 1 of 2011 (3 Jan). Does anyone have anything more reliable please? Thanks. Public Function...

Thanks to you both for your suggestions. I'm sure I'll find one which suits my needs.

Thanks for the replies PHV and Gruuuu. I'm aiming to do this manipulation of the Oracle SP from Excel VBA. Essentially my project involves rationalising a large set of manual processes which involve three hierarchical levels: the Oracle back-end, an Access application (where the data is being...

I know there is the SQL-DMO object library which allows all objects on a SQL Server to be manipulated, i.e. databases, tables, views, stored procedures etc., but is there an equivalent reference within VBA for the objects in an Oracle database? I'm particularly interested in changing the...

Im trying to create a formatted Excel spreadsheet with the results of a T-SQL query. However, I'm getting an error when using the following code which seems to be in generic use on several forums. Can anyone tell me where my syntax is wrong? I have the necessary permissions for executing...

OK, here's what I'm trying to do: I'm writing a script which will allow the contents of ANY two tables to be compared (assuming they both have identical column names & datatypes). The aim is to examine the contents of Col_1 from Table_1 and check to see if any of the contained values differ...

I'd already tried tried sp_ExecuteSQL to no avail. If it's possible to reference a cursor declared dynamically within the same script and return 5 records (as below) ... declare @sql varchar(200) declare @my_id int set @sql='DECLARE my_cur CURSOR FOR SELECT TOP 5 [field name] FROM [table...

Can someone please tell me why this doesn't work? declare @sql varchar(100) SET @sql='DECLARE @myvar int' EXEC(@sql) SET @myvar=5 SELECT @myvar Thanks

Much appreciated. I guess I didn't word the aim of the exercise too well - I needed to know how to make the SELECT box visible. Your example answerered this, thanks.

Maybe I'm missing something in how this javascript statement is meant to work but I can't get a (blank) select box to display when I load a page. Any advice appreciated: <%@LANGUAGE="JAVASCRIPT" CODEPAGE="65001"%> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"...