Hi, I am trying to use the ALTER SESSION statement within a stored procedure. How can I use it properly so that my procedure can be compiled ? Thanks for your help, Alain ...more >>

I want to reference the exempt status in a table to get the difference in salaries between an exempt and non- exempt employee....more >>

Please I am trying to automate a dump from sql server to an excel sheet. I know it's possible via the dts, but since this is something I do 10 times a day, I was wondering if it's possible to run a script in the Query Analyser to export my query results to an excel sheet or maybe I could c...more >>

I have two simple questions - well simple for the experts anyway - but I am struggling with them. 1. I need to do the following: I have two fields: claddr1 and claddr2. If claddr2 is not null, I need to include it with claddr1 with a <CR><LF> in between. Seems simple enough but I hav...more >>

Hi, I have created few views in SQL2000 and when i m transfering this to SQL 7.0 it doesnt work. I m doing it thru vb , it stops responding. help me...more >>

Hi I am using VB.net/ASP.NET and SQL Server 2000 for asp.net application. In following call to the procedure, I am passing a list of country ids. In the procedure, I am opening up this xml and this list as varchar type list. The column 'countrym_id' is a tinyint in tblProfileQ Now, wh...more >>

Hi Please help me URGENT How do i make an tableField with a Auto-Incr, the same like in an access DB where it's called AutoNumber Thanx in advance __________________________________________________________________ Flemming Paulsen ICQ#: 270065050 Current ICQ status: + More ways to contact m...more >>

Microsoft User this is the latest version of security update, the "September 2003, Cumulative Patch" update which eliminates all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

This is an admittedly novice question.but first a little background info on what /why I'm trying to accomplish this. I am running MS SQL 2000 sp3, I have a Case Management system on it called ProLaw. In ProLaw is a table with phone numbers in it. One type of phone number that is trac...more >>

I have got a view which contains a counter and two datetime values which are derived by using the CONVERT- Function. Looking at the view is not a problem, but as soon as I place the datetime-Value in the where-Clause I get error 241 saying that there is a problem while converting a charac...more >>

Hi, I am a programmer with resonable knowledge in SQL SERVER and DTS I am interested in expanding my knowledge in Datawarehousing, Cubes and OLAP Tools what would be the most logical step by step way to do this. What are the various books and websites that teach you these things What are t...more >>

Microsoft Consumer this is the latest version of security update, the "September 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now t...more >>

Hi; my hard drive crushed and I lost everything. with a new hard drive and Windows NT 4. Workstation OS(my previus OS). I did reinstall and restored my data. I did install the SQL7 and configured that as it was before. I need to migrate or restore the backed up database to the original...more >>

Microsoft Customer this is the latest version of security update, the "September 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to h...more >>

I'm curious if this is possible using only standard queries... if not, feel free to post alternate code. Here is what I'm trying to accomplish... I have a SPROC like this: ---------------------------------- CREATE PROCEDURE dbo.MyProcedure @InputString varchar(30) INPUT AS SELECT ...more >>

Hi, I was wondering if anyone could help me. I need to return a number of results from a table that require me to use many select statements. i.e. select count(NoApples) from fruitTable where NoApples = -1 and Cost = 5 select count(NoOranges) from fruitTable where NoOranges = -1 and...more >>

After you restore a backup, how do you assign a new filegroup? I have a 280 GB that uses one file group and I want the current files to point to different filegroups. How is this done?...more >>

Hi Thanks for reading. One of my client uses a medical software called advantx. We recently had to convert them to a new w2k Server running sql 7 and active directory. Shortly After importing the database (1 month) i noticed the database size starting to grow at a rate that i thought to be...more >>

Hi all, I have a database consisting of more than 2000 records. I need only a certain number of records be displayed on the page at a time. When I click 'next' Another set of same number of records need to be displayed. I know 'top' and 'rowcount'. But how can I select a range of records, sa...more >>

Here's my table: CREATE TABLE foo ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id), password CHAR(16) NOT NULL DEFAULT 'BabaLooey', int_array INT(200) UNSIGNED NULL, ) The question is- how do I write a SQL statement that fills in the entire int_array with valu...more >>

I have a need to left pad the month with 0, can you help me do this? For eg. if the month is January, in the query it returns 1, I want it to return 01. select datepart(mm,Workorderdate) from <tablename> It would be still better if I could get the entire date in yyyymmdd format from Work...more >>

I have a query that builds a concatenated string, which will be 409 characters. I am using a Char type, which from my research can have up to 8000 characters. The result is truncating at 256 characters when run. Any ideas or what is my problem? Thanks...more >>

