Hi all, I am dealing with a very large database, and as soon as a record is submitted I need to run a full-text query against it (the new record). I believe it might take a while before the record is fully indexed and therefore would not return a result. How can I check whether the rec...more >>

I have a table which looks like this: table1: Id col1 col2 col3 1 a b c 2 d e 3 f g 4 h Which I can convert to this: old_Id new_col 1 a 1 b 1 c 2 d 2 e 3 f 3 g 4 ...more >>

Hi, I have a table, after i query the table for displaying, several column names will be changed based on the condition, but I don't want change the acutal table column names, it will only be changed when displaying. I tried CTE and virtual table with column aliases, but they doesn't work, t...more >>

anybody have a better solution than what I have? Sql Server 2005 I have a list of Employees. Each Employee is in 1 Dept. (this is just a mock up to show what i need) I have now: (empid, deptid , artificialgroupingid) 1011 555 NULL 1012 555 NULL 1013 555 NULL 1014 55...more >>

Are there any tools to help analyze SQL Profiler traces (.trc files or traces stored in a table) for SQL Server 2005? I believe there was a tool called something like read80trace for SQL Server 2000. I want to "normalize" query text, and find the heavy hitting queries interms CPU, memory...more >>

How do I fix the following query? SELECT * FROM OPENQUERY(LNKsvr, 'SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY CatID, CatType) AS rownum, CatID, CatType FROM Category) AS D WHERE rownum between 11 and 15') ERROR: OLE DB provider "MSDAORA" for linked server "LNKsvr" returned...more >>

I am trying to convert seconds to minutes. for instance 103 seconds, I try 103 / 60 but I get 1.71. I need to get 1 minute and 43 seconds. Any help will be greatly appreciated! -- CipherTeKST MCSE: Security 2003, CCNA, Security+...more >>

Hi All, I have a query that will JOIN tables in different databases within the same SQL server. However, what if a different SQL Server is registered and I need to JOIN into a table on that server. Here's what I have: SELECT * FROM sourcedb.dbo.tablename srcdb WHERE srcdb.column_name N...more >>

How can I get the absolute time diff between to records regardless of weather it is negative or not. in other words I am looking for column absdiff below. time1 time2 diff absdiff 12:01 12:03 2 2 12:04 12:01 -3 3 ...more >>

Is there a way to in SQL to sort outline numbers to retain the "natural order" state? E.g.: 1.1 1.2 1.3 1.10 Shows up now as: 1.1 1.10 1.2 1.3 Is there any way to use recursive functionality to check for longer outline numbers (i.e., like 1.1.1.1.1)? -J ...more >>

Hi, I have a question regarding an "update from" statement performance issue, the "update from" statement normally updates around 4 or 5 millions of rows, this process has been always lasted around 4-7 mins (for around a year), but last days we have been having delays due to this update statem...more >>

This is actually a more advanced data structure than category/sub-category, but I'm not sure of the nomenclature. For a many-to-many data-structure that includes a join table, for example : ServiceTypeEnum table ServiceId ServiceName (ex: FoodAndBeverage , Lodging , Concierge , Valet, Mis...more >>

