Hi, I need to return any record that is not upper case in a column. e.g SELECT * from table1 WHERE col1 <> UPPER(Col1) or something along the lines of this Is there anyway I can do this? Thanks very much for any suggestions Ant...more >>

If I use an application role to manage permissions in an SQL Server database, the permissions acquired from the application role "remain in effect for the duration of the connection". In my VB6 application I plan to create a public ADO connection object once, then open and close it as needed...more >>

Here is my code that works with one column updating, but I just want to do the same thing, but with two columns updating: strSQLUPDATE = "UPDATE users SET default_billing = " + Class1.usersIDMaxID2.Trim() + " + quantity " + "WHERE id = '" + Class1.usersIDMaxID.Trim() + "' ...more >>

We have a big industrial automation system developed during many years using MSSQLServer, which we are very satisfied with. Good stuff! But now we have this big potential customer who has an IT policy in place that all databases in the organization *must* be Oracle based... We are now asked to...more >>

I have a server with four processors and I am running SQL 2005. When I run querries on the server and view process utilization, only one of the processor is being used. How can I direct SQL to use the other processors in running specific queries? Thanks...more >>

Hello, I am learning SQL Server 2005 (Express Edition). I have created a table and trigger on it. The problem is that primary key column is not recognized in the trigger (syntax error). Here's the table definition: CREATE TABLE [dbo].[Documents]( [DocumentNumber] [dbo].[DocumentNumber] NO...more >>

I just read this about clustering - see below. It might take five minutes or longer to restart an instance normally, so doesn't that take away a lot of the advantage of a cluster? Plus, isn't there the risk that if a significant transaction was going on, you'll have to do a rollback and reco...more >>

I have an UPDATE command that is giving me the wrong result. Can someone look at it and see what is wrong? If I do the math with a calculator it comes out correct. UPDATE dbo.RepairOrderTasks SET Cost = ROUND(((MinutesWorked / 60) * PayRate) * ((BurdenedRate / 100)+1),2) WHERE DateEnter...more >>

Hi where are the indexes stored in SQL SERVER 2000? In 2005, I this works but not in 2000 SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'dbo.TABLENAME') AND name = N'IndexName' Thanks ...more >>

I am using OPENQUERY() to update and insert records into an Oracle linked server. The inserts are very slow because they are committed one at a time and Oracle is rebuilding the primary key every time an insert occurs. The updates are satisfactory for the volumes as they are subsecond. I canno...more >>

This is more a design than a programming question, I guess, but I hope someone can shed some light on the subject for me. I understand how to localize forms when all the strings are in the res file, but what about when some strings are in a database. For instance, say you have a datagrid that ...more >>

What am i doing wrong below? declare @ClustersXML as varchar(500) DECLARE @hdoc INT -- handle to XML doc set @ClustersXML ='<clusters><cluster>500</cluster><cluster>400</cluster></clusters>' EXEC sp_xml_preparedocument @hdoc OUTPUT, @ClustersXML SELECT cluster FROM OPENXML (@hdoc, 'clus...more >>

Hello, I Built a stored procedure for searching records in different tables. It is used as recordsource of a ADODC-Control (first a recordset is created). The problem ist, that opening the sp in SQL-Server, I get the reords as I want - calling it from VB6 I get an Error if I try to move thro...more >>

I have a SQL report ... and all is fine. However there are some NULLs returned as expected. To make the report look better I would like the NULL to be replaced by " " or 0 .....how can this be done ? Regards Rob ...more >>

hey all, i'm using the GETDATE( ) function but I want to change the time to 12:00:00 AM. Can someone please show me the best way to do this? thanks, rodchar...more >>

I want to update the first 100 rows of a table that meet a certain criteria. update table1 set column1 = "sample" from (select top 100 from table1 where column1 = "test") this table has 500 records that meet the criteria, but I only want to update the first 100. update doesn't appear to...more >>

I have been try to get this to work with no luck. I have the following output from a query: Period Segment Region Prod_Line IND Element Obj Act 2007-08-01 EFB EFB PWR Warranty 85.7 0 2007-08-01 EFB EFB PWR Warranty ...more >>

Hi All, I am having a problem with WHERE statement. The SQL below will return only data with JobMain.Cust with 139 if the lines below it are commented out. The problem arises when the other lines are added .... I then get all CustIDs.... Please can you help ? SELECT JobMain.JobNo,Jo...more >>

Is it possible to add a contraint to a table that is being used in a view (WITH SCHEMABINDING) ALTER TABLE SWITCH statement failed. The table 'Table1' has view 'Table1' with schemabinding. [SQLSTATE 42000] (Error 4937). can you do this withought dropping and recreating the view? thanks ...more >>

I have a table that contains three fields (UserID, Question_Name, Answer) It has one record for each question answer combination that the user provides in a form. UserID - Decimal Question_Name - nvarchar(128) Answer - nvarchar(50) I would like to query this table to give me one record/ro...more >>

I have been battling this reports for a long time now and I can see the end (I hope). The reports are imported from an excel spreadsheet into a table (definition follows), and when I run a simple query I get the following results: PERIOD SCENARIO SEGMENT CPM Region Prod_Line Product Warra...more >>

I have a table that is highly used in select statements. It is used for selecting 24/7 but I need to insert data on a regular basis 5 to 10 a day in large chunks 18,000 to 200,000 records. To keep the select fast I am removing records that are a month old because they are not relevent any mor...more >>

I want know which user last updated an arbitrary record of an arbitrary table. Is there any way? ...more >>

I have a table named myTable. It is sorted by some column and there is no primery key or unique column.I want to retrieve all records from 30th record to 50th record. How can I do this by a sql statement? ...more >>

I develop full-time using SQL Server 2005 Professional. I am about to start a new project for a client in which I'll be migrating a tiny tiny database from MS Access97 to SQL Server 2005 Express. My question: I don't want to install anything on my dev box that I don't have to... so can ...more >>

We have a "standard" system. Since it is a "standard" system the quality is very low. Now I need to do a join in that system.. Unfortunately the columns that the join is on is defined in one table as float, in the other table as nvarchar(30). What about - let sql server do the conversion...more >>

(Well, it's complex to me...) I have two tables; 1) People - which has a many-to-one relationship with 2) Family [People] has a PK[peo_personid] and a Foreign Key [peo_familyid] from the [family] table I'm trying to get a query output of one record per family, roughly as follows --Be...more >>

Hi All I am using SQL Server 2005 I need help with the following... I have a Table 'Productitems' and I want to return all columns and rows from the table where the 'Item' column is distinct The 'Item' column has many duplicates as the 'Subdescriptor' column differentiates the produc...more >>

Hello there I have database i need to delete as part of installation I can't do it because someone has made snapshot on it How can i remove the snapshots ...more >>