Hello I am calling a stored procedure in a MSDE/SQLServer DB form within my Visual C++ 6.0 program along the lines CCommand<CAccessor<CdboMyAccessor>>::Open(m_session, NULL); With DEFINE_COMMAND(CdboMyAccessor, _T("{ CALL dbo.MyProc; 1(?,?) }")) It all works sweet as, but it can take a while...more >>

After creating an IN clause from a bunch of character strings created by a Word macro, Query Analyzer complains about a syntax error. The macro takes a column full of character strings and wraps apostrophes (single-quotes) around each string and adds a comma to the end of each line, ready to past...more >>

I have a stored procedure (below), that is suppose to get a Reg Number from a table, (Reg_Number), in such a way that every time the stored procedure is called, it will get a different reg number, even if the stored procedure is called simultaneously from two different places, However it is ...more >>

omlet@omlet.org wrote in message news:<dc6c1ff0.0406300739.5001ae2a@posting.google.com>... > fitzjarrell@cox.net (David Fitzjarrell) wrote in message news:<9711ade0.0406292055.4bfaa4fe@posting.google.com>... > > omlet@omlet.org wrote in message news:<dc6c1ff0.0406291431.ef3d9f8@posting.google.com>...more >>

Hi all, I have a SELECT with a varchar field and a number field. I need to order by the text field (a,b,c...) for number < 2000, and another order by for number>0. The result may look like this: Aaa 200 bbb 89 ccc 100 aa 2005 bb 2900 cc 2100 .... Is this possible with a single ...more >>

I want to execute a dynamically generated sql-statement from inside an user-defined-function. Calling functions and extended stored-procs is allowed so I tried sp_executesql as well as sp_prepare/sp_execute .... but both fail with an error 'only functions and extended stored-procs may be call...more >>

Suppose I have users that can belong to organizations. Organizations are arranged in a tree. Each organization has only one parent organization but a user maybe a member of multiple organizations. The problem that I'm facing that both organizations and individual users may have relationships w...more >>

I am looking to calculate the difference between and event time and a sample time of Now. This is the query that I thought would do it, however I'm returning DIFFERENCE values that look the same when the calcuation is being made on different EVENT_TIME values.... I thought I knew how DateDiff...more >>

I am writing SQL data apps using VB.NET 2003, MSDE is being used as the server. When I create and instance of the server, it has a the format machinename/instancename This is fine for the developement machine but how does my code connect to the server when it is on another machine ? Wh...more >>

Using SQL data compare i get the following error message: Could not allocate space for object '(SYSTEM table id: -701903460)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full. The comparison is being run on one server between to databases. It has been run several times but each t...more >>

I am struggling rewriting my query from MS Access' IIF, Then to SQL Servers TSQL language. I am hoping some one can give me some guidance. I believe I have the first portion of the query correct but do believe this requires a "NESTED" argument. This is where I am lost. My Original MS ACCES...more >>

I have two server defined (S1 and S2) S1 has a link defined to S2. If I open Query Analyzer and run a query referencing S2 server. My statement returns data (lets say I am using MSSQL standard authenitcation). Now I have a ASP.NET application that connects to S1 server using ODBC. The exact s...more >>

This is x-posted in: alt.php.sql comp.databases.ms-sqlserver microsoft.public.sqlserver.programming I have events that occur during the day. I want to be able to search those by a form with checkboxes (multiple select). Let's say for instance an event is happening from 3-10pm. When someone...more >>

I have a geographic points table containing point records with latitude and longitude points. I also have several other tables containing entities that will relate to points in the points table, ie. individuals, organizations. In every case, there will be a many to many relationship between an ...more >>

Hi, I'm not sure if this is possible as i've googled everywhere, but i have a select query that returns a customer record with their associated sales orders. I would like to automate a process which sends an email reminder to each customer in the database, that has outstanding orders. This ema...more >>

I have set the initial size of the log file for a database to 1M, the maximum size is unrestricted, and the increase rate is 10%. However, when I attempt to delete thousands of rows, the error is still reported that the transaction log file is full. Why can't the log file increase automatical...more >>

