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

I keep getting this with this. First, heres my sql string: SELECT item_itemcurrentbidprice, item_itemcurrentorpurchasedbidder FROM TBL_Items WHERE item_itemnumber = 'b4e81177-35dd-44d7-b996-8e285103f11a' Here's the code: error happens at 'ToString' at the bottom. Dim itemNumberSold As String ...more >>

Is it possible to print data using an SQL statement or stored procedure Any suggestions would be welcom Thank Sandro...more >>

Does it matter whether a condition is specified as part of a JOIN or in the WHERE clause? In other words, this.. SELECT * FROM orders o JOIN orderdetail od ON o.ordid=od.ordid AND datediff (dd, o.orddate, od.orddate)=0 returns the same as this... SELECT * FROM orders o JOIN orde...more >>

i am finding that for stored procedure output parameters of type char, blank values are returned as nulls .... which is not what i expected ... CREATE PROCEDURE dbo.usp_GetMaxLocationNumber ( @Prefix char(3), @MaxLocationNumber char(7) OUTPUT ) AS SET NOCOUNT ON SELECT @MaxLocationNumbe...more >>

Hi, How can I find out what's the exact queries executed on a given database Thanks...more >>

Hi all, Is it possiable return a text data type form a SP? create proc test @test_text text output as Select test_text from Table 1 Thanks for your time Steve ...more >>

Hello All, Why should the Create Procedure be the first line of every batch? I don't understand the reason behind this requirement. Thanks for your help. regards, Abhishek....more >>

Newbie question: I have a client table (ClientID), clientPhone table (ClientID, PhoneID), and Phone table (PhoneID) I made a view linking the clientPhone table to the phone table, but can't add any new records! PhoneID in the phone table is an identity column What I need is a table with ClientID...more >>

strSQL = "UPDATE [tribidz].[dbo].[TBL_Items] SET" & _ " item_itemsoldprice = " & PrepareStr(PutPriceAsSold) & _ "FROM TBL_Items " & _ "WHERE item_itemnumber = '" & fstQuery & "'" This is the error message: Incorrect syntax near 'TBL_Items...more >>

I have a Stored Procedure where I'm using an Varchar(500) variable. But when I store more than 255 characters and then I read it, It got truncated... I want to know why if that kind of data suppose to store up to 8000 bytes. Thanks in advance Carlos Lee ...more >>

I have a column in a table that stores XML of an order...call the column "order_xml." The xml looks like this (simplified): <?xml version="1.0"?> <order> <total>100</total> </order> I want to select just the <total> value in a select statement for each order and then sum the results. ...more >>

SQL Server 2000 I want to 'shuffle' address columns so that the first n columns always contain the address elements. For example: Add1: 1 Add2: High Street Add3: Add4: London Add5: W1 1AA becomes Add1: 1 Add2: High Street Add3: London Add4: W1 1AA Add5: or Add1: Add2: ...more >>

Why can't you put the column alias inside a function call in an ORDER BY clause (Using the Northwind database Example: The following query gives an error (Invalid column name 'title') select ContactTitle as title from Customer Order By LOWER(title whereas this doesn't select ContactTitl...more >>

Firstly I am new at asking questions, so please excuse me if I supply too little or too much information, and explain if I need to supply more detail, Thanks. Ok I have 3 tables tblConnotes, tblProducts1 and tblOrderDetails. I am trying to include a tblConNotes.qtyRecieved as a SUM , the probl...more >>

Hi! I have a large table in SQL Server 2000 with a datetime-column 'dt'. I want to select all rows from that table, excluding days which fall on holidays or weekends. What is the best way to accomplish this? I considered creating a new table called "holidays" and then selecting all rows (sort ...more >>

Having small problem, i'm trying to retrieve hyperlinks from my Database with the use of ASP, its for a small project this i'm working on, i was woundering if anyone had any ideas of how to set up a column within a table that is used to store URL's. I also want to retrieve these URL's and ...more >>

Hi, I have problem with rolling back a named transaction: begin tran a insert Table1 values('test') rollback tran a I get this error: Cannot roll back a. No transaction or savepoint of that name was found. How can I rollback Transaction a? Any help would be greatly appreciated. Rega...more >>

Ok, I need to start reading from the beginning of a table. 2 conditions: While reading, if an endingdate column is less than todays date and another columns value is "y" I need to copy data from one field to another. This must all be done from within vb.net. Any help is appreciated. Thanks, T...more >>

Hi I have a system where each member can only have 3 records in a table. When a new row is created for a member, I need to delete the oldest record first so that there are never more than 3 records for a member. How do I do this in TSQL? Thank, S ...more >>

Hiya, I have an error in this function It is supposed to remove any non-numeric characters. a value of 3v345 would come back as 3345. But why does it return a NULL if the first character is non-numeric? i.e. v3345 comes back NULL rather than 3345 thanks!! CREATE FUNCTION [dbo].[S...more >>

Is there a query I can run to display the contents/code of a certain stored procedure? Regards, Alex -- ...more >>

Hello All: I have been tasked to move a moderate sized application from oracle to sql server. Oracle has a sequence mechanism for generating unique numbers in sequence for record keys. Is there a mechanism like this for SQL SERVER? The identity column will not help me because i need the key a...more >>

Do I have a problem, a lock must occur and it isn't happening. Please, lets with the war against my marketing department ;). I have a problem with locking on sql server 2000 sp3. I select one record from a table using the primary key on the where clause, inside a transaction with serializabl...more >>

I need to get the current date as a varchar in the following format yymmddhhmmss What's is the quickest way to do this? Thanks S ...more >>

I have a Stored Procedure where I need to concatenate in order to build a Query, but it gets soo long... Up to 255 bytes, so, I need to know how to store a string like these. I have tried to use TEXT and NText but I can not use them on Stored Procedures. Please help me Carlos Lee ...more >>

Hello: I am trying to store C# decimal datatype values in SQL Server and seem to be having some difficulty. For example, if I set a a C# variable to 11.75M and attempt to persist that value to a decimal database field with a precision of 19 and scale of 2, the value is stored as 12 instead ...more >>

I have a problem with locking on sql server 2000 sp3. I select one record from a table using the primary key on the where clause, inside a transaction with serializable level. In another connection, I try to do a simple select * from sametable (also using serializable transaction level) and this ...more >>

Hello, I am having problems with the following trigger; CREATE TRIGGER [tr_Test] ON [dbo].[Test] AFTER UPDATE AS EXEC master..xp_CmdShell "C:\DB-2.vbs" What I am hoping to achieve here is executing DB-2.vbs after an update to the Test table. Currently this throws back an "invalid syn...more >>