Greetings, Very simply, I don't wanna SELECT TOP 20 percent of a resultset, nor do i wanna to SELECT TOP 40 percent, but I want to SELECT records BETWEEN TOP 20 and TOP 40 percent....possible without having to loop? SQL 2000 Platform Thanks in Advance, Don *** Sent via Developersdex ...more >>

Hi, Using SQL Server 2000 on Win2003 I've got a table like this Models ModelID int identity pk Model varchar(50) In a stored procedure I need to retrieve the modelid given a model. The problem is that sometimes the input to the sp will match an existing model but the words will be in a...more >>

Can anyone tell me what is wrong with the following syntax? CASE {Invoicing Transaction Amounts History:Item Number} WHEN like 'GP%' THEN {Invoicing Transaction Amounts History:Extended Price} ELSE 0 END ...more >>

Hello, I have three tables : a, b and c. In each one, i have three same columns let say col1,col2,col3. I want to concatenante the tree tables : SELECT a.*,b.*,c.* into d FROM a,b,c where a.col1=b.col1 and a.col2=b.col2 and a.col3=b.col3 and a.col1=c.col1 and a.col2=c.col2 and a.col3=c.col3...more >>

Hi, In my stored procedures I make selections based on a 'combined' key. I.e.: WHERE [Postcode] = @PostCode AND [No] = @No 1) When there are less [No]'s is it then smart to select first the [No] and then [PostCode]? I.e.: WHERE [No] = @No AND [Postcode] = @PostCode 2) How do I make th...more >>

In my SQL app, I am converting a varchar(max) type, passed to a stored procedure, to an XML data type in the stored proc. I've noticed that if the contents of the varchar(max) string contains illegal XML characters (such as '&'), the conversion will fail. This doesn't surprise me, and I wou...more >>

I am looking at reusing the results of a first query in a second select statement. I have a first table "ACTIVE_FIELDS" in which I maintain the columns I want to query. Table name ACTIVE_FIELDS ----------------------------------------- Field - Status ----------------------------------...more >>

I have some legacy VB6 code that uses DAO (Microsoft DAO 3.6) to access an access 2000 database. In this app, Access is used soley for data storage - there is no UI component. I have converted the database to SQL Server 2005. Can I use DAO to access the new SQL Server database, or must I change ...more >>

using sql server 2k I think I already know the answer, but ... Is there anyway to use WRITETEXT or UPDATETEXT in a set operation like the following which, of course, doesn't work. update dbo.mytbl set txtcol = WRITETEXT dbo.mytbl.txtcol TEXTPTR(txtcol) 'some new text for colID' + cast(...more >>

Hi, I'm using SQL Server 2000 and I want to implement row-level security. I have two groups. Group 1 may access all rows but group 2 may only access certain rows. I created a view for each group. In my application, what's a good way to know which view to use based on the user? Should I try ...more >>

I have a datetime field which could be... '2006-08-18 01:00:00' or '2006-08-18 03:12:45' or '2006-08-18 14:67:23' Does anyone know of a SQL Server datetime function or combination of SQL Server datetime functions which I could run which would always convert any of the above functions ...more >>

Hello, How do I check the whole information on a table about the indexes. For instance we have Vehicle and Manufacturer tables and want to make sure that the ManufacutereID FK in Vehicle in tied to ManufacturerID (PK of Manufacturer) or to some other table that has ManufacturerID. is tha...more >>

Hi all, Looks like I inherited a little collation problem, and it's causing me headaches. This is a little involved, so please bear with me: Most of the CHAR and VARCHAR columns in the tables of this database are set to SQL_Latin1_General_CP1_CI_AS collation. A few are set to SQL_Latin...more >>

I highlighted partial sql statement and ran it. However, I forgot which part I highlighted. Anyway to show the full sql statement I executed? The activity monitor just shows partial sql statement....more >>

Hi, I am running sql server 2000 (8.00.2039 (sp4)) on XP Professional. when I try to create the trigger on one of the table I am getting following error. Server: Msg 311, Level 16, State 1, Procedure drugm_udpate, Line 16 Cannot use text, ntext, or image columns in the 'inserted' and 'dele...more >>