Hi, I run a stored procedure with a parameter given from a text box in an access adp. If the text box is empty then what is passed to the parameter? I can't seem to get it to flag up as either null, or 0 length. Any tips? Cheers, Chris ...more >>

I am in the process of testing an EMC Clarion install with our Data Warehouse. Performance is fast and consistent for queries using a clustered index but very poor for queries using non-clustered indexes. Performance on non-clustered indexes is very slow and inconsistent compared to our curren...more >>

Hi all. I know that since you know nothing about my database it will be a stretch to answer this - but does anyone have a boiler plate checklist for moving a database, dts packages, agent jobs, etc...from one server to another? Maybe something that just says I should at least do x,y,z. Also i...more >>

How do I loop thru a result set Without using a curosr?...more >>

I've Proc1 and Proc2, the output of Proc2 can be in XML or thru a normal Select statement, depending upon the input parameter specified (@xmflag). The default of @xmflag = 0 which means non-XML output. Now Proc1 is calling Proc2 and inserting the output of Proc2 in a temp table without specifing...more >>

Hi, I tried to use the following query to update a value in one table with a value from another table: UPDATE tbl1 SET col1 = tbl2.col2 FROM tbl1, tbl2 WHERE tbl1.[id] = tbl2.[id] but it won't work. I also tried this with a subquery using "TOP 1", but that wouldn't work either. SQL Ser...more >>

Hello All, I have a stored procedure which will act like a main/controller script which will then invoke more stored procedures (~20). Basically, it looks something like below: -- start script create procedure ... print 'process started' exec sp_1 exec sp_2 exec sp_3 .... print 'proc...more >>

Hi, I used SQL Server 2000 Personal Edition. I created a stored procedure having input parameters as smallint,tinyint,char,varchar and smalldatetime. When I executed it by Query Analyzer, it's ok. But when I executed it by ASP code that used ADODB.command, it showed error: Invalid character v...more >>

I have a problem with a stored procdure I wrote. This proc will process 80 to 100 million every night, it aggregates, inserts into a different table, and then deletes the original data. The process will hang after processing 20 to 40 million records. I must stop the proc and then restart it befo...more >>

i have installated on my computer ms sqlserver 7 .I want to try some transactions.Is it possible to connect as 2 or tree users just to simulate working with many users? ...more >>

Hi, Is there any replace for "Select @@identity" that could return "just inserted" GUID as a primary key? Has anyone tested what's faster, working with Guid or Autonumber ? ...more >>

Greetings, I have 3 servers all running SQL Server 2000 - 8.00.818. Lets call them parent, child1, and child 2. On parent, I create a view called item as follows: CREATE view Item as select * from child1.dbchild1.dbo.Item union all select * from child2.DBChild2.dbo.Item On child1...more >>

Hello When I use a PreparedStatement (in jdbc) with the following query: SELECT store_groups_id FROM store_groups WHERE store_groups_id IS NOT NULL AND type = ? ORDER BY group_name It takes a significantly longer time to run (the time it takes for executeQuery() to return ) than ...more >>

Hi, I would like to convert a dollar amount ($1,500) to represent Fifteen hundred dollars and 00/100 cents only for SQL reporting purposes. Is this possible and can I incorporate the statement into an existing left outer join query. Thanks in advance, Gavin...more >>

We have a Dell 6450 quad 1.6MHz, 4GB RAM running SQL 2000 on Win 2000 server with 2 PERC3/QC cards. Server has 4 internal drives configured as two raid-1 drives (OS and SQL logs). Server has 7 more drives in external drive rack for RAID-5 SQL data. We did not have a UPS available for server at ...more >>

Hi, I have a stored procedure that needs to know the name of the table from which it is called. If you are familiar with a "this" pointer in Java or C++, that's very similar to what I need. I know I can use db_name() to retrieve the database name, but how do retrieve the table name? Than...more >>

Hi, I'm having some trouble finding any information on this topic - can MS SQL server 2000 copy/delete files on the host computers disk. Any info on this would be great. Thanks, Eirik ...more >>

I have a statement that works in compatibility mode 8 of SQL Server 2000 while it fails in 7: declare @P3 int exec sp_prepexec @P3 output, N'@P1 float', N'select custname from customer where custnr = @P1', 12600034 custnr is a varchar(15). As long as the float p1 is less than 1,000,000 the...more >>

