Hello, I have problems with Storing Dates into SQL Server. I am using ASP to do so. When I change my locale settings to "Chinese - Taiwan". I hit an error saying the at the Date format is not right. Then, I create a function which returns: YYYY-MM-DD HH:MM:SS and it can work. However...more >>

Hello, I have a problem with storing date in SQL Server, with locale setings not "United States" but others(E.g.Chinese - Taiwan). I created a function to change the date to this format: YYYY-MM-DD HH:MM:SS and it works(As before creating this function, there's a problem storing the dat...more >>

What is a Datawarehouse and how does it differ from Database? I know how to create Database in SQL Server. How do we create DataWarehouse in SQL Server? Sender ...more >>

Hi, I am using SQL Server 2000 (8.00.194) Personel Edition (it came with Office XP Developer) for an Access 2002 Project development. Recently in my MSDN subscription I rcvd and installed Visio for Arch. and used it to reverse eng my database. I then used the gen option to gen a DDL s...more >>

Hi, I have a parameter that pass in list to store procedure, for example, '21, 34, 254,3e3' how am I able to split it and insert one by one to a table . column 1 and 3 are hardcoded value. 1567, 21 , 0 1567, 34, 0 1567, 254, 0 1567, 3e3, 0 ...more >>

Can someone tell me how I can tell what set options a procedure has, I am looking for any procedure or view that has SET QUOTED_IDENTIFIER OFF OR SET ANSI_NULLS OFF. Thanks Devron ...more >>

I turned on trace flag 1204 and forced a deadlock on our test server. When I try to view the output in the event log in the Enterprise Manager, double clicking on the message brings up in a window with next and previous buttons and I have click through multiple lines of output. This is REALLY ...more >>

I need to replace all occurancies of "is" in "This is a test (is), is, penis." with "<a href=is.htm>is</a>". The thing is, if I use a simple Replace function, the "is" in penis also gets replaced. I need to do it either in ASP/VBS or MSSQL, but I'd have it rather done in ASP. TIA...more >>

I am watching the "Mem Usage" for the sqlserver.exe process in the Windows NT Task Manager climb at a rate of about 400k per minute. This has been going on steadily since the server was rebooted yesterday. We're now up to 50% memory used out of a 2gb "limit" I don't know if it was doing this b...more >>

How can I use Visual Basic to view the SQL built into a query? I have two databases in SQL Server. One is on a SQL 7 production server, and the other is on a SQL 2000 test server. Both databases have tables and queries, stored in SQL Server. The tables and queries should be the same in...more >>

When we develop a package using front end like Visual Basic etc. then we can write code to validate what kind of data the user can enter, save, update or delete. For example, if we want the Name should not be greater than 20 characters, we can write code for this validation. If we want tha...more >>

In this case, the employee name has a single quotes, so the following select statement actually inquires 'WILLIAMS, O'. How can I bypass this? Select * from tblEmployee where name = 'WILLIAMS, O'WONDER' Thanks. ...more >>

In a user-defined function, I have 31 variables each of which stores a "float" type value. The values stored in all these variables are supposedly random, and have no defining order. say, I have @var1 = 2300.0, @var2 = 2312.4, @var3 = 2312.4, @var4 = 2504.2, ..... and so on upto @var31 ...more >>

Hi. I'm using ADO.NET to retrieve data from SQL Server via stored procedures. Lately I found the following problem: There's a stored procedure that has a DateTime input parameter (say @statusDate). This parameter is passed from ADO.NET code as DateTime. Inside stored procedure, there's a compa...more >>

Hello, I've a problem with hierarchies and relation division. I'd be really grateful for any help on this, I've included all my DDL below with comments to explain the steps. Hope this makes sense! Many thanks, Kevin Munro. www.c3amulet.com -- Here's a fictitious example of a hierarc...more >>

I want to check a table to see if a column (req_ship_dt) has been updated with an update trigger using the following: IF UPDATE (req_ship_dt) I discovered that our accounting system will delete and insert a row with no change made to req_ship_dt, but change other columns during a shipping ...more >>

Is this possible? Table_1 Col1 Col2 Col3 a e b f c g UPDATE Table_1 SET Col3 = Some_Stored_Proc Col1,Col2 Thanks, Bob Castleman SuccessWare Software ...more >>

the table called itm_lots contain item_id, and lot_number for item no. 1 lot no. A,B,C (A shoud not come again) item 2 lot no A,B,C (should come) but should not repeat. I NEED QUERY TO AVOICE DUPLICATE IN LOT NO. THANKS KALYAN ...more >>

I need help in writing a stored procedure on SQL Server 2000. Basically the stored procedure's primary task is to generate invoice records and insert the records in a invoice table. In order to generate the invoice records, I have an initial table which are basically Day Records. The tas...more >>

I have a solution in mind, but I wanted to hear what the local SQL-Server programming gurus have to say about my problem --- I've seen the problem stated in various flavors, but I am trying to drop all of this into a stored procedure, and my general knowledge of T-SQL vs the other programming la...more >>

if you want to select top 100 records, you will use SELECT TOP 100 * FROM tableName Is there anyone knows how to find bottom 100 records? Thanks. Karen ...more >>

Hi together ! I have a problem: I "just" wan't to copy some records from server 1 to server 2 (same table). But here are the problems: 1. The servers are not connected (can't use linked servers or replication). 2. The target table already contains records, so i only wan't to insert th...more >>

