Microsoft SQL Server Forum

I have two tables one on SQLServer and one on DB2. I want to update SQLSERVER table with some information that is on the DB2 table. I have unique id to match the records. I want to refresh some of the fields for records that key match from db2 to SQLServer. Records not found on db2 that are on SQL need to be deleted and records on db2...

I'm having a problem writing the correct sql to bind togeather three tables. Here's the problem: I have a table for detail information on books that are in our catalog, and a table for authors. Unfortunatly, it is not a one to one relationship. Some books are written by several authors, hence, I've created an intermidiate table called...

Hello. Can anyone tell me if a SQL Server 2000 database can be recovered only from the MDF and log files ? I have no backups. Thanks in advance

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...

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...

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

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....

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...

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.

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

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 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.

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 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...

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:

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

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....

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

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...

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...

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!

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...

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,

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...

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