I am doing customization for microsoft POS. I manually added a record to a table. The manage and maintenance of this table are done by POS, and user can update the contents of this table. Is there any way I can lock this single row at database level to prevent it from being deleted or changed b...more >>

I am trying to exclude all strings that has 'a' inside (I have simplified the actual problem) select 1 where 'bb b a dfg' like '%[^a]%' However, the above does not work. By the way, I can not use 'not like' such as: select 1 where 'bb b a dfg' not like '%a%' Although the above will work ...more >>

Here is my SQL statement SELECT a.name, b.meterno, c.meterstatus, d.accountno, d.creation_date FROM fmdata.location a, cisdata.service_meters b, cisdata.meter_master c, cisdata.Account_Master d WHERE a.location_id = b.location_id AND b.meterno IS NOT NULL AND b.meterno = c.meterno AND a....more >>

I am editing a pre-existing view. This view is already bringing data from 40+ tables so I am to modify it without screwing with anything else that is already in there. I need to (left) join it with a new table that lists deposits and the dates they are due. What I need is to print, for each ...more >>

Im trying to run a query that will pull distinct data not for the entire select query but for a single column. Here is my sql statement below. Why is it not working? It is probably something stupid. Thanks for your help in advance SELECT Count(MastrQualityTbl.[WORK NUMBER]) AS [TOTAL WORK RECE...more >>

Hello, i have a table and if a record is inserted i will test a numeric value in this table. If the this value is greather as 1 million, than an status column should be changed from 'A' to 'B'. Yes and sorry, this is a newbie question. On Oracle this work simple: create trigger myTrigg...more >>

Hello, In SQL Server 2005 Enterprise, I can change the CPU affinity via Management Studio. Is there a way that I can change these settings via t-sql? I wish to use all my cpu's at night when my data warehouse builds and then durning the day reduce the number of cpus for SQL so that the applica...more >>

Hello, few users have problems with our application (ADP/MsAcces2000+SqlServer2000). When they want to open a report which source is a stored procedure, they get message that "record source specified..... do not exist" - of course, it's not true. More details: - other users don't have this ...more >>

Hi there I have the following two tables mainprofile (profile varchar(20), description) accprofile (profile varchar(20), acct_type int) Sample data could be mainprofile ---------------- prof1 | profile one prof2 | profile two prof3 | profile three accprofile -------------- pr...more >>

I'm trying to run a simple update script on this database which is created from a replication agent. Several individual databases are replicated into one consolidated. I've not worked with replication before and I was hoping someone could tell me what this error means. UPDATE CUSTOMER S...more >>

Two Windows 2003 server, one with SQL 2005 server, another with SQL Express. Is it possible to copy databases from SQL 2005 to SQL Express? Thanks. ...more >>

Hi We have just migrated to SQL 2005 database. We backup up our SQL database to disk, then backup files to tape using BckupExec 10.1. The only snag is that BackupExec uses MSDE2000 to manage jobs etc so it will want to install a MSDE2000 on the server that has SQL 2005 on it !! Back...more >>

Hi All My query is as follows: SELECT STRINGTEXT, TOKENID FROM WEBSTRINGS WHERE TOKENID IN (6,20,234,19,32,4,800,177) All I want is my resultset to come back in the order that I have defined in the IN clause, but unfortunately SQL is trying to be too helpful and sorts the numbers in the...more >>

when i try to create a new database i get a error: The server could not load DCOM what is wrong and how can i fix it? i have updated mssql/win 2003 with the lates updates Rgds Bobby ...more >>

Hi, We are about to move to SQL Server 2000, as we already have a licenced copy of it. However, as i understand it you licence by the number of users (where else can i find out what the options are with it). The big question is: We want it to run two seperate databases, we dont want the admin...more >>

Hi, Is it possible to connect to SQL Server using trusted connection from unix? If yes, I'd like to know how. Regards, Thyagu. ...more >>

select left('Hello World /Ok',charindex('/','Hello World /Ok')-1) Hello World That works fine. However I got an error message: select left('Hello World Ok',charindex('/','Hello World Ok')-1) Instead of: 'Hello World Ok' I get: Server: Msg 536, Level 16, State 3, Line 1 Invalid length pa...more >>

Can someone tell me sql query for filtering date field for current day, not last 24hours but from 00:00 to current time? ...more >>

Dear Memebers, I have a critical problem. I have an application is running on 64 bit machine. It used to be running on 32 bit machine. That application is using a Stored Procedure that uses SELECT, INSERT, UPDATE statements. Whenever this applicataion is being run all the processes are locked ...more >>

I'm taking a .NET class and I have SQL Server 2005 installed on my machine. When I go into Studio and then select Server Explorer and try to add a new Connection, it seems to bomb out when I type in 'localhost' for the server name. It doesn't come back with anything for the DBS. Is there some...more >>

I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine without any issues and all of a sudden, i noticed in my repication monitor tab under Publisher where I usually see the publication is empty now....more >>

I need tyo move tables from Oracle 9.2 or 10.2 version to SQL server 2005. Can any one give me some good hints, scripts etc. I try to look into the Business Intellegent Studio, but I only see Report, Analaysis or Integration services - NO DTS. Can someone tell me where to find it. It used ...more >>

Hello everyone: i am trying to compare a MAX(DATE) from one table that would be greater than a date in another. first_table compname MYDATE abc comp 2006-09-26 09:19:43.250 123inc 2006-10-20 01:3:00.250 SELECT MAX(MYDATE) FROM first_table log_table logdate ...more >>

Hi, I have a datetime column named dtDateTime. its format is "Oct 27 2006 12:00:00 " I want to group by only date part of it and count my code is $sql1="SELECT convert(varchar,J1708Data.dtDateTime,120), count(convert(varchar,J1708Data.dtDateTime,120)) FROM Vehicle INNER JOIN J1708Dat...more >>

I am sorry, I am posting this message again, since I did not get any reply. I want to export a table into a "fixed width" file using SQL 2005 import export wizard. This is the version I have: SQL Server 2005 - 9.00.2047.00 For some reason it joins all the rows together. For EX: if t...more >>

Hi, I have a tricky SQL query problem that I'm having probs with. I have a table which resembles something like this Date | Price1 | Price2 | Price3 01 Jan 2006 | 100 | 100 | 100 02 Jan 2006 | 100 | 100 | 100 03 Jan 2006 | 100 | 100 | 100 04 Jan 2006 | 115 | 100 | 100 05 Jan 2006 | 115...more >>

what is the difference between a Stored Procedure and a Function? tia, mcnewsxp ...more >>

Hi, Database Server running slow. I used SP_WHO2 ACTIVE and the result has many of XXXX SA RUNNABLE MASTER AWAITING COMMAND.......... (XXXX is spid) and they stay for couples seconds. Last week , the server was run...more >>

I have a need to create a database, and then populate it. However, the code below doesn't work as I hoped it might (it creates the table in the "master" database, which is Not A Good Thing). I know already (thanks Tony!) that if you use Dynamic SQL for the USE command, then the subsequent oper...more >>