Hi all. SQL 2k Dev ed Win 2k Pro I have a "Link table" to store link IDs between two other tables LinkTable ID1 INT ID2 INT Primary Key = ID1, ID2 I call a stored Proc (from ASP) MyProc (title, description, links) it adds a new row with the title & description and gets ...more >>

I'm having trouble with a query and was wondering if anyone out there could help me I have a table with columns: login_ID, race_ID, team_ID, TotalPoints All the ID fields are FK to other tables. TotalPoints is an integer representing the total points scored by people on the races. Each log...more >>

Hi I need to update the data in a column in Table A, from a column in another table (Table B), but only if the column exists in the second table (Table B). This is part of an upgrade script which we would like to be able to execute multiple times. The column in Table B gets deleted later in t...more >>

Hello any one. i is new in SQL server. i woulld like to ask how i make the cross tab query to SQL server. eg. i have the table as below Color Size Quantity Red S01 15 Red S02 16 Blue S01 18 Blue S02 19 and now i want to convert from this table...more >>

Can anyone point me in the direction for a list of undocumented sql server stored procedures for accessing registry data. im specifically looking for a procedure that tells me if a key exists, but a list of what is available would be good for future reference. Thanks in advance. Josh Mille...more >>

Have the following table: Name grade date John A 12/01/2001 John A 02/02/2002 John B 04/03/2003 Bill C 03/14/2002 Bill A 05/19/2003 John A 12/21/2003 How do I structure a query that will output the last date a grade was given for an individual? What I want to achieve should look l...more >>

I am looking for a way to reset/reinitialize an identity field to 1 if all the records in the table are deleted. Possibly in a Trigger? ...more >>

I have a stored procedure that makes use of a Cursor as well as a temp table. This query runs perfectly when executed from iSQL, but when it is called via ADO, it returns zero rows. There do not seem to be any errors being generated. Does anyone have some advice on how I should go about debugg...more >>

how can i retrieve the decimal parts of decimal float real data types. Thanks!!! ...more >>

I had a SP has very bad performance, and I found out it is because this statement declare @hit table(id int,hit int) insert @hit(id,hit) select id=startmm,hit=count(id) from netactiontrace where (MemID=10092616 or LoginXCentralMemID=10092616) and startyy=2003 group b...more >>

Hi, I have a sp that delete teh records from the table, but I got this message: Remote tables are not updatable. Updatable keyset-driven cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level spanning the cursor. what's that mean?...more >>

I have a table (in_sys_plan_event) that is resisting attempts to improve its performance. Any help would be greatly appreciated. Table in_sys_plan_event started experiencing UPDATE and SELECT timeouts once it reached 60,000 rows. This is the table DDL before it was tuned: CREATE TABLE [dbo...more >>

I am looking for a way to reduce the following code. Both section of the If-Else code are the same with the exception of the "where" statement in the Else part of the code. The code work as is, but I would like to make it more efficient if possible. Thanks IF (@JOB_CODE = 0 OR @JOB...more >>

I'm trying to format the display results for a report: DATEPART(mm, GetDate()) gives me: 1 I need to have the result always be two-digits like this: 01 Is this something I can do within the SQL Query? Or do I have to do this in my ASP.NET code? ...more >>

I am trying to get a list of foreign keys whose reference columns are not completely covered by a single index. How can I do this via a script? Brandon -- "In the beginning the universe was created. This has made a lot of people very angry, and has been widely regarded as a bad move." - ...more >>

should begin transaction be part of @query ? begin transactin exec (@query) rollback transaction appreciate any help thanks ...more >>

is there any way to create columns names in a variable way? e.g. select val as cast(val as char(4)) from table thanks....more >>

Here is a simplified version of my query: DECLARE @strDrctvCD VARCHAR(10) SET @strDrctvCD = '234, 128' SELECT * FROM drctv_fy WHERE drctv_fy_id IN (SELECT @strDrctvCD) Is there a way to make this work? BV. www.iheartmypond.com ...more >>

Hi all, I wrote a DTS the other day to assist one of our application users, in brief the application summarises emergency admissions at several hospitals - each day the user in question would add these up for the previous day (per hospital) and post it to a white board thats in the app for eac...more >>

are there any drawback of using SSN as datatype int instead of varchar/char thanks...more >>

It seems that E.M. does not maintain a last modified date on Views - only the date created. Is the correct or am I missing something. Thanks, G ...more >>

I am noticing that the Query Designer in E.M. does not support things like CASE statements. Also I notice that the Query Designer in VS.NET supports even less SQL constructs. What is the best practice in dealing with these limitations? I'm guessing that you use Query Designer to do the rest ...more >>

Hello, I'm wondering if we can get a warning if there will be text truncation in executing this statement update TableA set ColumnX = ColumnY ColumnY is "text" type, and columnX is varchar(30) type. Thanks! ...more >>

Happy new Year wishes... I have some basic questions, sorry in advance if these are too stupid. I know about a relational database, but why call relational dbs, relational? Also, what is object relational db? what is an object db? Some definitions help...soorry if these are stupid. T...more >>

Hi , There is a field called "ID" in my table which will be increment by 1 at any INSERT. But when i delete one row from the table, The ID coloms value be come inconsistance. ? any idea how to avoide this ? ID --- 1 2 <--- Delete this line 3 ---------------------------------...more >>

Hi, I have a SQL server problem: I would like to convert a varchar column into a date. The problem is that that column can contain any data, so I only want rows which are convertable. I created a view on the table with isDate()=1 and do the convert on the view. My convert still errors ...more >>

I've done DAYS of searching on the 'net, and can't find anything that makes a whole lot of sense. I'm hoping somebody out there can offer a suggestion (or a link) to help out. I have an image column which stores things like Word.doc and PowerPoint.ppt files. In a stored proc, I want to send ...more >>

Hi I am using the following cmd on a read only database RESTORE DATABASE iusdb From Disk = 'D:\backup\iusdb.bak' I get this error even tho no one is connected to the db has anyone any ideas..thanks for any help Mike Server: Msg 3101, Level 16, State 1, Line 1 Exclusive access could...more >>