Hi people, I?m trying to alter a integer field to a decimal(12,4) field in MSACCESS 2K. Example: table : item_nota_fiscal_forn_setor_publico field : qtd_mercadoria integer NOT NULL ALTER TABLE item_nota_fiscal_forn_setor_publico ALTER COLUMN qtd_mercadoria decimal(12,4) NOT NU...more >>

Hi experts, I have been trying to limit the table rows in the following situation, any suggestions will be appreciated. we have table called tempTb has columns id, c_id, c_name, rating, date columns. id is an identity column. date is a datetime column, the rest are varchar datatype. Here ...more >>

Following on from a thread I started about "concurrency" (real-time-ish system), I thought I would play about to see if I could easily adapt my data model to take account of potential multi-user write conflicts. So, I would appreciate you checking my logic/reasoning to see if this kind of th...more >>

Here's a challenge that is killing me: I've got 2 web servers and a SQL Server and about 5,000 'users' who stay connected to the site all day. I have a page that is supposed to be 'real-time', so to do this, I have a 1px frame that refreshes every 15 seconds (so the other frame doesn't have to...more >>

Dear Internet User, (Testimonial of Participant) Good day, This article I've written is all about the fact where I earned an ASTOUNDING amount of money in just over a month and I've decided to share or reveal the secrets behind making big bucks in the Mail Order Business. So all money se...more >>

I am about to start working on a project where I would be required to dynamically create linked servers during the execution of an application. One of the requirements is for the Link Servers to be created and dropped before and after the retrieval of the data. My question is about any type of c...more >>

Hi, I wanted to know if Access Data Projects is a good option to choose for a SQL Server Database Frontend. The other option is C#. The database will be accessed by multiple users (around 100 users) on a LAN. ADP looks viable coz the users are used to working on a MS access database. Please ...more >>

I am adding this to my c#.Net app... How can I sort all rows in a table? After it is sorted, will it remain so after i do a cnSQL.Close(); so that when I then do a: string strSQL = "SELECT InvoiceNumber " + "FROM tblPrintInvoice " ; Is it still sorted for me to do a: drSQL.Read? Thanks, Tr...more >>

I am under the impression that either there are deficiencies in the way SQL Server 2000 is keeping track of depedencies or perhaps the dependencies simply need to be re-evaulated / recompiled. What is the best and/or easiest way to ensure that the dependency info is accurate? Is there a ...more >>

Hi, I am going to put some of my Access 2000 databases into SQL Server 2000. I don't really have much of a clue how to do it, or how to manage it. First, my ISP gave me a database name, user name, password, and an IP address. But I don't really know what to do with it. Do I go in my browse...more >>

Hi All, Our SQL Server just crashed with the following messages: The Scheduler 5 appears to be hung. SPID 85, ECID 0, UMS Context 0x06C22478. Error: 17883, Severity: 1, State: 0 We are running SP3 on cluster on a SAN. Any ideas? Thanks Michael...more >>

Dear Reader,, From where can be availed the SQL 2005 (Beta) version for study? SuryaPrakash Patel -- Message posted via http://www.sqlmonster.com...more >>

I've a SQL view performing a number of very precise calculations ie. 495/(1.112 - (.00043499*((Col1 + Col2 + Col3))) + ( .00000055 * ((Col1 + Col2 + Col3)) * ((Col1 + Col2 + Col3))) - (.00028826 * Col4))) - 450)/100 Obviously this sometimes causes a precision issues because the float and re...more >>

Hello Joe Over the past several years, I have found your responses to jdbc usage/driver related issues to be extremely helpful. I am sure that you're very busy so I will make my question as brief as possible - the reason I didn't post this to a newsgroup is that I don't want to hear any more ...more >>

Hi, I have come to point in my db design where I'm trying to figure which is the best approach in making it generic (does this really matter?!?) Senario - I have a table called JOBS and this table contains field such as JobTitle, JobDescription, Salary etc I want to add to this table oth...more >>

I need to be able to create my own MSSQ UDF to return the current system date, offset by a configurable number of minutes, depending on a value in a table. The reason I am trying to do this is, I want to be able to, for testing purposes, fake the system into thinking that time has elapsed. Chan...more >>

i have a table like this StoreId DateClicked 1 1/1/2004 2 1/1/2004 1 1/1/2004 1 1/1/2004 1 1/1/2004 3 1/1/2004 2 1/1/2004 I want the result of the query to be this: NumberOfClicks StoreId 4 ...more >>

"David Portas" <snipped for brevity> wrote: Example 1: > > UPDATE table_a > SET col = ? /* Unspecified */ > WHERE EXISTS > (SELECT * > FROM table_b > WHERE table_b.key_col = table_a.key_col) > <snip again> Many thanks. I have used this sample extensively since you posted it. Ho...more >>

Hi, Where does Sql server store the most current active T-SQL statements? Is there a system table or stored procedure(documented or undocumented)that will show you the active sql statements being executed. For eg: in oracle you can query v$sql to see all the sql statements executed by each ses...more >>

In which system table the information about the optional parameters passed to stored procedure are stored. I know about the tbl_columns and all that stuff. From where can i can come to know the parameter is mandatory or optional. -- Message posted via http://www.sqlmonster.com...more >>

I am trying to create a query that will show me who is phoning who in an organisation from available Telephone Billing information. I am creating a MSAccess 2000 database with a few few tables, two of which are: TableMembers: (containg fields Refs, DateCreated, MembershipNo, OfficeLocation...more >>

Ok, I have a data warehouse that I am pulling records from using Oracle SQL. I have a select statement that looks like the one below. Now what I need to do is where the astrics are **** create a case statement or whatever it is in Oracle to say that for this record if a 1/19/2005 record exists ...more >>

I have an existing query from MS Access that I want to convert it to SQL Server Stored Proc. My problem is on how to convert the WHERE clause. This is the query from MS Access: SELECT SchYrSemCourseJoin.SchYrSemCourseID, Students.IDNo, [LastName] & ", " & [FirstName] & " " & [MiddleName] AS...more >>

Hi all, One of our companies is having problems with a query on a linked server. They have two servers, serverA and serverB. On serverA they have set up a linked server to serverB. Query: select * from oas_company where code = 'TEST' If I look on serverB via Profiler the query is exec...more >>

Hi, Is it possible to install on a Windows server 2003, SQL SERVER 2000 in the folowing configuration : SQL server 7.0 as a default Instance and SQL server 2000 as a named instance. Thanks for your answer....more >>

I have been losing sleep over this puzzle, and I'm convinced my train of thought is heading in the wrong direction. It is difficult to explain my circumstances, so I will present an identical make-believe challenge in order to avoid confusing the issue further. Suppose I was hosting a dinner a...more >>

Hello group! i have a table "group_code" wich relates the names of nt-(domain)-groups to codes. now i want use the stored procedure xp_logininfo (asking for the group-membership of the current user) to join the result to "group_code". then i must use the new result (the code) to join against...more >>

I am having some difficulty in constructing outer joins. I have simplified what I need to do and have included sample SQL statements: create table tab_a (id int, descr varchar(10), qty int) insert into tab_a values (1, 'item one', 10) insert into tab_a values (2, 'item two', 20) insert into ...more >>

Dear group, I have to replicate remote data to a SQL Server in the headquarter. The data are on a site which does not have permanent online-connection to the headquarter. I have written a script which replicates the data and i want to set up a process / batch on the headquarter-machine whic...more >>

Hi, I'm trying to determine with my program whether or not a given database supports a given feature set. To do this I'm querying for certain stored procedures in the sysobjects table and if they are present, making the assumption the database will support the given feature. The problem i...more >>

For part of a school project with MS SQL2000, I have to write a query to answer: Which students are enrolled in both Databases and Networking? (Hint: Use the SECTION_ID for each class so you can determine the answer from the IS_REGISTERED table by itself.) Here are the tables: * is PK, ...more >>

We're trying to use DTS from SQL Server 2005 beta 2 to query data from an Informix IDS server via OLEDB. Unfortunately DTS is building queries of the form: select * from "database":"owner"."tabname" and the quoted table name is being rejected by the Informix server as a syntax error. ...more >>

Hey guys, Does anyone know a way (in Enterprise Manager or thru a SQL statement) to get the number of rows and the size of each table in a database? Thks, ...more >>

Hi All, I need to help with converting rows to columns in SQL2k. Input: Id Name Role 58 Ron Doe Associate 58 Mark Bonas Doctor 59 Mike Johnson Doctor 59 John Smith Associate 102 Chris Carter Associate 102 Ron Doe Associate 102 James Jones Associate ...more >>

How do you execute a stored procedure in MS SQL Server? I can design and execute them from MS Access dev front end, but cannot seem to find how to run them in the Enterprise Manager. TIA. ~ Duane Phillips. ...more >>

Could any suggest to me a good way to programmatically identify which SPs update a database column. I would like to create a cross reference for our database. ...more >>

Greeting All, I have a stored proc that dynamically truncates all the tables in my databases. I use a cursor and some dynamic sql for this: ...... create cursor Loop through sysobjects and get all table names in my database. .... exec ('truncate table ' + @TableName) Now, I want to b...more >>

Asking for some sample SQL/SP code to perform updates/deletes with joined tables. Example 1: For every record that is matched on both tables A and B, update a field in table A. Example 2: For every record that is matched on both tables A and B, delete record in table A. TIA. ~ Du...more >>

Hi all, What I am trying to do is generate a stored procedure that is desired to output XML in this type of format <Parent Device> <Device> <Device ID>1</DeviceID> <ChildRegister> <ChildRegisterID>22</ChildRegisterID> </ChildRegister> </Device> <Device> <Device ID>2</DeviceID> <Child...more >>

Is there an easy way to perform a SELECT where you have blah LIKE 'asdf' but instead of just returning all the asdf's, it also looks for =E0sdf, =E1sdf, =E2sdf, etc? ...more >>

Is it possible to have the field as a unique key and a optional one? It is like.. for example, office code has to be unique (cannot be duplicated with the same code) and it could be null too. ...more >>

hello! i am trying to import a text file using dts into a table created by the package. everything checks out until it is run. the table is created but then i get an error: "need to run the object to perform the operation. Provider generated code execution exception EXCEPTION_ACCESS_VIOLATION...more >>

Hi, I'm having trouble running the following query: select * from message where text_body like ' ----------%' ie, five spaces followed by at least ten hyphens. The query doesn't complete, so eventually I cancel it. If I remove the hyphens from the query ("... like ' %'") then it r...more >>

Dear Internet User, (Testimonial of Participant) Good day, This article I've written is all about the fact where I earned an ASTOUNDING amount of money in just over a month and I've decided to share or reveal the secrets behind making big bucks in the Mail Order Business. So all money se...more >>

I would like to configure e-mail alerts on my SQL Server 2000 box. However, we also run Exchange on the same machine. I've been told there could be conflicts/issues having Outlook on the same machine as Exchange; and apparently, one needs Outlook to configure a mail profile for SQL Server Agen...more >>

Hi All, What is the SQL command for creating a direcotry c:\mydata\data1 on my server. Thanks in advance John S *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

It is very interesting to me that most people in this group can't do simple SQL. Are you viewing MySQL as a simple file system?As long as you do that, you will not understand SQL in any dialect. So from now on: When you have a question about SQL. post the table structures. Uh, "With Create". ...more >>

Hi All, I have the table as follows column1 ---------------------------------column2-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------...more >>

Is an index in a database the equivalent for a <TH scope="col"> in a column of a table in the html code? -- Luigi ( un italiano che vive in Svezia) https://www.scaiecat-spa-gigi.com/sv/damskor-italien.php ...more >>

Hi there, I'm not sure if this the appropriate group so apologies if it lies outside the boundary. Senario: I have a customer table with contains a bunch of different bit values that represent true/false values pertaining to the customer. I decided for the purpose of clarity I would move these...more >>

Hello all, I'm trying combine 2 tables data into a single table. My tables look like this Table1 ID int 4 filename nvarchar 25 incident nvarchar 50 dreport nvarchar 10 treport nvarchar 7 doccur nvarchar 10 DateOccured datetime 8 toccur nvarchar 7 loc nvarchar 55 ucode nvarchar 20 r...more >>

I've created a small company database where the tables reside in a SQL Server database. I'm using Access 2000 forms for a front end. I've got a System DSN set-up to SQL Server and am using links within Access 2000 to get to the SQL Server tables. My forms worked fine until I made a few minor...more >>

Hi, How can I store a stored procedure's results(returning dataset) into a table? Bob *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Select LOCGeneralHave.LSCH, LOCSubClassHave.LSCH from LOCGeneralHave , LOCSubClassHave Where (LOCGeneralHave.LCNT <> '0' and LOCSubClassHave.LCNT = '0') This query seems to be ignoring the 'and' part of the clause. Basically I want select from table1, table2 where LCNT in table1 is not 0 a...more >>

Hi people! I'm looking for an SQL query builder application that helps me construct SELECT queries with full respect of underlaying relational model. It would be nice if the app is database independant because my work covers MSSQL, mySQL and Oracle DB. OpenSource and/or comercial suggest...more >>

Hi everybody! I am currently working with C# and MSDE. Is there an easy way to export all the data from MSDE in case something crashes? Also, is it possible to export the database structure? Many thanks! ...more >>

I have an interesting problem - I get a different number of rows for the number of rows in a table when I double click the table name in EM and when I run a select count(*) from <tablename> in QA. Can somebody tell me why this is happening? The numbers are off only by a few hundreds though. ...more >>

Hi, Ive been told this, but I hope it is NOT true. I have an sql server2000 installation running on a server that has four processors. It is on a active network but is not the domain controller so essentially it is fully dedicated to servicing the needs of sql server, (a bit of browsing, a bit o...more >>

I need to create a script to disable all triggers and constraints in my database. It appears as though I cannot use a local variable for the table name in the ALTER TABLE statement (e.g. ALTER TABLE @TBL). Is there any reason for this? Thanks, Kevin ...more >>

The data file is a simple Unicode file with lines of text. BCP apparently doesn't guarantee this ordering, and neither does the import tool. I want to be able to load the data either sequentially or add line numbering to large Unicode file (1 million lines). I don't want to deal with another p...more >>

I have written an stored proc that reads from a text file and executes the script as dynamic sql. If the text file contains malicious code,I want to be able to detect it and prevent the stored procedure from executing. I've tried revoking delete,insert,update rights all tables in the databa...more >>

Can someone explain what happens when two users concurrently attempt to create a new record in a table with an autonumber primary key? For example, user 1 creates a new record and manipulates it within a transaction making use (perhaps) of the @@IDENTITY value when creating other, related r...more >>

Hello all, I have a client with an application that they have purchased, it stores its data on SQL server 2000 and so I am able to do reports and some small VB apps that use the data. I can't however make any significant changes to the app itself, just what it allows you to configure. The ...more >>

Hi, I want to log updates to specific fields, storing the new and old values. Is there any way I can iterate the collection of updated fields within a trigger in order accomplish this? Thanks in advance, Julie Vazquez ...more >>

Hi, I am trying to setup a subscription but I keep running into problems. I setup the subscription fine, I see that it creates a job in SQL Server. It shows a specific domain account as the owner and I can't figure out why. The problem is that this account is in a different domain and it's ha...more >>

/* goal: dynamic evaluation of table row platform: sql 2000 */ use northwind; declare @tbl sysname set @tbl = 'customers' EXEC('select count(*) from ' +@tbl) /* Why the following dynamic evaluation would fail IF EXEC('select count(*) from ' +@tbl) = 0 PRINT 'no rows' Its variant...more >>

Has anyone had any luck getting Crystal Reports 8.5 to work with the Sql Server 2000? I keep getting a "Unable to open Database" error. I've tried opening with either the .Connect property and the LogOnServer method and get the same message from either approach.I am using the OCX control. ...more >>

I have created a SQL Stored Procedure that uses a Case statement to determine the Order By. For one of the Case statements I am trying to turn a Char field into Datetime in for the Order By, however I can not get it to work. Can someone please take a look and my code below and tell me what I a...more >>

Hello all, I have a stored procedure that prompts the user for beginning date and ending date to run a monthly report. The prompt says Enter_Beginning_Date and Enter_Ending_Date. I want the prompt to say Enter Beginning Date (Example:1-1-2003) or something like that. Is there a way to do this? ...more >>

Hi All, I have started getting Assertion Errors in SQL. It appears when I process a cube (Most of the time) Other SQL statements, usually with a join or 6 do the same thing. Whaving a scratch around google, I noticed the most people who get these errors are using SATA drives. Either RAID or...more >>

uff... I've another problem.... In this loop I've same ADO 2.7 error (number: -2147217865, description: Invalid object name '#tabella_temp') at STEP 3: '--STEP 1-- sSql = "IF OBJECT_ID('tempdb..#tabella') IS NOT NULL DROP TABLE #tabella" m_cn.Execute sSql, RowAff, adExecuteNoRecor...more >>

I have a new installation of SQL Server 2000 Dev Edition on a Win2K3 Standard Edition Server that I used for development. I just set this machine up in th last week and installed all Win2K3 patches and then installed SQL2K and SP3a. I have a single named instance. I just noticed today that I cannot ...more >>

I convert my DB from Access to SQL Server , When i try to run my script (in ASP) it's not store the data at Date/Time field!!! And i have troble with insert the value TRUE in Sql Server (it's work with access) I want to know if i need to change my scripts(in ASP) or the type of fields? ...more >>

Dear Gurus, A Client has the following problems/requests for their Production databases, what is your professional/practical advises to tackle and resolve these issues: 1)Number of Transactions per day – The current database can currently handle about 5000 order transactions per day 2)T...more >>