In my proceudre, I declared two cursors. How can I send the output from the 1st cursor to the 2nd cursor? Please advise. Thanks....more >>

I am using SQL Server 7.0 with Windows Server 2000. The Server have dual Intel Xeon and RAM 2 GB. The database only one with the size 2,826 GB. The database have 17 tables, 2 of them have big records : - Table A have 2,899 million records with 23 fields and the total length per record is 203 ...more >>

Is it possible to make a join which uses 2 subselects? The 2 subselects have both a field with the same name. When i try to do this i get syntaxerrors. Thx Frederik ...more >>

I've been working my butt off (if it were only that easy grin) to get this result CompanyID | Name1 | Name2 8 | Sandy Dise | John Smith 9 | Dan Higgins | Peggy Cullen from a table like this id | companyid | name 1 | 8 | Sandy ...more >>

Hi there I'd like to use IN with a variable, something like this.. SET @variable = 'smith,doe,baker SELECT FROM test_tabl WHERE names IN (@variable ....where @variable is of type VARCHAR and holds a comma-deliminated list of names Is this possible Cheers :)...more >>

Cross Posted =3D 3 All - I have a SQL statement that I used in access and VB.Net to display = as a pivot table and a chart on a VB form. I am now in the process of = changing it all over to SQL data adapters. I cannot seem to get the = Access statement to covert over to SQL. I get an err...more >>

Hi all, This works fine to get the age. I would also like how many months,days, minutes, seconds as well? declare @dob datetime set @dob = '5-19-1939' select datediff(year,@dob,getdate()) - case when 100*month(getdate())+day(getdate()) < 100*month(@dob)+day(@dob) ...more >>

Hello all, I posted several minutes ago about a select that I wanted to do on three tables. I have another request which is a variation on my last post. Let me give the table definitions once more: Table1 fields: -------------- Number1 int Sample data: ------------ (1) (2) (3) (4)...more >>

Hi, I pass the following varchar value into a stored proc '1,3,4,6,7,9,12,30' Within the storeproc, what I want to do is to insert each of these values into a table, using insert statements with this logic Do utill noMoreValues GetTHeSingleValue = (what ever the next value would be, s...more >>

Hi All I have some stored procedures the uses a temp table to calculate the result of reports. On one of my customers a was faced with the following problem The result of the reports started to produce different results every time I execute the procedures, after hours of investigation I tries to...more >>

I am trying to use as a guide an example in the VBNET Developer's Guide by McManus and Kinsman (ch 10,) on Subclassing Existing Server Controls. Rather than create a User Control (ascx) or a Composite Control, I want to make a simple extension to the CheckBoxList control class using inherita...more >>

Hello all, First of all, let me give the defintion of the tables I want to get information from: Table1 fields: Number1 int Sample data: (1) (2) (3) (4) (5) (6) Table2 fields: Number2 int Name2 varchar Sample data: (1, 'Jasmine') (1, 'Julie') (2, 'Jane') (2, 'J...more >>

Hi all, I been working on this problem for the past 3 days now to no avail and its getting rather frustrating. I have created a standard VB6 COM+ dll that has a public method Public Sub GenerateHUPXML(intJobID As Integer, blnValidateOfferCaps As Boolean, blnNotify As Bool...more >>

Hello I need to create table with a lot of columns of varchar(255) type for example create table TempTable ( col1 varchar(255), col2 varchar(255), col3 varchar(255), col4... col5... ... col200 ) i know the Sql Server have problem with this table , because is...more >>

I have a number of stored procedures that are running on my development machine. When I take those same procedure to a clients machine I get syntactical errors. Actually not syntax but my table names are in lower case and I must change them to upper case to work as in the following: SEL...more >>

Hello I have three tables Accounts , Subaccounts, People wit Accounts one to many to Subaccount Subaccounts one to many to Peopl and I have a quer -------------------------------------------------------------- declare @SubaccountID in set @SubaccountID = Select A.AccountID, A.AccountNam...more >>

Hi, I normally use crystal reporting as a front end to sql but am having a problem getting my head around the following. We have a report which shows certain customers sales and orders with all other customers grouped as others. I have set up a table which contains the list of relevant c...more >>

Is there and ODS call or parameter for srv_pfield or srv_pfieldex that will return the version of the SQL Server? Tom ...more >>