I have a stored procedure running on SQL 7.0 that works most of the time but a few times a week gets the following error: 'Could not find table named 'table id'. Check sysobjects.' The way they have designed the procedure: @wrk_table -- input parameter for table name @wrk_quicksav...more >>

I have a recordset with approx. 189,000 records in it. I need to do an analysis based on random groupings of the data. For instance, on random 60% of the records within a certain criteria, I want to apply one part of the analysis, and for the remaining 40% another part of the analysis. Is th...more >>

SQL Server 2000 I am trying to pull off a record from a table which has 2 ntext fields. = How do I retireve all the information stored within these fields. = Example code for query analyzer would be great. Thanks for any help in advance Rocky...more >>

In the BulkCopy object is there a way to specify a hit to use "FIRE_TRIGGERS"? Thanks...more >>

Hi here is a sample trace I defined on SQL server 2000 and want to visit the result from it's .trc file: /****************************************************/ /* Created by: SQL Profiler */ /* Date: 08/07/2003 10:28:12 AM */ /******************************...more >>

How to send the ouput of a SQL Query directly to Printer?...more >>

Hi, Yesterday afternoon I changed the service account to local system account for sql server agent, after that, one DTS package job which is used to track user login inf. failed, the error msg is " login failed for user NT authority/system", error number is 18456 which said user has n...more >>

Here is the sql.... if quotePrice is NULL I need to copy ASKING_PRI to quotePrice. Not sure how to do it with the Join??? SELECT tempQuoteDetail.quotePrice, InventoryRecord.ASKING_PRI FROM tempQuote INNER JOIN tempQuoteDetail ON tempQuote.tempQuoteID = te...more >>

I have date field in my table: 2003-06-29 02:21:19.373 Now I would like to get the records from my table: SELECT * FROM table WHERE date='06-29-2003' but it doesn't work. I get the result only if I write the select like this: SELECT * FROM table WHERE date>'06-28-2003' AND date<'06...more >>

We're doing a stored procedure for a search page with a number of optional parameters. If they're not entered by the user, a Null is passed to SQL Server for that parameter. It all works fine, except for one parameter: When the @parmResultDate (which is actually a smallint, not a date) is passed ...more >>

Hi, I've been struggling with this for days now with limited sucess. Manybe you guys can help out. All this would be effortless in Oracle/Unix but I've been asked to work on SQL Server 2000. So I ask you gurus to help me out. I have a stored proc in which a variable @var has multiple li...more >>

I have 2 tables: table1: country1 quantity1 idProduct1 table2: country2 quantity2 idProduct2 Now I have to get the quantity:(quantity1-quantity2) for each productId for each country. (where idProduct1=idProduct2 AND country1=country2) If quantity1 doesn't exist then quant...more >>

Creating a view. The daily amounts taken in a bar are listed. When I use the SUM function to display the amounts week by week the daily amounts are not just summed, but multiplied massively by something, and i cant work out why! Help! Rich...more >>

In my TableA I have a KeyPK, Tagkey, datetime, quality and Rev fields. KeyPK is the primary key. What I want to do is whenever a user issues an update statement on quality field and if the existing value of quality field is 97 I want to restore the vale no matter what user tries to change ...more >>

I have a Yahoo POP3 account. I have configured my Outlook Express with this account. Can I send emails using SQL Mail. (I am not talking about extended stored procedure). Where should I find my Outlook Express profile and configure with SQL Mail. (I don't have Exchange client) ...more >>

If I am right...a table is in second normalized form if all the non-key attributes depend upon ALL the attributes contributing to Primary Key and not just one or more of thsoe attributes. So does this conclude that if we table has only attribute contributing towards Primary Key there is no cha...more >>

Hi, I need to add an image into a database from a stored procedure called from a C++ program. In my c++ program I use the ODBC API (CDatabase, CRecordset) and I want to put the image in the database from this program How can I do ? Regards Fabien Gendrot ...more >>

When we develop a package using front end like Visual Basic etc. then we can write code to validate what kind of data the user can enter, save, update or delete. For example, if we want the Name should not be greater than 20 characters, we can write code for this validation. If we want that EmpID...more >>

I am working on an internet-based project. I select SQL Server as its database DBMS. But as Oracle can provide a tool called 'develope server, form programming'. which can help programmers build an data input forms quickly and cheaply, I can not find such function in SQL. I beg for help fo...more >>

How can I use the column_name provided from information_schema.columns in a Select statement that is used for extracting certain columns from a table? ...more >>

In my TableA I have a Tagkey, datetime, quality and Rev fields. Tagkey is not the primary key, in fact no primary key is defined on this table. What I want to do is whenever a user issues an update statement on quality field and if the value of quality field is 97 I want to restore that va...more >>

Dear All, Does anyone know the SQL query for deleting duplicated record from a table? Eg: There are 10 fields, out of that if two fields (say company and code) are the same , then I wanted to delete the duplicate record. Pls help Thanks in advance Jijo David ...more >>

Hi all, I'm having a recurring problem with my ASP/SQL Server 7 website. The website will be running smoothly, with a fairly consistent level of (externally visible) performance, until, after about a week, I'll suddenly start to get the following error... Microsoft OLE DB Provider for...more >>

l am using a dts package to import a text file with delimited colums the problem is that the dts package fails to convert a number value like 12,00 to a numeric field like float. Any good ideas ? PSH...more >>