Hi! Can it is possible to restore backup of a database from sql server 2005 to sql server 2000 or i need to use DTS for this transformayion. Regrads, Jami *** Sent via Developersdex http://www.developersdex.com ***...more >>

I sometimes find myself creating views based on views based on views to get a final result. I do this mostly because at times it's easier for me to follow the flow rather than to get too complex. But I know there are times when I could avoid this altogether. Some are obvious and I go back and cle...more >>

Hi, i'm implemeting kind of a queue in a table in SQL Server 2000. I read the oldest record in a table which Table.Locked = 0 and update it to Table.Locked = 1. The Store procedure is like: Select @id = id from Table where Locked = 0 order by date desc Update Table SET Locked = 1 where id ...more >>

I'm getting the message "changing any part of an object name could break scripts and stored procedures" when I issue sp_rename in sql script in SQL Server 2000. How can I suppess this message? Does this happen unconditionally? Thanks....more >>

I tried to import data from a SQL Server 2000 database in another machine to my machine. The data is about 3 gig in size. When copying the data, it failed with this error "[Microsoft][ODBC Sql Server Driver][SQL Server] UPDATE STATISTICS failed because the followint SET options have incorrect...more >>

I have been unable to do this query, perhaps an expert can help. I dragged too much and now client needs this urgently, like if they ever don't :) .. anyways, any help is greately appreciated. I am using MS SQL 2000, I have 3 tables. Table#1: Baskets 3 basketid int 4 0 0 basketname nvar...more >>

I often see people in here getting bent out of shape when posters use "select *" in their code. But I've noticed that it's common practice to do this: SELECT c1, c2, .. FROM SomeTable WHERE NOT EXISTS (SELECT * FROM SomeOtherTable WHERE....) Does SQL know not to actually return all the row...more >>

