Search results

Hi, I have a MS SQL database on a shared host, and would like to move it to a new shared server host. When moving, the database should remain exactly the same, without re-indexing of primary keys etc. The trouble is, my new host will not attach a SQL Server database, and are unwilling to...

Hi, I've got a news table in an Access database, with the following fields/datatypes: ===== tblNews ===== news_id (auto number) news_headline (text field) news_article (memo field) news_date (date field) I have a select statement from an ASP page like so: SELECT * FROM tblNews ORDER BY...

Hi, The following code works in Firefox, but in IE7 it just spits out a screen full of weird characters: <% Response.ContentType = "application/pdf" FPath = server.mappath("pdf/portfolio.pdf") Response.AddHeader "Content-Disposition","attachment; filename=" & FPath Set...

Hi, I work on several SQL Server 2000 databases and usually do so with Enterprise Manager. However, since I installed Visual Web Developer Express (to help me move from 'classic' ASP development to .NET development) my version of Enterprise Manager will no longer work. I got Enterprise...

Hi, I've got the following MS SQL tables: tblProduct ---------- Product_Id | Product_ManufacturerCode tblProductDetail --------------- ProductDetail_Id | ProductDetail_ManufacturerCode | ProductDetail_CategoryId tblCategory ----------- Category_Id | Category_Name tblProductDetail is a...

Hi, I've got the following MS SQL tables: tblProduct ---------- Product_Id | Product_ManufacturerCode tblProductDetail --------------- ProductDetail_Id | ProductDetail_ManufacturerCode | ProductDetail_CategoryId tblCategory ----------- Category_Id | Category_Name tblProductDetail is a...

Hi, I'm trying to run a procedure which does a bulk insert, but am getting a permissions error. As a total novice to SQL Server, could someone explain how to allow myself permission to do this? Thanks!

Hi, I'm using a thrid-party data provider to supply me with technical product specs for my e-commerce website. They have provided me with three very lengthy SQL scripts and several large (up to 30Mb) text files. When I run the first script it creates a bunch of tables. This executes...

Hi, I'm currently migrating a website from using an Access database to an MS SQL database. I'm quite new to MS SQL so this is probably easy - I just don't know how to do it: I'm trying to import my five Access tables to a new SQL Server database. Do I have to set up the tables first before...

Hi, I'm new to queries. I've managed to build a very simple query which joins two tables. How to I save these results so that I can export a tsv file from them? (I'm using Access 2000). Thanks very much for your help...

Hi, I have an access database which has a date field. I've entered all of the dates in valid UK format (dd/mm/yyyy). An example of the table looks like this: Id| SeminarName | SeminarDate 1 | Introduction | 18/02/2006 2 | Other stuff | 19/02/2006 When I do: SELECT * FROM tblSeminar WHERE...

Hi, I have the following four tables: tblGroup: Group_Id (PK) | Group_Name tblSubGroup: SubGroup_Id (PK) | Group_Id (FK) | SubGroup_Name tblProductType: ProductType_Id (PK) | SubGroup_Id (FK) | ProductType_Name tblProduct: Product_Id (PK) | ProductType_Id (FK) | Product_Name I...

Hi, I have a product table in Access, like this: product_id | product_name | product_quantity I need to be able to do an SQL update on this table to subtract 1 from the product_quantity field. I could do this with two SQL queries (SELECT product_quantity, then subtract 1, then UPDATE...

Hi, I've got three tables: tblEvent -------- Id (PK) | Event_Name tblDelegate -------- Id (PK) | Delegate_Name tblBooking -------- Id (PK) | Event_Id (FK) | Delegate_Id (FK) I need to retrieve a recordset with the following information: Booking Id | Event_Name | Delegate_Name Can...

Hi, An Access database table I'm looking at has a date column, where date is entered in UK format (dd/mm/yyyy). However, upon entering the database, the date is somehow converted into US format, despite me passing the date into the table as dd/mm/yyyy. The trouble started when someone else...

Hi, I've got a database containing three tables: ===================== tblEvent: --------------------------- Id (PK) | Event_Title | Event_Price ===================== ===================== tblDelegate: --------------------------- Id (PK) | Delegate_Name =====================...

Hi, here's the scenario... I'm building an ASP based email application which is to send emails to different user groups. The email addresses in the database need to be able to be assigned to more than one user-group, and an administrator needs to be able to add user-groups to the database. So...

Hi, I have a table of registered users with the following structure: tblRegistrant: Id | Name | Address | Email ------------------------------- I have two other tables, one containing the users' email preferences, and another containing the users' SMS texting preferences...

Hi, I have the following four tables: ============================= tblLocation Id | Location _____________ 1 | London 2 | Birmingham 3 | Leicester ============================= tblType Id | Type _____________ 1 | Flat 2 | Maisonette 3 | Bungalow...

Hi, Maybe someone can help. I'm struggling to find resources to help me join 6 tables through a SQL query to run on an ASP page. There are five tables which are linked together by one table (tblProduct): tblPartManufacturer: Id (PK) / PartManufacturer tblPartType: Id (PK) / PartType...