Hi there. This is not my 1st post related with performance. I am experiencing serious performance problems with a VB6 application running over a SQL Server 2000 database. I have already used SQL Analyser, SQL Profiler and Performance Monitor to collect data that might help resolve this prob...more >>

Hi EveryBody, Here is a very interesting SQL which I failed to solve. I have two tables called Main and Notes.Table notes has id field which is primary key of the Main table and foreign key in notes table. Notes table has an identity column called NotesId. What I have to do is that I have...more >>

I can not get this query to work right it returns the records for the dates 03/19/2005 and 03/20/2005 but not 03/21/2005. Could this have any thing to do with my SQL Server collation set? My collation set is SQL_Latin1_General_CP850_CI_AS. Please help SELECT INV_PRICE_HEADER.cust_id, ...more >>

I have the following syntax Sum([SalesQty1]+[SalesQty2]+[SalesQty3]+[SalesQty4]+[SalesQty5]+[SalesQty6]+[SalesQty7]+[SalesQty8]+[SalesQty9]+[SalesQty10]+[SalesQty11]+[SalesQty12]) AS YrSales This works fine if none of the fields are NULL How can I cater for the scenario where anyone of the ...more >>

Hi, I have a query that returns a detailed resultset but I need to create a summary of it as follows: ResultSet of Detail: -------------------- ColA ColB ColC ColD 1 Email A User1 2 Email A User1 3 Phone A User2 4 Phone A User2 5 Phone B...more >>

hi, How to get last (maximum) date of a month through sql query. ex: if 31st is the last date of a month then i should get 31(dd) or 31/03/2005(dd/mm/yyyy) format or 20050331 (yyyymmdd) format. Thanks, hari. ...more >>

Is it possible to do this all in one stored procedure? I have 3 separate queries which returns all the correct records with Stockcode being the field to join Q1 is my main query from which I want to return all the records. Q2 and Q3 return records but not every record in Query1 will have re...more >>

Hi Gurus, Is there any automated way to compare the contents of TWO rows in the same table of SQL Server ? Thanks in advance. Regards, Yog...more >>

Hi, I want to return records based on a linetype and classtype Here is what I have so far Where (LineType = '1' OR LineType = '7') or (LineType = '5'AND ClassType NOT LIKE '[_]%') I am trying to return all LineType 1 and 7 and only LineType 5 where the classtype does not start with an u...more >>

I am trying to create a record number. Don't ask why LOL. Below are the items I need in my record number. Here is the format I'm looking for. I am also having problems trying to get it to display zeros before numbers such as 1. Ex. 1 should be 01. This would be stored in a text field. ...more >>

I have a question that I haven't been able to find an answer to in either the help files or Technet/MSDN searches. First a little background. I have a number of SPs that pull the same basic data but manipulate it in different ways (e.g. some add address information for targeted mailing lists, ...more >>

Hi, I need to run a query that does the following: A table exists as such: ID (Number) Letter (VarChar) Status (VarChar) Value (int) "ID" is the unique identifier for this table. "Letter" is A, B, C, D, etc... "Status" is Open or Closed and "Value" is a number. There can be mult...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Hi I am using Mssql2000 and i am facing a problem while saving data from my application. This Procedure is working fine. CREATE PROCEDURE test(@edate datetime,@supp_idv char (8),@div char(2),@dept char(3)) AS CREATE table #oi(supp_id char(8),inv_no char (15),inv_date datetime NULL,dept_...more >>

Hi, I have got data in a field in the following formats: 9999999_x 9999999_x_ 9999999_xx 9999999_xx_ 9999999_xxx 9999999_xxx_ 9999999_xxxx 9999999_xxxx_ How can i extract the value for 'x' or 'xx' or 'xxx' or 'xxxx' using a single query, where x can be any integer? Thanks Reg...more >>

Is it possible to retreive the Top n columns for each distinct value in the Group By? Example Table has Divisions, Customers and Invoices. I want to return the Top 10 Customers for each Division based on the Sum(Invoices). NOTE, I'm trying to do this with Data Warehouse data so the user do...more >>

Hi I am facing a problem while saving data from my application. Actualy syntax showing below working fine.The problem is that after retrieving this report in my application,when any other user try to inserting any record into ap_spled the application is hanging and cannot insert into this ta...more >>

Hi, please let me know if I enable AWE and PAE and turn on /3 GB switch, why can't I see sqlserver.exe or total/target server memory more that 2.72 GB? Event though there is a page/sec goes upto 6000. Server must need memory more than 3 GB. My email address is : atiqur_rahman02@yahoo.com or yo...more >>

I am concatenating 2 fields in a query. When one of the fields is a null value the resulting string is also null wether the other string is null or not. I have tried setting the concat_null_yields_null to off and on without any change to the resulting string. Does anyone have any ideas about w...more >>

How does one properly write a replace statement when I need to find and replace a number of different tags in a ntext column. I am currently using (replace(col003, 'x', '')) This only works for one character I would like to expand the replace for additional characters. Thanks in advance...more >>

How can I know the total time (in miliseconds) for my SQL Server to answer a query. I want to issue a query using an Query Analyzer and Measure the Servers total response time. Thanks in advance! ...more >>

I want to be able to update Table1.TrnCost with Table3.UnitCost Where Table3.Location = Table2.MainLocation for eg the ABC Records in Table1 would be update with the UnitCost of 2.00 - this being the UnitCost at Location L I have tried the following but it says the subquery returns too many ...more >>

Hi, could someone give me the syntax to communicate across 2 databases. e.g. SQL for inserting records from one database to another INSERT INTO Database1 SELECT FROM Database 2 Both databases are on the same server. I am using SQL 2000. Thanks! Wes...more >>