Microsoft SQL Server Forum

Hi, I would like to know if anyone out there really uses SQL Server 2000 (which edition?) to hold the data for a data warehouse? How much data does it handle efficiently? TIA Frank

HI, I have a problem in formula column. I have 8 1 bit varibles in a table for ex: Flag1, falg2, flag3 ...Flag8 Now I want to create another variable as a small integer and copy all the flgas to that field. For ex: (flag1 << 0x80) | (flag2 << 0x40) | ..... | flag8

Hi all In a new installation, if the data directory is stipulated as d:\data, it installs all data in d:\data\MSSQL\data. I need to place the data in d:\mssql7\data to incorporate backsup from old data backusp Any ideas ?

Hello! My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2) and MS ExchangeServer 5.5 the two following TransactSQL-codepieces show different results: 1. with attachment

There's an SP that in effect returns a table -- it loops and executes statements like SELECT @field1, @Field2, @Field2 Can I capture its results in a table? I know that if it were a FUNCTION that returned a table, that would be simple: INSERT ResultsTable SELECT * FROM dbo.Function (@Param1, @Param2) But how to do that if the code is a...

I have a shopping cart that will get full from time to time because customers click out of the site before they confirm their purchase, therefore leaving a full cart behind. I'd like to have a timestamp on this table, so that I can delete anything that I find is more than a day old. How can I do this? Thanks,

How to dynamically and partially Update the webpage? The content of the part of the page is from the user's requerement and get data from the server side. The purpose is to speed up the page update. We have a page that most of content are static, only small part is changed per user's select and the replying data need to get from server side...

Is there anything I can put in a stored procedure so instead of proc falling over because of "String or binary data would be truncated" the offending records are just truncated? Thanks for any help!

Hello group: I've done alot of reading on this subject somewhat and have found that many people have many different opinions on this subject. My question centers mainly around using a lookup table to enable users to select a pre-defined list of values. I have developed a practice myself of avoiding AutoNumber type data fields for primary...

We have an MIS system which has approx 100 reports. Each of these reports can take up to several minutes to run due to the complexity of the queries (hundreds of lines each in most cases). Each report can be run by many users, so in effect we have a slow system. I want to seperate the complex part of the queries into a process that is...

Is the minimum windows version for awe to work advanced server? The db is currently hitting the 2gb ceiling and we are getting into the busy season for our business. Thanks for the comments. Mike

I use select @@identity to return @@identity from my store procedure, but I could not retrive it from my Visual basic code, like variable= oRS.fields.item(0).value, it always says item can not be found....

Does anyone know if MDAC 2.8 will install and run correctly on a Windows 95 machine? Microsoft is non-committal and we are a generic install for all operating systems. Thanks, rick

Hi,guys! I have a table below: CREATE TABLE rsccategory ( categoryid NUMERIC(2) IDENTITY(1,1), categoryname VARCHAR(20) NOT NULL, PRIMARY KEY(categoryid) ) Then I do:

Hi All, I know that this is not right forum to address this issue, i had posted this problem in Javascript forum but of no use, i appreciate if any one of you can answer or point me to some useful guide. I tried my hand in google and googlegroups(dejanews) but of no benefit. I am not able to access a dll function from a remote script...

I am having trouble creating an INSTEAD OF trigger in SQL Server to replicate a BEFORE UPDATE trigger from ORACLE. Here is a sample of the ORACLE BEFORE UPDATE trigger: CREATE TRIGGER myTRIGGER ON MYTABLE begin :new.DT := SYSDATE; if :new.NM is NULL then :new.NM := USER; end if; end myTRIGGER;

Hi I am a newbie to SQL. I have a historical list of digatal points listed by time.ie: 3 fields PointName;Date/Time;State. I need to return a list of When a specific point chsnges state. For example a list everytime Point A transitions to State 1.

Hi I am trying to write a report that calculates the average number of sales over 7, 14, 31 and 365 days for each hourly period of the day. the problem is it takes over 4 minutes to run. e.g. Average Xactions per Hour 7 Days 14 Days 31 Days 365 Days 00:00 - 01:00 1,141.6 579.2 261.6 28.8

Hi I have the folowing stored proc. CREATE PROC NewDoc @Vrsta nvarchar(3), @Sifra int OUTPUT AS INSERT Doc(Vrsta) VALUES ( @Vrsta)

Hi, What I have is a booking table, and when updating/inserting I need to ensure that there are no date/time overlaps. The problem I'm having is that while the following script works for events on the same day, it fails miserably when a booking starts on a previous day.

I have actually extended my request I have a scenario like this....... update esan set tes_address_city = 'TEST1' --at some time update esan set tes_address_city = 'TEST12' --at some time update esan set tes_address_city = 'TEST123' --at some time backup database TESTWMS to disk = 'D:\temp\RecoveryTest\TESTWMS.db' backup log TESTWMS to...

I have 2 machines running MS SQL 2000 SP3 on separate network, Machine A undergoes transactional replication to Machine B, recently the network is not stable, so the replication stopped upon retry, and I have to re-sync it manually. I would like to know, 1. How many times of transactional replication wil re-try? 2. How long does it take? 3....

Hi, I'm trying to run the ALTER TABLE command using a dynamic string for the table, like so: DECLARE @TableName CHAR SET @TableName = 'Customers' ALTER TABLE @TableName ADD ...blah

Hi, I'm trying to add a modified datetime and userid to all 72 tables in my SQL 2000 database. I have the script to do one table, and a cursor, but it won't run across all tables. Any help would be appreciated. Thanks... DECLARE @tName varchar(40) DECLARE C1 CURSOR FOR select name from sysobjects where type = 'U' OPEN C1 FETCH NEXT FROM...

I have a book cataloge where I have an author id linked up to the book. However, I'm finding that some books have mulitple authors, and I'm wondering if there is a way to add more than one id to the author id field. Or do I have to have many author id fields? Any way around that? Thanks, Bill *** Sent via Developersdex...