hello!! quick question.. i need to do a sub select based on a param and wanted to know how to do that... I want to do something like this... -- @paramID i have this.. SELECT x, y, z FROM myTable WHERE ( CASE WHEN @paramID IS NULL THEN x NOT IN...more >>

According to BOL, coalesce returns the first non-null value in a column CREATE TABLE #tmp2(fld1 varchar(10), fld2 int, fld3 int) INSERT INTO #tmp2(fld1, fld2) Values('a',1) INSERT INTO #tmp2(fld1, fld2) Values('b',1) INSERT INTO #tmp2(fld1, fld2) Values('c',1) INSERT INTO #tmp2(fld1, fld2) ...more >>

Hello All, This is driving me crazy and I would appreciate some help. I am trying to transfer some data from one database to another database with the same schema. I have done this before with BCP but have no idea why this is happening now. The table I am trying to copy has the follow defin...more >>

hey all, like i said i'm creating a new user for my database and i was just wondering why there is User name and Login? what's the difference? and it its applications? thanks, rodchar...more >>

hello, i have one table that contains the following records(2 FIELDS). id $ 1 10 2 20 3 25 the second table contains all tax information id $ tax 1 2 state 1 3 ferderal 2 3.5 state 2 5 federal i would like to display the...more >>

Hi im new to this group and sql server 2005 too Im trying to use sql 2005 reporting services. Im trying to create a report and send this report in mail in any format like for example in excel or word format.. but i dont know how to start and how to do this.. I would be glad if any one help m...more >>

hey all, is there a quick way to get a glance of the differences of a stored procedure in one database and the same stored procedure on another database? thanks, rodchar...more >>

Assume a database has been fully backed up to a disk file and that the disk file is automatically passed on to another server that has a job running that will restore it to a copy of that database. (I know there are probably more sophisticated ways to do this but this is what the boss wants f...more >>

Hi Friends, Need your assistance. I have few queries which i run every month which generates reports of previous months transactions. I just change the dates manually ( like BeginDate='2007-03-01 00:00:000 and EndDate='2007-03-31 23:59:59' for March 2007) and run the query manually . ...more >>

I'm not really a DBA but I've been told to setup an automatic database restore on a server. For the most part this is simple (Restore Database blahblah from Disk = 'file name') What appears to be a problem is databases with physical files in non-standard locations (Navision for example, mu...more >>

I have a situation where a use can search for some items in my database using one or more fields on a screen. I would like the search to execute through a stored procedure versus dynamic SQL passed in from the program or dynamic SQL built in the stored procedure and executed. My problem is thi...more >>

I have 2 sprocs GALAXY & STAR GALAXY returns a resultset based on a query where the calling tables are on linked servers STAR runs on the same server as GALAXY and attempts to insert the resultset of GALAXY into a #temp table I get this error: MSDTC on server '---' is unavailable eg. ...more >>

I am writing a stored procedure to try to pull out specific text from a trigger. I am using the code displayed below in order to try to selectively pull out text from the trigger. My over all hope is to create a front end with VS that will allow the end user to replace the specific area with...more >>

Hi, Which one is better to use in a stored procedure? To narrow scope: return number of row in a table. Both methods may be used with the same effect so, what is the best practice when returning scalar values from a SP? Thanks...more >>

Consider the following three tables: CREATE TABLE PersonInfo ( ID INTEGER NOT NULL PRIMARY KEY) ; CREATE TABLE Earns ( ID INTEGER NOT NULL PRIMARY KEY REFERENCES PersonInfo) ; CREATE TABLE SalaryUnknown ( ID INTEGER NOT NULL PRIMARY KEY REFERENCES PersonInfo) ; CREATE TABLE Unsal...more >>

Hello, We are experiencing problems with SQL Server (seen on 2000 and 2005) when it starts up and enters the recovery process. If the server has numerous databses it can take a significant amount of time for the recovery process to complete. When the recovery process is running the SQL Serv...more >>

Hi How do you resolve this DECLARE @Name VARCHAR(20) SET @Name = 'NewColumn' SELECT column1, CASE WHEN Column2 = 2 THEN 3 AS @Name the above Statement gives an erroR AT @Name any work around for the above select statement? Thanks ...more >>

I have a stored procedure that is doing a select on some tables and returns the results to a device. I need to update a column after I do a select and the data is returned. so for example: select Id, downloaded, name, from custSales I need to then update the download column to True afte...more >>

SQL 2005 SP2 (9.0.3054) Once a month, I am being asked to dupicate our live production system over to a test environment. I thought I would make my life easier and make a stored procedure to do it for me. The production system includes an SQL DB and some other files on the server that I...more >>

I am using sql Server 2000 and writing a stored procedure for adding a record. I have a question on the date format. If I enter the date in the UK Format dd/MM/yy it complains because it needs it in us format, is there a way I can specify the format in the stored procedure ? ALTER PROCED...more >>

Hi, I have an existing query which returns a row of data per customer. I need to add the phone numbers that are stored in another table with a one ot many relationship on the cust ID. I want to incorporate all of the phone numbers and their type into a string that is an additional field in the...more >>

I've encountered a customer has his sqlserver so locked down I can't do anything. SA account has been disabled and I can't login via windows authentication. The only user that can login has no rights to do anything. Is there any way around this? This is sql2005 and of course no one remembers ...more >>