trying to do something like a combination log. one table has numbers, in order, that people have entered. the second table has correct combinations. doesnt matter how many numbers are entered before or after the correct combination as long as its sequential. I've put some sample tables on a p...more >>

Hi, Is there an easy way to drop all foreign keys from a database? Thanks, Edgard L. Riba ...more >>

Hi, I have a client server application (VB, MSSQL 2000) which needs to be ported to use Dhivehi language for use in the Maldives. I have a few questions: 1. Does MS SQL Server 2000 support Dhivehi language? 2. If so, which is the collation name to be used? 3. On which version of Windows Server...more >>

Hi All, Does in SQL Server has any Datatype for %Type and %RowType Like ORACLE. Because If I declare a Cursor for a table which has 35 columns and If I need all columns in my cursor then I have declare 35 Variables. Is there any easiest way or %rowtype in SQL Server? Thanks Prabhat ...more >>

Is this is the preferred NG for Reporting Svc's? I have a system that conditionally prints about 600 differnt Word documents based on 600 templates. This addresses most the the business rules for initial response to most every scenario that could occur with a client. Many of these doc's a...more >>

Hello all, I am a newbie to sql. I created this Stored Procedure.... VERY SIMPLE Create Proc sp_TEST as return 100 go Then I used COM and ADO in C++ to call it and get the return value, which was 100. Then I added a Insert statement like this Alter Proc sp_TEST as I...more >>

Hi, I got a bad feeling about this..... Our application involves around 10 tables in sql server and records in them are all interrelated. The application goes through 2 phases, first phase is to validate the records in the database, and depending which record you start from you could end up g...more >>

I am writing a paper on the history and evolution of SQL Server and I'm having a hard time finding good resources that talk about the product from it's beginning at Sybase and over the years at Microsoft. Below are a list of links I have so far but I was hoping maybe some MVP's or Microsoft empl...more >>

I am trying to create some triggers for updates and deletes on a DB I am working on, but being new to SQL I am not confident in the language. I am developing a front-end app in ASP and want to audit when a users updates or deletes a record. I have created duplicate tables etc. and all I need...more >>

hi I'v simple warehouse, 2 table: T1: TRANSACTION: ID_TRANSACTION PART_NO QTY T2: ON_HAND PART_NO ON_HAND_QTY how to write trigger which update or sometime if needed do insert into ON_HAND table after insert,delete or update on TRANSACITON any Idea? Thx ...more >>

In building interfaces between applications there are certain steps which need to be kicked off from a normal user, looking for the best way to do this. For example we might have a DTS job that extracts data from SQL Server tables and puts the data in Oracle tables and then requires the user t...more >>

hi all i used this query : SELECT spid,status FROM master.dbo.sysprocesses WHERE dbid=DB_ID('dbname') to get the active conections . 1. 2 records: wheni use this qry i do get 2 spids in the query analyser,,,but i open only one connection with my client right ? 2. not closing...more >>

Hi, I am trying to insert a time in a table. I use a query like this: INSERT INTO MyTable (TheTime) VALUES('9:00 AM') TheTime is a datetime field. When the value gets inserted, it is inserted as 1/1/900 9:00. Is there any way to insert it without the date part? Later I want to do a...more >>

Hi If I get data from msde remotely (from another computer) should I have iis installed on computer with sql server.? Does connection should have static IP? Thanks Konrad ...more >>

I have a SP that reports on the current stock position. One part of the SP needs to use something like GetDate to return today's date, but I only want the date component from GetDate, not the time component. That is, I want GetDate to return 20040611 00:00:00 rather than 20040611 14:40:00... ...more >>

