I have a UDT I created and would like ArrayList.Sort to work on an ArrayList that includes my UDT. I have implemented the IComparable interface, and have the code shown below in the UDT. public int CompareTo(object o) { if (!(o is IntervalUDT)) ...more >>

Hi Guys, How can i make optional parameter in my stored procedure, suppose i'm passong 5 parameter in my SP in which 2 could be blank/Space, so what should i do. Please snd me some example Thanks In advance ...more >>

I have a table with 70,000 records that I need to split into two separate text files. Neither file can contain more than 50,000 records. The first part seems easy: SELECT Top(50) PERCENT ... How do I retrieve the bottom 50%? -- Regards, Fred Chateau fchateauAtComcastDotNet ...more >>

I have four tables: Company, Branch, Address, Contact. The following query works fine for retrieving my information: SELECT Branch.BranchID, Branch.CompanyID, Company.CompanyName, Company.IsListed, Address.AddressID, Contact.ContactID FROM tbl_Branch AS Branch INNER JOI...more >>

When I create a job schedule and run this in QA: exec sp_help_jobschedule @job_id = '{36E92706-9701-45DF-B5FA-8162C5D3B36F}', @include_description = 1 I get a different description than if I look at the description in EM. Here's what I'm getting in QA: Every 11 months(s) on the third we...more >>

When I run the following on a Win2K machine, I get errors as follows. If I run the same thing on Windows XP or Windows 2003, it works fine. What is going on, and how do I get around this? Thanks! EXEC dbo.sp_executesql @statement = N' CREATE FUNCTION [dbo].[MyFunc](@inputVar [n...more >>

Hi, I am using the SQLDMO SQLServer.Databases.Item("db name") to access a database on a server in our company network. It takes over 2 minutes to get a response (too slow !!!); the server is a MSDE, and contains 20 databases in one instance. Thanks, Marius. ...more >>

How can I know the current connection user credentials (SQL Server login name) from my stored procedure? ...more >>

Hello, I am trying to develop a Windows Service that is able to connect to a MS SQL Server 2005 database through late binding. However I am not able to find any information about this. I hope that someone around here can help me with this or at least point me to something useful. I am using...more >>

Hi, I got a table where few of the fields are text. I need to make those int. From Design View I am trying to do the conversion. However, I am getting the message: Conversion from text to int is not supported on the connected database. Does that mean that I cannot do this conversion. If not,...more >>

I have a table called Dbo.Categories which contains information on content pages of a website. The key fields within this are Category_ID and is self related to itself via BaseCategory_ID as follows: Catergory_ID BaseCategory_ID Description 1229 0 ...more >>

So I am just starting to learn how to use Database. I need the help of a SQL guru! I have these three tables: CREATE TABLE SB3_ScheduleChange ( emp_num EmpNumType:nvarchar(7) NOT NULL PRIMARY KEY, Monday char(35) NULL, Tuesday char(35) NULL, Wednesday char(35) NULL, Thursday ...more >>

Hi All I have 2 tables. use MKumar_DB; CREATE TABLE dbo.tokens ( id int identity primary key, appid int, token varchar(60) ); insert into dbo.tokens(appid,token) values (1,'a'); insert into dbo.tokens(appid,token) values (1,'b'); insert into dbo.tokens(appid,token) values (1,'c'); ...more >>

Hello, I have started learning SQL Server 2005. I have a question to experienced programmmers. In my database, I want to have such functionality: when some records in a table X are inserted/updateted/deleted I want to perform some modifications in a table Y. The modifications must be perform...more >>

Hello, I am trying to copy about 300,000 rows of data from one table to another. I am currently using a simple INSERT INTO SELECT FROM statement. The target table already exists (so I cannot use SELECT INTO). I am seeing pretty poor performance during this copy (more than 3 minutes). Th...more >>

I am currently creating a fix width export file to text. This file will be imported via an interface that requires negative signs to be dropped and replaced with an alpha character at the end of the string. The decimal point also needs to be removed, but I have completed that through a repla...more >>

I am creating a Fix Width export file to text, and this text file will be imported into another interface. This interface is AS400 and it requires that the negative sign be dropped and a alpha character will be placed at the end of the file. I must also remove the decimal point (I have a repl...more >>

Hi folks, 1. select A.employeeID, B.EmployeeName, C.DepartmentName, D.Paystatus from employee A, EmployDetails B, Department C where A.employeeID = B.EmployeeID and B.DepartmentID = C.DepartmentID and B.PayStatusDesc = D.PayStatusDesc and ...more >>

Hi All 9Sorry my original post did not show up, so I am reposting) I use SQL Server 2005. Table intent: For a given appid and testid there can be many tokens associated. I have a table like this CREATE TABLE dbo.run ( seqid int identity primary key, appid int, testid int, toke...more >>

Is that possible to write a SQL (or AtiveX) that script all the "enabled" sql server jobs in the db, store them in a file(s)? I like to set up an automated process to do this task and promote it to a different db server. Thanks for your help! *** Sent via Developersdex http://www.devel...more >>

Hi All I use SQL Server 2005. Table intent: For a given appid and testid there can be many tokens associated. I have a table like this CREATE TABLE dbo.run ( seqid int identity primary key, appid int, testid int, tokenid int ); I have a list of tokenid's (ex: 5,3,4 there can ...more >>

Ok maybe I am asking too much. But is there a simple way to run a script that will defrag/reindex a whole table...more >>

I have a stored procedure: create proc GetData(@clientid int) as select * from clients where clientid=@ClientID go This generates an error that @ClientID is not declared. Why is T-SQL case sensitive? How to turn it off? How to make the compiler case incensitive? Thank you....more >>

Hi Friends, SQL 2000 I need a help with a query. I have the table : invoiceid . invoicecode - invoicevalue - dinsert -------------------------------------------------------------------- 1 2 45 10/10/2006 14:31 2 2 ...more >>

I am running sql server express. The input parameters need to be the same case as when they are used in the procedure. I would like to turn this feature off. I know this is possible. Please help. :(...more >>

Hello! We have a stored procedure that sends people reminders via xp_sendmail for courses they have registered for. We select several columns out of the database (all are varchar, and are sized up to 1000 char). We are building the message body as: @msg = 'You are registered for ' + char(13) ...more >>

Hi All, I think what am trying to do is quite basic. I have 3 paramaters@value1, @value2,@value3 being passed into a stored proc and each of these parameters can be blank. If one of them is blank and the rest of them have some valid values, then I should just exclude the column check for th...more >>

I am using ArrayList in the following fashion Collapsed.Add(IntervalArray1) Collapsed.Add(IntervalArray2) I get a jagged array as the result. Is there any easy way to just have the second set (IntervalArray2) simply added and not create another dimension. The way it is working is I ...more >>

Hi everyone, I have some code that we need to migrate to SQL Server 2005 from 2000, and I have a webpage that upon viewing, fires a query to the SQL server using ISS and ISAPI. The result set is formatted for display using XSLT. But since ISAPI is deprecated in SQL 2005, I was wondering how to m...more >>

hi, i have a trigger defined on a table for update, insert and delete. is there a way to disable the trigger for a paritcular query temporarily just for that query?? or any thing to get around it? please advice. thanks!...more >>

I changed the Results in Grid to Results in Text and now whenever I get out of SQL Query Analyzer and get back in, it seems to be defaulting to Results in Text even if I change it to Results in Grid. How does this get changed??? Thanks in advance. wnfisba...more >>

HI i am attempting to produce an sql stored procedure that will allow searching with a variety of parameters: @pkiBarcodeNumber int, @szFirstName varchar(24), @szSurname varchar(40), @szDateOfBirth varchar(8), @szPostcode varchar(8) AS SELECT pkiBarcodeNumber, szFirstName, szSurnam...more >>

I set up log shipping on some test databases in SS 2000 and it's worked great. I used the wizard to do the initial backup and set up of the standby databases on the secondary server. I did run into one problem, though: the Sql Server logins on the standby databases did not make it over su...more >>

Hi, I'm creating a query like this: set @query = 'SELECT DISTINCT TheID, TheName, TheType from TheTable WHERE TheCondition1 = TheCondition2 ' set @query = @query + ' and '''+@ComputerID+'''= exec sp_Computer myParameterComputerID' But it doesn't work, it seems like SQL cannot execute ...more >>

I need to be able to detect that a row has been read so that a request to update the row is disallowed. Because of the complexity of the update, it is best to totally disallow update if someone is already viewing the data. To increment a counter when a read is done, and decrement it when the ...more >>

Sorry if this is trivial but ... If you have a source table A with 10 columns . you also have 3 target tables B, C & D with D being a subtype of C and C in turn being a sub-type of B then .. how would you write and insert statement to get the records from A into the correct places in B, C ...more >>

Hi, I have these tables: Sales (SaleId, ProductId, QTY) Bandwidth (ProductId, RangeFrom, RangeTo, Price) A RangeTo field is included in the Bandwidth table cause an "open end" is possible; 1-10, 11-20, 21> Now i would like to get a table like: SalesView(SaleId, ProductId, Qty, Price...more >>

Hello, I'm having an issue running a stored procedure in a vbscript using ADO .... I keep getting "operation is not allowed when the object is closed" on my first line of testing my connection. The sproc I'm trying to run can be found here: http://www.sqlservercentral.com/scripts/viewscript...more >>

Hi There, I try to find transact value in deletedlog like this select * from transact where cast(transact as varchar(20)) in (select DetailTableValue from deletedlog) In the deletedlog detailTableValue fields has following records 4703246,4703247 4526657,4526658,4526659 4536298 95861...more >>

Hi Look at this sql (http://code.doria.se/code.aspx?c=e41e8421-0ec1-4226-bb0c-f34046d3516a), my question is in the comment. Thanks...more >>

let say I have following records in table called tblMessage: Name Id MsgType MsgId MsgStatus ====== === ========== ======== ============ John 100 Enquiry 1 New Andy 101 Complaint 2 New Simon 102 Enqu...more >>

When I go into the backup dialog, I can browse the server's file system for a place to put a backup file. Is there a way to backup a database to my local machine? ...more >>

Hello! I'm having difficulties creating a certain Check Constraint. I want to be able to write in my column any number from '1' to '100' or the sign '?' or nothing at all (not NULL, but a value that consists of nothing written). Nothing needs to be calculated, the numbers are only characters he...more >>

I've done some tests using a uniqueidentifier as a primary key. I created 3 tables (called A,B and C)with 1000, 100 thousand and 10 million records. The structure was pretty simple, table C had a foreign key pointing to B and B had a foreign key pointing to A. I did a select statement getting ...more >>

Hi there , I have a problem regarding using TOP() i am not sure which query to use .. I ve try IN, EXISTS and still give me error Basically I want to retrieve Data that is in ICD10 Table, but I query select top(5) from another table and using count()to sort the order and group. The query se...more >>

Hi! Got a question regarding updating a database table. This is the query i am using Update Customers set CustomerSetID = (Select xdb.CustomersSetID from xdb where xdb.id = Customers.ID) When executing the query, CustomerSetID is correctly uppdated if the record exists in the xdb ta...more >>

Hi all, I have an english app that i am looking at using overseas. say, china, russia etc. If I understand correctly, if my varchar fields become Nvarchar then the foreign languages can use them. but now for numbers: However i am unsure of what happens in a foreign country if the user ...more >>

Hello. (Sorry for my English...) I have started learning SQL Server 2005. I created database for stock managament application. I have Documents with Positions, Materials in Groups; maximum stock levels are kept in GroupsInStocks table, and I have TotalQuantity of MaterialsInStocks. I would ...more >>

Hi, I would like to call an asp page in sql ( probably with xp_cmshell) and read xml response ( from the asp page returns xml format) and update a table. Would you give an example for this. Thanks ...more >>