Hello, I have a problem getting the value I want here ;-) I have a view looking like this: ITEM_SEQ_NO int unique ID for item CAST_ID varchar(20) Batch ID for n ITEM's STEP_NO int step in production 1-20 STEP_ORDER_NO int order of item within step Data could look like this Ite...more >>

Hi, This might be an easy one, just cant find how to code it. I have 2 variables which I want to add (strBalance and strLink) the values could be: 500+300 = 800. The problem is that my code is instead adding them like this: 500+300 = 500,300 Below is the code. ------------------------...more >>

Hi, This might be an easy one, just cant find how to code it. I have 2 variables which I want to add (strBalance and strLink) the values could be: 500+300 = 800. The problem is that my code is instead adding them like this: 500+300 = 500,300 Below is the code. ------------------------...more >>

am trying to get an sql query that will auto number rankings for me The problem is as follows Through a number of queries I can load a temporay table with data e. Site_ID,Total_Sales,Sales_Dept,Sales_Chip I need to end up with Site_ID,Total_Sales,Ranking_TotalSales,Sales_Dept,Ranking_Sales_De...more >>

Hi all If the IDENTITY Column exceeds the limit is it possible to reset automatically. It should be done automatically at the table level. Any answer?? Thanks in advance Anand. ...more >>

I am programming a VB-SQL Server 2K application which connects the clients to the database through the internet. While I am testing the application within a LAN in which the database server as well as the client connect to the internet through a router I can't ensure that the client connects to t...more >>

Hello, I just realized I made a BIG Mistake. I was working "Creating/Updating" several stored procedures. I ran an Alter on a stored procedure thinking it was another stored procedure. So I changed it completely. Is there a way I can recover the previous stored procedure code? If it helps t...more >>

I am trying to execute the foloowing as a stored procedure, however I keep receiving error messages indicating that the temp tables do not exist... Is this someting inherent in SQL Server sp' USE ATReportin G IF EXISTS (SELECT name FROM sysobjects WHERE name = N'usp_insertBillable...more >>

Unfortunately, I've inherited a database with a field which has been adding dates and times, but it's been using an nvarchar field . Most of the strings are in this format: Mon Oct 13 12:58:00 2003 EST but of course, there are still strings that will convert to date and time more easily li...more >>

I have the following table.... it stores points ,, as in currency type points.. or credits.. whatever you want to call it. CREATE TABLE [Points] ( [points_id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL , [type_id] [numeric](18, 0) NOT NULL , [action_id] [numeric](18, 0) NULL , [mem_id] [...more >>

Hello, I have a 1 million user db, where only a fraction (about 20,000) actually logged on daily. Every user is authonticated on each to a session value he received upon logging-on. users are logged out if they have invalid session value (hack attempt) and/or passed N number of minutes sinc...more >>

We are using sql server 2000 and have found that some of our constaints between tables are no longer there. This has happened a few times over the past few months with different tables. Any ideas as to why this might be happening?...more >>

We have a report that has successfully been previewed with the change of record source code. After changing the SELECT statement in the record source this error appears. Please help....more >>

I'm a bit embarassed to have this problem, but nonetheless, I've tried all I can think of. I can't seem to call a stored proc from a .net app that has a parameter. Stored procs with no params work fine, AND calling the stored proc from SQL Query Analyzer works fine. I'm sure there is somethin...more >>

first of all i am a student, so i want you to be a little mercy, because this is soo important to me ! second i got a real project that archieves the materials of a club in my univercity.. it will store the related information of photographs, CDs, cassettes, etc.. in one computer( that should be t...more >>

first of all i am a student, so i want you to be a little mercy, because this is soo important to me ! second i got a real project that archieves the materials of a club in my univercity.. it will store the related information of photographs, CDs, cassettes, etc.. in one computer( that should be t...more >>

Hello all I am developing a CountrySelector control (which I would like to share with anyone), but I am quite a newby in this custom control area. You can find it at: http://home.kabelfoon.nl/~juliusd/vbnet/CountrySelector.vb Some questions I have are: - In what event should the items be...more >>

Hi I'm trying to a merge similar rows in a table into a single row and put the in a new table Example: This is my input tabl Table ID A B ----------------------- 1 jk kl b 2 sd we o 3 io po k 1 ui gh e 2 kl re o 1 qw kj n My output table should look like thi Table ID A1 B...more >>

Hello I am connecting Access 2002 to a Microsoft SQL 2000 server. When I try to run a stored procedure that returns errors, I can only read the error codes, and not the description of the error. Here is some example code that I am using CREATE PROCEDURE dbo.Tes A BEGI RAISERROR ( 'Test', 16,...more >>

Hi, I need to select all the Null values in a coloumn but cant work out how to, ive tried all sorts such as SELECT * FROM Kits WHERE KitExpiryDate = NULL and lots of other combinations but it doesnt seem to work. Is there a special way to select NULL values. I hope someone can help me out Regard ...more >>

Hi I have two querys that work fine so I joined them with a Union and I get The text, ntext, or image data type cannot be selected as DISTINCT. So I used union all and now get All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their t...more >>

I am using OLEDB-SQL (ADO) under MDAC 2.7 and would like to know if there is any way to change the timeout period the driver takes to search for the SQL server before returning an error. Of most importance to me is a short timeout period, I.e. an error is returned quickly if the SQL server is dow...more >>