sql2k sp3 I want my trigger to fire off only when CancelledDate or CardActivationDate is updated. But it fires when notes column is updated as well. CREATE TABLE [dbo].[tmpTriggerTest] ( [tttId] [int] IDENTITY (1, 1) NOT NULL , [CancelledDate] [datetime] NULL , [CardActivationDate] [...more >>

I've seen several threads on this subject, but none which cover my particular question (however, feel free to redirect me if I am incorrect). I would like to write a query in SQL, where the field names included in the select statement are conditional. I will try to illustrate what I am trying...more >>

What's the best way to run an oracle stored procedure from a sql server stored procedure or DTS job? An example would be great! Thanks in advance, Mark ...more >>

Hi, What is a good approach to load data in tables for the following scenario. Copy stored proc, tables and table data from the development servers to production servers(Not Linked) 1.Proc -- Generate SQL Scripts 2.tables -- Generate SQL Scripts 3.table data ?? Want to avoid writing s...more >>

We have used a shareware program called bcpproject from Building Block Software Systems and have paid the $35.00 license fee. This was purchased in 1997. No one internally can find out what has happened to the folder with the key and we need to reinstall it. It seems that this company is now def...more >>

Hi all, I've already posted this question - but I did it through the msdn interface and the post seems to have been lost. I'll try giving the brief and VERY simplified version of what I previously wrote. I have two tables in my database. One table - let's call it animals has the attributes: ...more >>

I am attempting to retrieve XML data from a recordset. I am using ADO within an ASP page. I know the query string works, but I keep getting this error: The FOR XML clause is not allowed in a CURSOR statement. How would I not use cursors to navigate the data (ASP.NET is not an option.) ...more >>

I have a table create table temp_company ( cname char (31), id int (4), sym01 char (8), sym03 char (8), sym04 char (8), c_val char (10), s_val char (6) ) The table is given to extract data has the some duplicates values cname id sym01 sy...more >>

I have a question about association tables that I hope I can generalize. My application is for fire investigations and I have a Case table with information about fire date/time, etc. I have different entities that need to be associated with the case, like fire occupants and fire deaths and righ...more >>

On an application that will require programmatically importing files into specific tables, I initially created BCP Format files, and write a stored procedure that would basically call bulk insert using the file name passed in and the format file. Due to some other issues clustering and separating...more >>

Hi, I have a table valued function that returns a table. The function is called cf_BlindUsage and it takes three parameters (begindate, enddate and BuilderID). I want to use cursors to read through each record of the table, so I use something like: ----Begin DECLARE @Builder VARCHAR(50) D...more >>

Iam looking for generating Amort Schedule in SQL. Does any one has any idea where i can find tsql for it. Thanks!!! ...more >>

Is it possible to make a stored procedure running several action queries return a value in the rowsaffected property. I have some generalized VB code which can be asked to execute an SP or an action query. I would like it to be able to return to rowsaffected in both cases. Simplified, the cod...more >>

I am writing a stored procedure that will need to layout records that will be later placed in files. However, certain numeric values will need to be converted to the textual equivalent of BCD in the process. The actual algorithm for the conversion in VB looks like this: ' takes a string and co...more >>

I need to create a stored procedure which will return a set of rows from the set of tables. I have no problem with it. But I have a problem with returning as output parameters the SUM of one value. It' calculated value. I have fields PartialNumber, PartialSellingPrice, Salesman, Percent in diffe...more >>

I used to know how to do this but it's been several years and I've forgotten the nuances involved. I have a database with policies/standards data that I will need to keep historical reference on. Rather than keep archive tables because of the way the data will be referenced by outside sources...more >>

I am new to SQL Server 2000, coming from Access, VBA and ASP. My challenge is that I have a text file which is an ldap dump from a Unix machine. I have to take that text file into SQL Server and create a table of the data. The ldap file is a personnel listing. Each person entity starts and ends ...more >>

Hi, In TSql a query like Insert Into TableDestine Select * From TableSource will run inside a transaction. If TableSource is too big, it will block the system for long times and the transaction log will demand big resources from the hard disk in order to store all the info for rollin...more >>

Is it possible to drop a PRIMARY KEY constraint from a table, even if it (the constraint) has no name? eg: something like ALTER TABLE #MyTempTable DROP PRIMARY KEY Also... following from this, is it possible to check if a PK constraint exists on a table? See, I would like to put together a s...more >>

Is it possible to drop a PRIMARY KEY constraint from a table, even if it (the constraint) has no name? eg: something like ALTER TABLE #MyTempTable DROP PRIMARY KEY Also... following from this, is it possible to check if a PK constraint exists on a table? See, I would like to put together a s...more >>

Is it possible to drop a PRIMARY KEY constraint from a table, even if it (the constraint) has no name? eg: something like ALTER TABLE #MyTempTable DROP PRIMARY KEY Also... following from this, is it possible to check if a PK constraint exists on a table? See, I would like to put together a s...more >>

Is there a way to modify the SQL Output, from the SQL statement, in SQL Server? The reason for this question is because an application using SQL Server backend had a display problem and it was brought up that TSQL may have similar Output commands like PL/SQL does in Oracle. Oracle uses a serie...more >>

Hello. I am looking for help editing this stored procedure so it works correctly. Let me give you an idea of what i am trying to do. I have created a form with three drop down lists; One contains AccountID Numbers, and the other two contain the names of territories. The goal is to select a...more >>

I want to create a covering index for a query. The query would be something like 'select FirstName from CustomerMaster where LastName = 'XXXXX'. Now, the covering index would include the FirstName and LastName columns but does the order matter. Basically, should I put the predicate (LastName) as the...more >>

Hi all, I was wondering how to write a SQL query that inserts a record for every record in a different table. That is, if I have one table called animals (type, feet, domain) - type is a primary key: cat | claws | land dog | nails |land bird | talons | air and another table calle...more >>

I would like to put a small SQL server 2000 database on a server running server 2003 and access it from only about 3 computers in my office. I know VB 6.0 rather well but have heard I should use VB .Net . Is this trully necessary? Will I need to learn a whole lot to make the switch to VB ..N...more >>

I'm trying to create a relationship between two columns but am getting an error message. I'm pretty sure the problem is that there are different values from one column to the other. How can I compare the two columns but only show the items that don't exist in both thanks...more >>

I have a column in which the data contains a UNC path to documents. I have moved the documents and shares to another server, but the share names are the same. for example, the data that is currently like: \\Server1\Client\document.doc I need to replace the data so it references another ser...more >>

I have an interesting question as to why I am getting extreme performance loss when using a stored procedure versus simple inline SQL code. Here's the example I used for timing: In the Query Analyzer, I use the following code: declare @i int set @i = 0 while @i < 100 begin declare @u...more >>

I read a lot about cursors/non cursors, and why not to use them. Since I'm a C/VisualBasic/Perl/... programmer, for/while loops were 'in my blood'. Moved to SQL server programming i soon realised the benefits of SQL, and working on SETs. (Nowdays I seem to want everything to be programmed in SQL)...more >>

Does anyone know how to programmatically (from VB) retrieve the version of sql server that is running on a machine? The program will be installed directly on each client so it will only have to check locally. Is there and API that does this? ...more >>

I would prefer not to query the master database directly but I can't seem to find a sproc just to see if user login exists in the sysxlogins table. Does anyone know of such a sproc?...more >>

Is there a way to find out a size of an image sorted in SQL (2000) table? Thanks...more >>

Hello newsgroup, I have a problem quite specific to my project.The catch is, I can't use any of the database API's like ADO, VBscript etc.I need to alter data types in all my stored procedures and triggers using TSQL(~1000 in number) and then to execute them. But it's not only the parameter data ...more >>

Hi, I want to find out any windows service uptime(i.e - the amount of time the service has been running) Thanks Kota....more >>

What's the news on proper support for domains in SQL Server 2005 ? Is there any ? In SS2k, rules and user-defined types are deprecated in favour of CHECK constraints, but you can't can't define a check constraint once and use across multiple tables. Thanks, Andy Mackie....more >>

Hi, Can anyone know can't we call the function with in a function. Doesn't sql server allows calling the function with in a function. Means i am calling GetDate() function with in a user defined function, it is giving some error saying it is not valid to call getdate function within this...more >>

Hi Is there any extended sp that will put the msg in the private msmq ...more >>