Hi, I have a query based on some views(joins 8 tables). The execution plan shows that each pair of tables are joined using loop join which is fine. Suppose that there're 4 pair of tables. In the rest of plan, the result of each pair is joined with result of another pair using hash join. Are my ...more >>

Hi, Your help would be highly appreciated! I have a next kind of problem. I have two tables A B A table includes some information about production. Example product A has been made in two days, so information i need is on a two lines and both lines has different date information(20...more >>

Hi, Are there any system function/sp/view to retrieve description of a field. Thanks, Leila ...more >>

Hi, How can I import a DTS file into Enterprise Manager -> Data Transformation Services -> Local Package ? Thanks, Alan ...more >>

I have the following columns... [DiscNo] [Song] [Artist] Each Disc has many song titles. I need to get the song, artist and a consecutive number representing the track number into one text field. i.e. In the end, for each DiscNo, there will be 1 row and 2 columns. How do I approach this? I ...more >>

I have a problem. I have a couple of stored procedures that generate datasets for reports. Both of them utilise temporary tables to help build up the result set. The temporary tables in each stored procedure are named the same, but they have different definitions. Each stored procedure deletes...more >>

I currently use the suser_sid() SQL function to retrieve the currently logged on user in an asp.net application. If I wanted to take it further and also check for group membership, or role membership, how could I do that? any info is appreciated. Thanks. ...more >>

I need to get a combination of PHP and SQL code to do the following: I want to look at the contents of a table and determine the range of an ID. I know my test table has ID's in the range of 28 to 30. I want my sql query to return the range so I can tell a php program the results so it knows...more >>

My company is in the market for a new DB server and we're seeing a common spec of transactions/second. That's got us wondering about what the hardware makers consider a transaction. Any ideas? Is there a standard of measurement? Along these same lines several co-workers got into a conversatio...more >>

How do I insert unrelated statistical data from three tables into another table using an stored procedure? OR How do I write an insert stored procedure that has multiple select statements I know how to use a joins but all I need to do is count the number records in the customer table, winn...more >>

Here is my query: SELECT max(sf.[DateCreated]) as [Date Schedule Created], dbo.Schedule.ID, dbo.Schedule.[Customer ID], dbo.Schedule.[Equipment Amount], dbo.Schedule.StatusCode, dbo.Customers.Contact, dbo.Customers.Type, Company.[Company Name], [Users Fields].[User Field 13] as [Estimat...more >>

I need to strip out both spaces and dashes contained in a column ? How might that best be accomplished ? Sample inputs ABC 123 ABC-123 Either of these should result in the sample output ABC123 Thanks ! ...more >>

I tried 2 variants of ADO connection string, but connection fails: 1. Provider=sqloledb; Network Library=DBMSSOCN; Initial Catalog=Services; User ID=guest; Data Source=127.0.0.1,1433; 2. Provider=sqloledb; Network Library=DBMSSOCN; Initial Catalog=Services; Data Source=127.0.0.1,1433; The S...more >>

hello, I have a table DANE DANE --------------------------------- IMIE NAZWISKO WIEK DZIAL IMIE_DZIECKA IMIE_DRUGIE_DZIECKA NAZWISKO_DZIECKA MIASTO ULICA TELEFON STANOWISKO CZAS_PRACY in this table I must add column IDdane so I use Alter Table who looks that: ALTER TABLE tmp2...more >>

Hello gang -- Is there a way to produce a 'text' version of the graphical execution plan; specifically, the information that appears in the light yellow 'tool tip' window when you hover over one of the execution plan icons? Here's why: I need to tune one of my stored procedures, and I don...more >>

I have a pair of columns: id name 1 bob 2 ted 3 jim 1 jon 1 tim 3 mic 5 tim Any way to query them out to show all the ID=1 with the name in 1 row? id name 1 bob,jon,tim 2 te...more >>

I sometimes have a temp table called #temp_sp on a database where sp_dbcmptlevel returns 6.5. I want to drop this table if it exists. This code: IF OBJECTID('tempdb..#temp_sp') IS NOT NULL drop table #temp_sp returns: Server: Msg 195, Level 15, State 10, Line 1 'OBJECTID' is not a re...more >>

I apologize in advance for such an elementary question, but I searched BOL and MSDN site and still can't find it. I am trying to test my stored procedure with query analyzer and need to pass a couple of parameters. The SP requires @par1 and @par2. My line in QA is: Exec gp_vwSomething...more >>

Hi all, I want to create a table containing only distinct values from one big table's field. I would also like to have a numerical id field associated to each distinct value. I execute "select distinct field from table1" and get + - 70 rows. If I try : select distinct field, id = identi...more >>

Hi, What is the T-SQL to change the data structure from Null to Not Null?? Alter table alter column ??? Thanks...more >>

here is the structure of my table.. appt_begin_date type datetime pay_schdule char(2) example data 7/1/2001 BW 11/1/2004 MO 1/1/2004 BW I want to pick row number 2 because it is the closest to current date (getdate()). How can I do that? Thanks!...more >>

Hi, The following returns null values in the last column "label" in the Results set. How should I change the query to put D or B where the results equal the value I showed? Of course I just creating the column Label in the results set. any help would be gratefull SELECT vid,vdate,vpn...more >>

I am looking for a way to write a query that will allow me to compare records and accordingly assign a value. For example: I have Table A which has the following columns: ExtractDate, ID, HireDate, StatusCode I need to write a query that will build TABLE B with columns: ID, HireDate...more >>

Hi, Ref: SQL Server 2000 SP3 I have tested the following from the Query Analyzer Test1: Select 1999999.0999/'77.88887779999999988888888' Result: 25677.5882044809979342 Test2 Select 1999999.0999/77.88887779999999988888888 Result: 25677.59552314 Does anyone know what kind of ...more >>

Hi I have two fields in my table that I want to merge into one field. My original selection is like: SELECT MyDescription, MyNote FROM MyTable The merging works fine if the fields are the same datatype (VARCHAR): SELECT MyDescription + CHAR(13) + MyNote FROM MyTable The output looks s...more >>

Hey all, I just ran across a peculiar "feature" in SQL server. I wrote this stored procedure that is set up to return multiple result sets (from 3 different select statements). I could make the 3 different select statements MUCH more efficient if I could assign some data from the first selec...more >>

OK, I have another SQL query that I am trying to do with a left join in. Here is the problem: I have two tables, one acts as a lookup for the other, but the lookup table may have more than one record for each distinct record in the other. For example: Table1 ID NAME 1 Todd 2 ...more >>

Hi, Is that possible I could do something like -- put the error message into a variable? e.g. Declare @ErrorMessage nvarchar(50) output Set @ErrorMessage = Raiserror(50001, 16, 1, 'Sorry') Return I would like to return the error message back to front end... Thanks Ed ...more >>

Sql 2000, I have som q: *I see that need to add owner when I call to function, like that: “select dbo.MyFunc” when I call like that “select MyFunc” I get Err why? Have way to omit owner? *when I refer to table from another DB, we must write like that: “DB2.dbo.Table1” Have way to o...more >>

I am search text fields, I have every setup already and I am able to do CONTAINSTABLE and FREETEXT... When I use weight the numbers dont make any sense. I really would like to be able to specify a value for the my keywords and also determine what words were found when I run the query. Right ...more >>

Hi, Can i define a defualt table for a Partitioned view, so when i insert data into the view and the data dosen't meet any of the conditiones defined on the tables, the data will be inserted to the defualt table. Regards, Erez....more >>

I need to do something like this: Select Case When Field = 'Y' Then 'Something' Else 'Something Else' End As FieldName End From ... Where ... But QA chokes on the As statement. Can't I give a field an alias when I'm using a Case statement? I hasve tried moving the End statement after As ...more >>

Hi All, Seems like a simple question.. but I am unable to find the answer for this! I have a query like the following: select col1 from table1 where company_id in (select company_id from company where company_Type = 0) Now this query returns col1 values for all rows where company_id ex...more >>

How can you stop a query that is run from a program using ADO.net on SQL server? I would like the user to be able to cancel a running query. -- Robert Neal West Palm Beach, FL USA...more >>

I am upsizing an Access database and it has a pass through Query that contains this (UNITS / CASES as PerCaseQty) expression as a calculated field. There are some records in both UNITS and CASES that contain Zero’s, so of course I am getting a divide by zero error. In Access I could resol...more >>

Hi All, I an a newbie to SQL queries and need to select rows from a contact DB where Address, City, State, Zip aren't null. I hope I am using the right lingo. Basically, if any of those fields are blank, I don't want them. I tried using city is not null and zip not is null, etc. but the query...more >>

Hi I've a Stored procedure in SQL server 2000 and when I run it in Query analyzer there's no problem and it fetches the result in 2 seconds,but when I run it in VB6 via an ADO connection with executing it throght a command and ofcourse I make the connection timout property more than before, ...more >>

Hi sql Gurus, I have a history table with the following structure create table #temptab ( seqnum int , partnum int , code varchar(2) ) insert into #temptab values (10,4041409,'C') insert into #temptab values (20,4041409,'A') insert into #temptab values (30,4041409,'B') insert in...more >>

Hi, Currently we need to review all tables (80) in a database Is there anyway to print out all the table structures for each table. Like Northwind... Customers CustomerID Identity LastName nvarchar(50) Thanks Ed...more >>

Hi guys I'm having a problem with an auto generated SQL statement. Here it is.. SELECT ProjectID, ProjectName, ProjectClient, DartsContact, LeadArtist, AreaOfWork, AreaOfDoncaster FROM Projects WHERE ((Running = 1) AND NOT (ProjectName LIKE '%music%' OR ProjectOutline LIKE '%music%' OR A...more >>

Hi Guys, I have a system which allocates points to individuals based on their status, and the number of points earned per month. As you get more points you move through statuses, and as you move through statuses, you get more points given to you. % Allocated per Status --------------------...more >>

I'm connecting to a SQL Server 2000 database through ODBC. Is there a size limit in the length of a SQL string that I can pass to the database for processing? Please let me know if any of you have seen a maximum....more >>

Hi I got this statement, now I don't have problems converting dates to what I want, but I do have trouble trying to understand why SQL want to conver the value in my else () to a date. select case when ((isnumeric('2004') = 0) and (isdate('2004') = 0)) then (convert(datetime,'2004',111)...more >>

Hi everybody. After examining ways to add parameters while maintaining existing apps compatibility, I have decided to use stored procedure appended with a version number. So that stored proc named uspTableSave has a new version uspTableSave;2. I just tried to implement that in SQL Manager and...more >>

I have this query which I've left running for around 8 hours and does not return (but is eating a lot of CPU and DISK IO). The server is pretty powerful, Windows 2003, SQL 2K (all patched/hot fixed) 8 Gig Memory, 4 CPU, connected to an EMC disk array. The server never goes above 25% used, 1.1...more >>

Hi! I have a similar query, that runs fo 30-60 seconds with [max degree of parallelism] equal 1 and for 5-20 minutes with [max degree of parallelism] equal 4 or 8 (I have a four-processor server with HT enabled): ------------------------------------------------------------------------------...more >>

I have a SQL 2000 table that I am trying to delete duplicate containers out of that have an earlier date then the last date placed. I've written the following cursor, which parses fine with no errors, but runs forever. When I added a print statement to find out where the cursor was stuck, I ...more >>

Hi all, my requirment as follow Table Structure: Hospital_Assigning -------------------------------------------- Date Phy_id Hospital_id default_hospital ---------------------------------------- Phy_id Hospital_id I need a stored procedure which need to check if there is ...more >>

Hello, I hope you have a minute to help me, it would save me many hours (already spent many on this problem). I am trying to use the render function of the sql reporting web service to get output, however I need to define a DataSourceCredentials object first. I do that with this code Dim...more >>

How can I get a list of tables and indexes in a database, showing rows and size. Something similiar to what you get when you select View-TaskPad on Enterprise Manager, but printable. Maybe there's a system stored procedure I can use. Craig...more >>