SQL Server Newbies

• Topics

  Started by

  Posts

  Last post

• AND NOT EXISTS quesion

  There are 38 records in the Table referred to below with a RecordID=2. I want to delete all of them…

  William Hutchinson

  2 replies

  20 years ago

  By: William Hutchinson

• Break Logical table into two?

  I have a table with a large number of attributes (approx. 260). Logically this information belongs …

  Mark Nielsen

  4 replies

  20 years ago

  By: Chris Hedgate

• Sum hours

  I'm creating a adp front end in access from a mdb, with a sql 2000 back end. In the old mdb i …

  Michael Graves

  4 replies

  20 years ago

  By: Ninja's_RGR'us

• What the heck is CPU???

  Can somebody/anybody please let me what the CPU column stands for in the process info panel, under …

  stupid access

  2 replies

  20 years ago

  By: philcart

• SQL Newbie - stored procedure

  I'm running a access 2000 adp front end working from  a SQL2000 database. I've got a sproc P_i…

  Michael Graves

  1 replies

  20 years ago

  By: Frank Kalis

• SQL Newbie - stored procedure

  I’m creating an SQL database from an existing MS Access mdb. I’ve created the tables in SQL and in …

  Michael Graves

  1 replies

  20 years ago

  By: Frank Kalis

• Scroll Cursor and variables

  Folks When I retrieve a value from an access database (using openquery) using a scroll cursor …

  Axel

  1 replies

  20 years ago

  By: Lowell

• MSDE security - How do I update to SP4, or do I need to?

  I run Veritas Backup Exec for windows servers, and our recent scans have stated that I do not have …

  Joseph Ruffin

  1 replies

  20 years ago

  By: Lowell

• Wot! No RecordCount??

  I've recently moved over from MS Access, and that has a wonderful piece of code which tells me exac…

  Alan Notton

  12 replies

  20 years ago

  By: Alan Notton

• Security Advice required..

  hi, My system.. MS Access (MDB not ADP) client on SQL server 2000. Connection from Client to serve…

  Digs

  4 replies

  20 years ago

  By: Digs

• help with a query

  hello, Here is what I have so far SELECT [city_code], [outlet_code], sum([sold_units]) as 'units s…

  chuck lane

  26 replies

  20 years ago

  By: Ninja's_RGR'us

• Tracking Row Changes

  Hello All: I have a dilemma where certain users are telling me that over night there changes disapp…

  Cleech

  4 replies

  20 years ago

  By: Ninja's_RGR'us

• Query relational data

  Hi, I am looking for a way (SQL) to get the relational data of a database: What tabels is in a data…

  Douwe

  2 replies

  20 years ago

  By: Douwe

• scheduled job to script sql for all objects

  Anyone have a good solution for this?  I'd like to create a job to script the ddl for all obje…

  Wendell Holloway

  1 replies

  20 years ago

  By: sushila

• querying linked servers

  We have a MSSQL server with numerous linked servers ... some being other MSSQL servers, as wel…

  Troy Adam

  6 replies

  20 years ago

  By: Wayne West