HI How can I retrieve only one row that has duplicates on not all columns? For example a table Company could look like this. Id Zip Address Revenue ---------------------------------------------------------- ------ 1 1 Street 1 1 000 000 2 2 Street 2 2 000 000 3 3 Street 3 3 000...more >>

All Is there any way of taking only few tables in Database? I have tried with Filegroups...but its failing ... If i use DTS can i restore properly when i need? Will it maintains any Log information automatically? If anyone having script for Filegroup backup please send it to me.. ...more >>

Hi I've been working with a really slow cursor to traverse the adjacency list hierarchy I'm stuck working with. Been playing round with some code based on the books online example and have been getting the desired results and quickly. Unfortunately the example which I cut off this newsgroup...more >>

Hi all I remember there is a SQL stored procedure which shows all the table informations like rows, reserved size ,data size, etc.. If i use sp_spaceused 'Tablename' stored procedure it displays only one table information. I want to see all the table information in a Database. Anyone c...more >>

Hi, I use Foxpro as front end and SQL server as back end to develope my application. Is it possible to have simplified chinese input (base on simplified chinese OS) and traditional chinese output (base on traditional chinese OS)?? Please advise. Yan...more >>

Hi, Basically, I have a varchar column called 'code' which I have set to be the primary key. I need to match a user input string against this code. It must match if the users string 'starts with' the code. I am using PATINDEX() in a where clause for one of my stored procs. The problem ...more >>

Hi, My environment is W2K Server, SQL2000 Standard. I have this scenario and would like to know if it can be done. If so, how? Server 1: ====== XYZ database -- contains 2000 and 2001 data and various users' tables. Server 2: ====== XYZ database -- contains just 2002 data. The ...more >>

I'm trying to understand locking behavior at read committed. From what I read, during a select at read committed (a select that reads lots of rows), locks are released after the row or page is read, therefore locks should be held for a short amount of time. However, in some tests I run, I see...more >>

Cannot seem to follow this definition from BOL about updlock "Use update locks instead of shared locks while reading a table, and hold locks until the end of the statement or transaction. UPDLOCK has the advantage of allowing you to read data (without blocking other readers) and update it late...more >>

I have a stored proc that deletes some records from a table based upon a date criteria... I have also set rowcount to 5000 so it can delete 5000 rows at a given time in a loop and minimise blocking But when i look at sp_lock for that spid, it returns around 700000 rows at times or more with a k...more >>

I am trying to make a stored procedure that will bring back the events that were schedulled on that day and 3 days after that day. I am running into questions how to handle reocurance. So lets say an event started today and the event will be there every first sunday of the month. And also another...more >>

Hello there One of the adventage of sql server is that it delete the related records on other table when i delete record from one table Is there a way to aleart the user about deleting record only if another records from other tables will be deleted? any help would be useful ...more >>

I have 2 tables, Order and Payment. For each order customer can pay partially several times. Let's say the Total of Order with OrderID=1 and CustomerID=1 is $1000 . Customer with ID=1 pays $300 with the first check, new record in Payment table is created and contains OrderID, CheckID, CustomerID...more >>

I have a table named "MYADDRESS". One of the columns "PHONE" stores the phone number in the following format: (999) 999-9999. That means (1) one left bracket (2) one right bracket (3) one white space (4) one hyphen. The table stored more than 1000 records. I want to remove both the brackets, whi...more >>

Hello: I have a database that generates a text file that I need to convert to an SQL Table. The data in the text file is delimited by an "=" sign. A sample of the data appears below: AccidentIndicator=N AgingDate=2003-06-22 AtDestDate=2003-06-22 AtDestTime=23:09:15 AtSceneDate=200...more >>

Hi SQL Gurus, I have an FK that should only be applied on certain condition based on a value in a Column e.g : > > Create Table Orders > > (OrderNo Int Identity Primary Key, > > DocType int, --can be 1 or 2t > > DelStatus Char(1)) FK should only be applied if DocType = 1. Can I use...more >>

Hi All I have to take table level backup in SQL 2000 using filegroups. Everything working fine except Restore. i'm performing BACKUP operation using the following syntex --Backup BACKUP DATABASE TEST_BACKUP FILEGROUP = 'Raghu_Test' TO DISK = 'c:\dele\FGRaghu.bak' GO BACKUP LOG TEST...more >>