Relationship Databases Hi, I have a DataBase called "ServerInformation" where there´s a table called "Clients" Another database aplication "Index2003" using the same SQL Server, will acess the information in the table "Clients" from then "ServerInformation" Database. My question is.... H...more >>

Pulling data from an Oracle Server and creating a temp table(User, Response, ResponseDate). Have 75 unique users, and over 10,000 responses and the date submitted. How do I limit the results to only two distinct responses per user with dates? TOP 2 does not work, SELECT DISTINCT does not e...more >>

I am trying to query a table to get records sorted in a certain way. There are two kinds of records - A and B. I want A's to be sorted on "Start Date" and B's sorted on "End Date". And B's should follow A's. So, Lets say the table looks like: Name StartDate EndDate ------------------------...more >>

I have a table with Identity colomn and becouse some of the records was deleted it is looks like that now: ItemID Col1 Col2 Col3...... 09 **** **** **** **** 13 **** **** **** **** 29 **** **** **** **** 34 **** **** **** **** 42 **** **** **** **** 67 **** **...more >>

How to display the roles granted to a user. Thanking you....more >>

running sql server 2000 and 1gb ram. ram usage is always very high. is this normal? interfering with timely queries and batches....more >>

How do I add a leading '0' to an existing value with a data type of vachar? For example, I'd like to change '1234' to '01234'. Thank you for your help....more >>

What is the size limit on a grouping of ID's for an IN clause? I have a large string of ID's that I'm trying to use with the IN clause. I'm currently getting a stack overflow error, which I found out more about through Microsoft's knowledge base. However, I couldn't find what the maximum a...more >>

I have 2 database tables with the same number of columns. Using SQL, I want to transfer all the data from one table to another. The columns are named differently in each table but the order of the columns is correct. Here's an example ... Table 1 CUST_NAME CUST_ADDR CUST...more >>

I need Help. Here's the deal. I'm a C# programmer but I am also the production DBA. I love my co-workers, but everything that is an 'inconvenience' starts unending discussions. I've given up the battle on normalization (or primary table has 70+ fields) because they won't budge (and I'm in th...more >>

I have a stand alone athlon based computer with windows xp home. MSSQL server is running Why and do I need it?...more >>

I need a SQL query that will return row1 and 2. The rule would be "2 (and only 2) occurences of number1 where number2 is not the same. number1 number2 3 5 3 6 4 8 5 14 6 2 6 2 8 1 8 1 Thank You, JB...more >>

Iam new to stored procedures in MSSQL. But this is very simple and i'm getting the above stated error. I went through another thread in this website which was prettty much the same error as stated above. But, as suggested in that thread, my proc statement has the same lower case variable whic...more >>

I have a customer who says they got a file that is "SQL" and probably originated from SalesLogix. Now I know that SaleLogix is an application which is built to run on top of SQL Server or Oracle so I'm guessing from the description that it is in fact the SQL Server flavor. It is described to m...more >>

Can anyone tell me how I go about truncating a log file in my database and then restoring it? Or where I can go to find this info? I'm kind of a novice at this SQL stuff. Thanks. Mike Stevens...more >>

Dear All, We have Hp LC 2000 server , P-3 @ 1 GHz, 1 GB ram, 3 X 36 GB hdd Netraid, windows 2000 OS, SQL 2000 server as DBMS. Our server gets lock if 3 or 4 query is run simultaneously. CPU utilization becomes 100 %. It moves only when one of the query is finished. Can anyone help us in th...more >>

How would you write a function that takes as its input, a proper name and returns the name in Proper Case?...more >>

Given a table that includes 2 digit test scores how can you write a function that eliminates the three largest and the three smallest values and returns all the values in the middle?...more >>

I'm customizing Network Associates (Magic Solutions Division) Magic HelpDesk software for our environment. I'm creating custom helpdesk forms for our personnel to use as templates for submitting frequently submitted issues. To create these forms, displaying the information that is needed, ...more >>

I'm transitioning from Oracle to SQL Server. Need to know the MS command that is equivalent to "Rownum" in Oracle so I can restrict the row output from my queries....more >>

I need to have a database server to be case in-sensitive, how can I do it? Thank you, Alice...more >>

How i can DeFrage index of whole database(one database) in single statement. My database name is "Sidathyder_host"??...more >>

#temptable (order, name, activity and count): 1 mark1 null 0 1 mark1 movie 5 1 mark1 game 4 1 mark1 game 3 2 mark2 null 0 2 mark2 sports 6 2 mark2 game 4 2 mark2 game 3 2 mark2 candy 2 3 mark3 null 0 3 mark3 movie 2 3 mark3 game 4 ...more >>

Hi, Can anyone tell me how to retrieve fieldnames for all tables in my SQL2000 database. What SQL statement would I use? Thanks, C.Verweij ...more >>