I am currently doing the follwoing to get a count of rows in the table "Items": SELECT COUNT(*) AS Total FROM Items WHERE ItemID IN (15,16,17,18,19,20,21,22,23,26) AND ItemID IN (SELECT ItemID FROM GnrtdItems WHERE InvcID IS NULL OR ProdPosted = 0) Items is a pretty small table (only a few...more >>

Hi Freinds, SQL2005 What type of access a user need to run sql profiler on 2005? in 2k user should be SA but in 2005 I know it is chaged , but can't find out what is the min server role requirement for that. thanks in advance, Pat ...more >>

I am trying to create a unique index on a column that can have nulls in it. I have "unique" checked and "ignore duplicate values" checked. However, when I execute the following SQL statement... "create unique index [idx_unq_UnitPrices] on [dbo].[UnitPrices] ([OptionCode]) with ignore_...more >>

I have a web developer that wants me to construct a table that will hold a battery of SQL queries that they can just access and execute at need, rather than storing the queries in views or procedures. To me, this sounds like a "very bad thing" - a slippery slope that leads to web developers...more >>

How do i find indexes of the columns of all the tables of the database.....most importantly in SQL server 2000 Thanks a lot ...more >>

Hi Guys, I remenber there is an undocument stored procedure about generating insert statements from script file. That uses for generate all insert statements from text data file. I forget that stored procedure's name. Can someone could tell me what it is? Thanks. ...more >>

Hello, I have a stored procedure that I just migrated to SQL 2005 from SQL 7. It has worked in previous verios of SQL, but does not work now. I have something like: insert into TableA (Account,OutstandingLedger select Account,OutstandingLedger=$0.0 from TableB where ... Account is va...more >>

I have a couple of questions with regards to inserting and updating a lot of information. I want to know the best possible ways. 1) I have a table with over 10 million records and I want to insert into it a million records from another table. Is there a better method than using the INSERT I...more >>

The select @S = @S + C from #T syntax is broken in 2005 (sometimes) when #T has > 1 row. This nasty bug is popping up in or code after upgrading from 2000 to 2005. I know BOL doesn't talk about this syntax, but it has always worked just fine in the past and it is used all over the place...more >>

Hello everyone, I'm going to copy all the tables from one database in one server to other database in another server. A couple of days later I will want to copy the new (and updated) records (from those couple of days) instead of copying everything again. Plus, those tables don't have da...more >>

I'm trying to come up with a query using an entity-attribute-value table. Sample data is listed below: Person Table PersonID PersonName -------- ---------- 1 Mary 2 Joe 3 Paul 4 John Fact Table PersonID Att...more >>

Is there a better way of doing record paging in SQL then: ALTER PROCEDURE dbo.fh_category_files ( @Category BigInt, @Index BigInt = 0, @Size BigInt = 20 ) AS SET NOCOUNT ON DECLARE @LowerBound BigInt DECLARE @UpperBound BigInt -- Calculate the page bounds SET @LowerBound = @I...more >>

All, I have a large database that has a basic order header, order detail structure (one to many) I'm looking for a query that will give me a count of each combination of part numbers in orders. In laymans terms: There were 100 orders that contained parts A, B, and C There were 45 orders tha...more >>

hi friends QUERY 1 ============= SELECT DISTINCT Products.SerialNo, Products.CompanyName, Products.CustomLab1, COUNT(TagList.TagNumber) AS InventoryCount FROM TagList, Products WHERE TagList.EPCCompanyCode = Products.EPCCompanyCode AND TagList.EPCItemCode = Products.EPCItemC...more >>

hi friends QUERY 1 ============= SELECT DISTINCT Products.SerialNo, Products.CompanyName, Products.CustomLab1, COUNT(TagList.TagNumber) AS InventoryCount FROM TagList, Products WHERE TagList.EPCCompanyCode = Products.EPCCompanyCode AND TagList.EPCItemCode = Products.EPCItemC...more >>

I have word documents that have signatures that I want to capture and place in a field so that I can query the table via a web form and place the signature on a web form when a certain name is chosen from a dropdownlist. I have tried to copy and paste into the field with datatype as image and...more >>

Hi, I have been wracking my brain on this for a while, I don't know if it is even possible! I have one table tblConnectionsLog that stores a history of connections to a monitor. The table structure is as follows: ESerial Port Channel Sensor fkSiteID Date Action SEG ...more >>

Hello. I have to select rows from a SQL table where a column is like about 20 values. Instead of doing "Where MyColumn Like '%Value1%' or MyColumn Like '%Value2%' or MyColumn Like '%Value3%' ...... or MyColumn Like '%Value20%'" is there a more efficient way to achieve the desired results? ...more >>

Hi, Is there a way to concatenate strings using group by? Like a SUM for strings... For example, I have: userId string 1 A 1 B 2 C I would like to group by userId to obtain this: userId string 1 A B 2 C I'm currently using a ...more >>

Using SS2000 SP4. We have some bad in a table that we're trying to find. There are basically two types of rows in the Communication table - rows that have been completed (isComplete=1) and those that are pending (isComplete=0). There should only be one row for each company that is pending (but...more >>

Howdy - - Does anyone know how a user can be granted permission to use OPENDATASOURCE without giving him "sa" role? - - Herb ...more >>

Summary: Effectively to acheive something along the lines of SELECT id1, (distinct id2), AccessCount1, AccessCount2, ..., or in other words, collapse column id2. Structure: I have a M-M Relationship between MenuItems and ContentItems, thus 3 tables, the mediator with fields CI_ID and MI_ID. ...more >>

Hi, I'm currently setting up a one to many set of tables. When I save a record, I am first saving the 'one' side of the data to the parent table, then the 'details' to the child table. I need to supply the child table a foreign key based on the primary key of the parent tbl. My problem i...more >>

Hello! Do this exists in SQL Server 2005? I want to write some code that depends on an session-variable... Best Regards Bjoern ...more >>

Hello all, I need to get the average on a number of fileds, but these fields are of type varchar. How would I do this? Thanks, Jon...more >>

Hi All, I have the following table (Bookid int, date datetime). I want to find all the durations (continuous days) for which the book is in table. The book can be in the table in seprate duration. e.g. (1234, jan-01-2006), (1234,jan-02-2006), (1234,jan-04-2006) is two durations since 02 and 0...more >>

Hi I have files being uploaded on a weekly basis and need to match 3 things, new records, deleted records and records which have changed from the previous week. Policy_live_t = contains previous weeks live records t_policy_new_v = contains this weeks load of refreshed records New recor...more >>

Hello Every body, I have an requirement where i have an employee table with their managers reported. Let me give you structure of the employee table Empno Empname Mgr 1 Srinivas 1 2 sampath 1 3 raju ...more >>

whats the best way to replace null or '01/01/1900' with '' on a select statement (SP) ? -mark ...more >>