I can't remember or find the function that returns a MOD value. Can someone let me know what it is? Thx....more >>

I've got flat files (for Sql Server 2000) that have control characters in them. I need to bcp and DTS them into various tables but the control characters are screwing it up. How can I filter them out?...more >>

Hi there, I have an Access database, which contains the details of company staff and services. The plan is to extract data from this database onto our forthcoming Intranet (no inserting, updating or deleting at this point). The Intranet itself has been created in ASP.NET, using Microsoft Vi...more >>

At which moment SQL creates a dependency with tables ? is it whenevr you reference the table in the SP (insert or update or delete statm.......) or it is something else I have a table where I see some SP when I do Show dependencies but not others. thanks for your help...more >>

I'm trying to figure out how to return just 'Job Requests' that have failed. This gives me just the jobs that fail: SELECT Site FROM JobQueue WHERE Success = 0 However, if another job from the same Site comes in and it's successful then an entry will exist in this table for Success = 1. ...more >>

hello can somebody please tell me what selection i have to make in order to have a collation "SQL_Latin1_General_CP1_CI_AS" as a default servercollation while installing SQL server? someone installed our produciton server and "forgot" what he selected while installing the server. Now i have...more >>

i'm having 2 master table named soft-skills,Fields in which we have to enter the valid data that too manually.If i add the soft skills to soft skill table then the value has to be added to the Field table too,i'm using triggers to do the procedure. but thetre is one problem prevailing while i...more >>

Hi, I am faced with a situation where i need to write the output of a stored procedure to a text file. Well, i am writing a procedure that generates the script for triggers, i want these scripts to be written to a text file. Please suggest how do we do this and if possible also give an examp...more >>

This doesen't work: EXEC(' SELECT * FROM OPENQUERY(ORA1, '' SELECT * FROM ORA_TAB1 WHERE PERSNAME LIKE "%' + @var + '%" '' ) ') (@var is the SQL Variable) because "%' + @var + '%" is already encapsulated within quotation. So my question is - how to I get...more >>

Hi All, I have a couple of stored procedures written in SQL 2000. Given below one sp. ***************************************************** ALTER PROCEDURE [dbo].[usp_PC_AcTypeMInsert] ( @AcTypeName varchar(50), @GLCode varchar(50), @ErrorCode int output ) AS SET NOCOUNT OFF; BEGI...more >>

Hi, I need some help with writing the T-SQL script to select parent records which do not have a child record with a certain condition. In my example below, I need to write script to select all the Companies which do not have a VP. In my example, I need the SQL to return records "Widgets" and "ABC...more >>

I have a field where different formulas are saved in a varchar field. for example: 143*23*33 Qty*Rate/100 Qty*Amount/100 Is there any function in Sql Server 2000 or Sql Server 2005 which can calculate this string. Best Regards, Luqman ...more >>

I have a table like this (uniqcode is the primary key): uniqcode name -------- ---- 1 bb 2 aa 3 aa 4 dd 5 cc How could I create the following table out of the above one? row_num name uniqcode ------- ---- -------- 1 aa ...more >>

Hi all, I'm trying to create my first http endpoint using the code below. CREATE ENDPOINT EndTask STATE=STARTED AS HTTP ( SITE= 'MARIA2/SQLSERVER2005', PATH='/sql', AUTHENTICATION = (INTEGRATED), PORTS= (CLEAR) ) FOR SOAP ( WEBMETHOD 'GetAllEndPoints' ( NAME= '[MARIA2/SQLSERVER200...more >>

Hi, How do I set an alias when using SubQueris with an update. i.e. update test as t set t.Val1 = @Total*(Select Factor from #Temp1 as t2 where t.Cell = t2.Cell) where t.id = @id The alias t is not valid. How is this done? Thanks Totto ...more >>

Hello! I have performance problems with one of my tables and Do not know what to do to make it faster. Tabel is like this (table holds about 2 000 000 records): CREATE TABLE [dbo].[Sivunlataukset_kuukausittain] ( [id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [pvmaika] [datet...more >>