Hi. I did this SELECT BOTTLEA, BOTTLEB, BOTTLEC FROM MYPRODUCTS But, I would like to have the result returned only for distinct BOTTLEB. BOTTLEA and C can be anything. But the result that I get from the statement must have BOTTLEB as distinct. How do I do that? I tried SELECT DISTINCT...more >>

Hi everyone I had an access database running as the source for a website but it has become too large to run correctly so it has been ported to MS-SQL the problem is that 4 of the fields were Memo fields in access and as such are 5000+ characters long each this overflows the allowed size on the ...more >>

We have a series of stored procedures that utilize some of the master extended SPs such as xp_cmdshell. We migrated to SQL 2000 in April and everything has worked great for over 3 months. However, this week we discovered that the xp_cmdshell SP was missing from the master database. Here is the e...more >>

Does anyone know how to run a DTS package through a normal MS Access? I've got some code from the web and it doesn't seem to work - perhaps it is because I'm connecting to an instance on a particular sql server "servername\instance" Function SimpleExecutePackage() Dim oPKG As New DTS.Pa...more >>

How does one get the primary key of the row that is joined in via a group by aggregate clause when the aggregate is not performed on the primary key? For example, Person table ( PersonID int, FirstName varchar(50) LastName varchar(50) ) Visit table ( VisitID int, ...more >>

I am having a problem with a query, I am not sure if i would use a join or a subquery to complete this problem. I have two queries, and i need to divide one by the other, but i cant seem to get any type of join to work with them. Here is the situation. I have a projectDB table that has a lis...more >>

In SQL Server 2000, developer edition (on my desktop), I created a complex DTS package that truncates several tables and imports fresh data into them (from Oracle 9i). This package was scheduled and executed by the SQL Agent with no problem. When I moved the database to a server, the scheduled...more >>

I got a new Job where I have to handle Oracle databases on Linux. My previous experience is with Sql Server on Windows NT. I want to know how difficult will this shift be and what do I need to learn first and quickly. How different is Oracle on Linux then Oracle on windows. What are the major di...more >>

I have a view that will return say 5000 records when I do a simple select query on that view like. select * from vw_test_view How can I set up my query to only return a certain # of records, say the first 300? Here is what is going on, we have a large amount of data that returns in ...more >>

I'm using ODBC to interface a Microsoft SQL Server 2000. One of the operations involves placing files within BLOBs. I'm using the image data type for this purpose. Most of the time this works okey, but when trying to add a 21,3 MB file I get an error. The error code is 22001, which means "String...more >>

Hi all, I have some trouble with SQLAgent...when I try to schedule a job that invokes a script (vbs, java, cmdshell,...), SQLAgent crashes at the moment of scheduled execution. If I try to execute it manually, all works fine. This installation runs on a cluster Win2003 and the node initiate a fa...more >>

Does anyone have possible explanations for the following results? select count(*) from tablename >>> 2,500,000 select count(*) from tablename where fieldname is null >>> 2,400,000 select count(*) from tablename where fieldname is not null >>> 900,000 Just my luck, I was showing som...more >>

Hi to everybody, I'd like to know how to extract a progressive number in a select. Example.. Select * from employers Name Surname Position Age Hire Date Progressive Mario Rossi Consultant 25 26/07/2003 1 (this field doeas not exists in ...more >>

Hi I am trying to find out best practices for SQL Server 2000 installs for corporate servers. We currently have someone doing it 'in their spare time!' (I kid you not). When installing SQL server 2000 out of the box on a freshly formatted machine, I would like to get some feedback on the fol...more >>

I have little problem and I dont have any idea how to make my trigger. I have table MyTable where I have many column with almost same name and same type (Grp1,Grp2,Grp3,Grp4...Grp50 char(1)). I`d like to make some trigger on UPDATE this table. I must to check which column was changed. For e...more >>

Hi, I'm new to ASP and have stumbled across what appears to be a common problem, but after trying several solutions from other posts I've had no luck. My SQL SELECT statement is fine elsewhere (e.g. in ACCESS), but when executed from ASP I get this syntax error: Error Type: Microsoft OLE ...more >>