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