Hi, I have attached SQL 2000 database to Microsoft SQL Server Beta Edition Ver 9.00.1116 and kept Compatibility Level to SQL Server 2000 (80). While updating a table I am getting error for a specific record "Creating or altering table 'FakeWorkTable' failed because the minimum row s...more >>

Hi! I am running one SP - which needs to return strings, seperated by delimitter. I am using output parameter of type Varchar (8000). I learned that this is maximum length allowed. Now what problem I am facing is, for a particular field, the delimitted text is getting higher than 8000 ...more >>

Are 2005 mdf files compatible with version 2000? ...more >>

I'm trying to build a dynamic sql statement on Northwind. Both attempts below return an error. I'm trying to achieve a dynamic statement without using the sp_executesql SPROC. I've seen examples on the web like my 2 statements below, but I seem to be missing something. Can someone help debu...more >>

Hi, I need help :) I am rather new at rdbms like Access 2003, or SQL Server 2005. I need to finish a DB in Access 2003, then port it to C# 2.0 front end with a SQL Server 2005 Standard DB. I recoil in fright.... Here is the groundwork for my question: I have a table called 'People...more >>

Can someone help out a lowly web programmer who's SQL skills are sorely lacking? My usual go-to guy for this stuff is on vacation, and I really need to get a mockup going. I need two queries. The data is so simple that I'm embarrassed not to know this! (I've removed all but the relevant fie...more >>

I'm trying to check integerity using Delete triggers between 2 database but from my C# apllication t always say that the query successfull!! how could i make this work?? ...more >>

I need an Insert trigger to create a set of tables to my database when i add new record in the top level master table (horizontal partitioning denormalization).. Is this possible using trigger or procedure or even function?? and how?? any help appreciated. ...more >>

Say I want to select rows like SELECT * ID from MYTABLE WHERE ID>20 I need the number returned Cheers -- Best Regards The Inimitable Mr Newbie º¿º ...more >>

I'm looking for a way to track the dates a row was inserted and the date of the last update, regardless if someone tries to mess with the dates or not. I believe I have found the way, but just wanted to make sure it was the "best" way in terms of speed and accuracy. Any comments welcomed and ...more >>

Hey, I have a kind-of-newbie question. I need to create a form that will eventually produce a report in html / asp. while in access that would not be a problem, I'm learning my ways through this project in the asp world. So, I created an access database that should hold the information ente...more >>

Hi, I have a table called D_AGE. There are just two columns CREATE TABLE [dbo].[D_Age]( [Age_ID] [int] NOT NULL, [Range] [char](10) NULL) The Age_ID will be filled with values from 1 -100. The Range column should be filled with '1-20', '20-40', '40-60'... depending on the age wich was...more >>

For the life of me I can't seem to find what's wrong with this query.... SELECT DISTINCT u.userId, dbo.fn_zGetDefaultUserPhotoID(u.userid) as UserPhotoId, u.Gender ,u.LastName ,u.FirstName ,dbo.fn_zGetSchoolName(dbo.fn_zGetCurrentSchoolID(u.UserID)) as = CurrentSchoolName ,u...more >>

Hi, I have a query as below:- SELECT unit, unitname, ( SELECT TOP 1 id FROM occupants WHERE unit=units.unit AND GETDATE()>=keyrecdate AND (GETDATE()<keyretdate OR keyretdate IS NULL) ORDER BY keyrecdate DESC ) AS curr_occ_id, ( SELECT TOP 1 form_submitted FROM occupants ...more >>

Hi, Is there a way to bulk load data from table to table other than using DTS? Thanks, Yaniv ...more >>