Hi, I am quite new to SQL Programming. I need to achieve the output for a query which is something like this:- "Select * from xyz where itemid in(2,3,4,5,6)" I need to create a stored procedure. I need to declare a variable in the stored procedure and store all these values(2,3,4,5,...more >>

Hi, I have the following theoretical table: Letter, Number A, 1 A, 4 A, 3 A, 2 B, 3 B, 1 B, 4 B, 2 What I would like to do is create a SQL statement that gives me the info in numerical order, but also with 4 always first In pseudo terms: select * from table1 order by 4, Numbe...more >>

Hi All, I'm trying to create an update and delete trigger LOGS but I'm receiving this error: "Error 311:Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables." The source table has "TEXT" data type columns. Is there a workaround for this? I tried using CAST on ...more >>

Hi We have been facing a improper index usage problem We have multiple level cascading in SQL Server. The DDLs are given below An update to the table 2 does table scans on the other tables inspite of all usable indexes being present A study of the execution plans revealed that a MERGE J...more >>

Hello Everyone, I am trying to create an SP to calculate prices from a pricing table where a customer has supplied dates of travel. In order to help simplify things and supply the necessary information I have a second table that lists three groups. Each group consists of 4 adults and 2 chi...more >>

Hello I have a user that needs to update values in one table periocally and i dont want to give this person Enterprise manager or query analyzer. Is there a way to create a view or sp for this user to update values in this table periodically....more >>

I have noticed that the calculated columns does not accept in their formula another calculated column or user defined functions. Is this true? what if I need to use a UDF in my column calculations? ...more >>

Dear All, Just starting with SP's What's the equivalent code for this ADO-loop in a stored procedure? Do While Not (objRsSource.EOF) 'some action(s) objRsSource.MoveNext Loop Thanks, Filip ...more >>

Hi Friends, How to check a particular column is a PK ? If that column is not PK , then i would add the PK using the following T-SQL statement. IF <Column1> is not PK ALTER TABLE [table1] WITH NOCHECK ADD CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED ([Column1]) ON [PRIMARY] Please...more >>

hi, i've multiple sets of db (same structure but different data) in various = server.=20 any way to specific which server to use when comparing?=20 there is dynamic db name, how about dynamic server name? i've tried red-gate sql compare but it's comparing the whole table = records and it's...more >>

I've read that SQL Server 2000 doesn't have an equivelant of Oracle's FOR EACH ROW trigger. I'm looking for some advice on strategies to achieve this functionality in SQL Server 2000. Thank you, Jason...more >>

Hi All! I want to Attach Data Base during the Code in C# and not throught Ent.Manager. Q 1: How can I use the AttachDB method throught C#.Net I also want to get some information from the server itseft from code. Q2 : How can I use the API of SQL Server 2000 and What is the name of dll or ..net...more >>

I need help on improving the performance of my table sys_event_log. The table is experiencing table locks which is causing users to get timeouts. CREATE TABLE [dbo].[sys_event_log] ( [c_table_name] [varchar] (40) NOT NULL , [c_table_primary_key] [int] NOT NULL , [c_staff_id] [varchar] (30...more >>

Hi everyone, SQL Server 2000, Windows NT Server 4, ODBC connection, Delphi, BDE I'm trying to insert a group of detail table when the users inputs a record in the master table. When inserting the master record, an X lock is granted on the master table primary key. When inserting in the...more >>

Hi, Recently we exceeded the max limit(253) of foreign keys in one of our table. Did any one faced this problem. Is there a good solution or work around for this problem. Can you please share your experiences or ideas. Thank you in advance. -Rayan...more >>

Hi I'm working for a pulp & paper mill creating expenditure reports Using Actuate and SQL server 2000. I've been asked to write a report that displays the totals of capital projects taking place at the mill. Each capital project consists of a hierarchical set of work orders that have associ...more >>

All, I amtrying to get the time part of the Getdate function. for example: Select getdate() returns Nov 16, 2003 06:45 AM I want only the time portion . I know there is datepart function, but it seems to only return certain portions like hour, minute or seconds or milliseconds. is there...more >>

Hi all, I created a script to sum my customers amounts by month and year. the day does not matter. I grouped my data by convert(varchar,year(date))+convert(varchar,month(date)) to give me yyyymm as my gouping. the problem is month(date) of any single digit month is the number without ...more >>

I have 3500 stored procedures in a SQL Server database, is there a way to determine if the stored procedure has an update or delete statement to a table. Is there a way to determine if the criteria listed above without opening each stored procedure? Thank You, Michael...more >>

I have 3500 stored procedures in a SQL Server database, is there a way to determine if the stored procedure has an update or delete statement to a table. Is there a way to determine if the criteria listed above without opening each stored procedure? Thank You, Mickey Autry...more >>

1) How can I get date without time from GetDate()? 2) Can I format dates like in VB ('dd/mm/yy') ? 3) I have varchar parameter that contains date ('16/11/03'), how can I compare it with current date (without time) ? Any links or/and samples will be very helpful. Many thanks, Yuri...more >>

Where should I find the reply on how to create a database in SQL server? How can I create Database in SQL Server by script? Thanks ...more >>

Hi, I got a table having rowsize definition far beyond 8060. We are planning to add few more Fixed length columns. Now I need a way to find the actual rowsize used for each record. I need to find whether there are any rows, having recordsize close to 8060. This would help me to give an im...more >>