Experts:
I need an EXAMPLE of a FUNCTION that you may have that basically is designed to ASSIGN A CUSTOMER STATUS to a customer number, based on some form of logic that is based on a SPECIF...
SELECT * FROM SIAPROD WHERE PRO_DESC LIKE '%100R12 3/8%'
SELECT * FROM SIAPROD WHERE PRO_DESC LIKE '%100R12 3/8%'
Is there any way to make only one query with several expression in like?...
I'm running some databases on a MS SQL 7.0 server and want to move these to a new box that is running MS SQL 2000 SP3. Tried the upgrade utility, but it supports only SQL 6.5. Is there another...
I am using MS SQL 2000.
I have 3 column
Sn. Name Sector
-----------------------------------------------------------
1 ABC 25,150,28,45,36,55...
Based on the example shown below. I would like to know how to get back the person, the reviewer and date of reviewer based on the most current review date of the three date columns.
Example...
Hi!
Is it possible to execute a dynamic procedure name fetched thru "select @myproc = storeprocname from customprocedures" and passing a parameter?
Looking for something like the EXEC sp_e...
I'm attempting a new install of SQL 2000 on Windows XP, where I accepted most of the default settings. In Enterprise Manager (left side), I'm able to navigate to the databases just fine (no l...
i want the results of an sql query to return all results that have a '%' in the field but since % is the wild card in sql i cant just use example like '%'.
i have tryed doing '%%', '/%', '%"...
I am new to ms sql server and I have a client whose host oniy has ms sql server 2000
but I have a copy of ms sql 2008. so I would like to know if there any confict with haveing both on the sa...
Why is this sp tryiing to return an int?
ALTER PROCEDURE [dbo].[testproc]
@FiscalPeriod nvarchar(20)
AS
BEGIN
declare @temp datetime
set @temp = (select min(date) from tableA wh...
Does anyone know if I can make a procedure quit (raise an error) if it has run for more than x seconds?
My client is running MS Accounting 2007 - we are running into an error that the Primary Group is Full. The data base is set to AutoGrowth. Here's the error:
Could not allocate space for o...
I've found similar articles everywhere concering Linking Tables for many-to-many table relationships. However, I still don't know how the Linking table rows are populated. Is this done by Inse...
I am trying to drop a user and can't. Keep getting the message (in one way or the other)
The database principal owns a schema in the database, and cannot be dropped.
its me again. :)
I want to expand on the procedure below. at the moment if I pass in a department ID (@Dept) i get returned the department, category and product details and it all works goo...
Hello,
I would like to write a query to "pivot" my data that is in a table. I'm stuck.
Right now the columns look like this:
Garage Car Status Car Status Car Status Car Status Car Sta...
I have tables:
study
-------
id int
name nvarchar(255)
indicator
----------
id int
name nvarchar(255)
study_indicator
------------------
study_id
indicator_id
that is...
i exported data from a crm into a sql2005 database the tables (table1)have a user id field a hexidecimal number instead of the the account name as it was in the crm
in another table (table2)t...
is it possible to give windows access rights for a specific table and not the whole database?
Hi, I come from a background of classic ASP where I used to construct the SQL dynamically in ASP without stored procedures. I am writing a new site and are now starting to use SPs.
In the ...
Is there a way I can get this to work? At the moment it only return one row, the one starting with 9DF.
declare @myid as varchar(100)
set @myid = '9DFD8877-19ED-4E71-8887-C1A84AD29E7D,F...
I need to get the count of medications that were prescribed to a particular client. Some clients have more than one provider so I only want the count for the provider that last prescribed med...
I need to update column RandomCompanyID in the persons table with a random number between 3888 and 85530.
I am trying the following and many permutations of the code but I can't get it work...
Hi all
I have an sql 2000 based store procedure.
changes has been made to this store procedure..
How can I view the history of the changes made to this procedure.. = SP_Insert_Cash
I bel...
SELECT
case
when grouping(ClusterID) = 1 Then 99999999
else ClusterID
end as ClusterID,
MAX(ClusterName) as ClusterName,
c...
