We are looking for a solid order management / inventory management system with some accounting functions. We currently use Open Orders on SQL server, but have recognized many design flaws that are causing us performance issues when the WEB site is busy. We also have issues with historical reporting(non existant for the most part), and […]
2002-02-21
4 reads
I have the following table: CREATE TABLE ITEMS ([ITEMID] int, [itRULE] varchar(1)) INSERT INTO ITEMS (ITEMID, itRULE) VALUES (11, 3) INSERT INTO ITEMS (ITEMID, itRULE) VALUES (12, 3) INSERT INTO ITEMS (ITEMID, itRULE) VALUES (21, 2) INSERT INTO ITEMS (ITEMID, itRULE) VALUES (22, 2) INSERT INTO ITEMS (ITEMID, itRULE) VALUES (31, 1) INSERT INTO ITEMS […]
2002-02-18
Hi I am looking at upgrading some SQL 6.5 servers to SQL 2000. The 6.5 servers run a mixture of code page 850 & ISO 8890 and sort orders of 42 & 52. We want to ensure all the 6.5 databases are migrated to 2000 BUT want to future proof the SQL 2000 databases by […]
2002-02-15
2 reads
Hi, I am a Visual Basic programmer and I have following problem. I use Windows NT and MS SQL Server 7. I need to Backup a Database (called TRWasser) at a path saved in Win Registry (that's no prob > VB). For example "C:\MSSQL7\Backups\TRWasser\TRWBKP.bak". I even don't know the ending of SQL Backup files, I […]
2002-02-14
3 reads
Table is not indexed. I am exporting a database from a sql server to an other server. And when i run the program that uses the database i get error message. Table is not indexed. How do i get it working?
2002-02-12
11 reads
Hi , After installing sql server 2000 sp2 the web application keeps disconneting. To fix the probem they have to stop and start the database handler on the web server. Any ideas how this can be fixed. Application is blaming the problem on sp 2 lori kennedy
2002-02-11
1 reads
Hello all... In my researh in the past few weeks, concerning the usage of SQL2000, I have seen much of this.... CODE HERE -- CREATE TABLE Location ( LocationID int NOT NULL, LocationName char (30) NOT NULL UNIQUE, CONSTRAINT PK_Location PRIMARY KEY (LocationID) ) CREATE TABLE Parts ( PartID int NOT NULL, LocationID int NOT […]
2002-02-06
Hi Guys , I have tried to replicate the data from specific tables into another server. The replication process is working fine for tables which don't have image datatype field. In one table (Employee) I have a Image data type field . When i run an application with insert statement for the employee table also […]
2002-02-04
3 reads
Hi everybody In order to calculate the growth between two time members I use the following MDX formula iif(isempty(([Measures].[Calls],Period.Calendar.PrevMember)),0,[Measures].[Calls] - ([Measures].[Calls],Period.Calendar.PrevMember)) Is it possible to update the above definition in order to calculate growth according to a different time hierarchy and avoid adding an additional calculated measure? Thank you in advance for your support Kind […]
2002-02-04
Hi there, I want to upload/insert an image datatype from my hard disk onto the SQL Table using isqlw. TA.
2002-01-30
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers