Pls Help if somebody has taken this test...70-229(MS SQL Server 2000) I want to pass this desperately.Pls suggest some good question banks....more >>

I am writing a script to retrieve data records of MarinLif table. The problem is that i have a column MarinLif_Picture of type image so the insert is wrong in this way. How do i correct it? /*****MarinLIf TAble ********************/ DECLARE @ID INT DECLARE @typeID INT DECLARE @NAME NVA...more >>

Hi, Using SQL 2k SP3 I want to know if there's a way to retrieve the name of the database a stored proc is run in. For example: CREATE PROCEDURE HelloWorld AS PRINT 'Hello world, this proc is run in: ' + CAST(GetDatabaseName AS nvarchar) GO GetDatabaseName here is fictitious ofcou...more >>

Hi; I would like to read a list of tables from a temp table and then do a sql statement on each table name retrieved in a loop, ie: -- snip cursor loop where cursor contains a list of tables declare @rec_count int set @rec_count = 0 exec('select @rec_count = count(myfield) from ' + @...more >>

Please help, below is my problem. Let's say I have 2 tables, a Products table and a Colors table that go as follow: Table Products prodID Name 1 shirt 2 tshirt 3 pants 4 jeans and Table Colors prodID Colors 1 Blue 1 Red 2 ...more >>

I am looking for some T_SQL code that would help us eliminate duplicate data entry into our mailing db. Finding and removing the existing dups is not rocket science, but I am looking for a complete solution. We also want to be able to come up with a T-SQL script to be intelligent enough to kn...more >>

HI I have server MSDE 2000 SP3 frequently server stopped, and print in log file information: 1) 17310 : SqlDumpExceptionHandler: Process 1984 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2) 17311 : SQL Server is aborting. Fatal e...more >>

Hi All, I am using Microsoft SQL Enterprise Manager version 8.0 and have created a view from a combination of 4 different tables. I would like to be able to go into sql and open the view and select a row and delete that row however this seem impossible right now. I am not sure if it's possible ...more >>

Hello, I have a table called 'tblCLTestScores' that holds student test scores for one particular test. Students take this same test three times on different dates, so the table contains three or fewer records for each student. The records for any given student are made distinct by the ID numb...more >>

Hi. Please try to bear with this SQL "newbie" here ;) I am trying to figure out how to import the FCC ULS report results into a database. I believe what I need is a JOIN statement. To see the data for yourself, visit http://s91748743.onlinehome.us/wndv619_example.txt (I chose this que...more >>

Hi Folks.. I have a question i want's to make a website where people can upload media files like movies short movies of a minut or 3 max. Can i store those media files like mp3, mpg etc.. for instance in a sql-server database, or is this not wise to do? Thanx in advance.. ...more >>

Hi, I wonder if anyone can help with the following on a fee paying basis for the the design or development of some type of script or utility or piece of code to do the following work. I wish to retrieve some data from an online database that is in the public domain. The online database has ...more >>

On one of our machines, all of the SQL Server 2000 components except for the main Server component (SQL Server core) itself were installed (Management tools, etc) a while ago and everything was running fine. Now I go and add/install the Server component and then Service Pack 3a. It seems that...more >>

I was searching the group for posts on the subject of format files and I came across a message by Erland Sommarskog dated 2003-07-07 with subject line "Re: BCP Format File". In this example, he used a FORMATFILE where the "prefix length" and "host file data length" fields were both zero for all...more >>

Hello, I am trying to load a simple tab-delimited data file to SQL Server. I created a format file to go with it, since the data file differs from the destination table in number of columns. When I execute the query, I get an error saying that only sysadmin or bulkadmin roles are allowed t...more >>

I have a client who needs to copy an existing sale. The problem is the Sale is made up of three tables: Sale, SaleEquipment, SaleParts. Each sale can have multiple pieces of equipment with corresponding parts, or parts without equipment. My problem in copying is when I go to copy the parts, ...more >>

how can I set my primary key to star again from 1?? for example, if I had a table with some rows in it and I deleted all that rows, next time when I insert a new row in that table, primary key starts from last primary key of previous rows, but I want it to start again from 1. is that possible?...more >>

Do not trust values returned by materialized views under SQL Server without frequently checking underlying tables!!! I already posted this message under microsoft.public.sqlserver.server and I'm amazed nobody from Microsoft answered about this problem. By inserting lots of data into our two ma...more >>

Hi, I have a database (or better: used to have) and backup consisting of - the initial (complete) database - all log files since then (or so I thought) After making a data entry error I wrote the log to the backup and tried a point of time restore. Unfortunately that failed with the message ...more >>

Hi I have a SQL2000 server with 128m rows of data. I want to delete about 65m of that. So far I have bcp'ed the relevent data out and put them into another SQL database. We have a small amount of space for our transaction log so I cannot delete all 65m rows in one go. So far I have been ...more >>

Hello, I use Unicode in my program to enter data in Chinese into a nvarchar field. When inserting or updating records, my application does not use Unicode escape sequences but rather the Unicode characters themselves. Thus, my app may have SQL statements like: UPDATE table SET field1 = ...more >>

Does anyone know of any shareware tools out there that can connect to sql server 2000 from Unix(specifically Sun Solaris) and perform queries and return result sets ? Appreciate your help. Steve Chiang...more >>

What causes the query optimizer to choose a table spool\lazy spool action in the execution plan? The explanation of "optimize rewinds" makes little sense because my query never comes back to that table. I'm going to have to change the query but it would be helpful if I knew what I should be t...more >>

Hello, I have a C++ / MFC app which uses CDatabase and CRecordset to connect to a ODBC data source for a SQL Server 7 database. The application worked properly with a MySQL database, but after swapping it for SQL Server problems emerged. In particular, any calls to CRecordset::AddNew() and CR...more >>

If I use _reverse_ wildcard search will it always result in a table scan? Is it possible to get the DB (Oracle or SQL server) to use indexes when doing reverse wildcard match? let's say I have: table email_address (id int, email varchar) with the following entries 2, www.%shoes.% 3, ...more >>

I'm trying to do a simple alteration to the table design of one of our SQL 2k tables, simply changing an identity row so that its not 'not for replication', and its taking absolutely ages to do so, and stops the sql server from working. Whilst it's attempting the update, no one can access the ...more >>

I have a problem that I can't quite get started on solving. I have a table of asset statuses. Each time the asset status changes, a new row is inserted into the table. CREATE TABLE dbo.Tbl_EMStatusHistory ( EMStatusID int IDENTITY (1, 1) NOT NULL , EMSessionID int NULL , AssetID int NO...more >>

Version 2000. How do I do something like the example SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\Finance\account.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions but use a .txt-file instead ? I tried building it using Access (that u...more >>

Hello there: I am trying to configure an excel worksheet as an Writeback application but I want to block some cells in the page and combining cell protecion does nos alloudm to insert rew rowns...more >>

I have a situation with a 6 server setup whereby merge agents will not run if other merge agents are alreay running. Basically we have a 5 laptop, one tower config with the tower being the publisher. In theory we want to be able to hook a laptop up and have it sync within, say, 5 mins. Trouble i...more >>

I migrated a DB from Access 2000 to SQLserver 2000. The tables are OK, but I see the old Access views... as TABLE in SQLserver!! Any suggestions? -- ...more >>

I am new to using sqlserver and have been given the task to get the column name, data type and the description from a given table and put this into another table. Can this be done? Thanks in advance. Jeff Magouirk ...more >>

select last_name,hire_date,to_char(hire_date,'DAY') DAY from employees order by to_char(hire_date-1,'d') i wanted to know how the function to_char(hire_date-1,'d') works... its basically a query used to find the day on which a employee was hired ,also it requires that the query be sorted by t...more >>

Does anyone know if there's an SQL command i can run that will list the tables in a database that have an identity column set to NOT FOR REPLICATION? Many thanks Dan Williams....more >>

I have been building ASP, ASP.NET and Crystal Reports on SQL server for a few years now. I have build them mostly on an Intranet or with companies that have their own web servers. I now need to build an application for a company that doesn't not have a web server. Just a small shop that w...more >>

Hi All, I use Bulk insert to put data to myTable. When the SQL server is in local machin, it works well. But when I put the data in a sql server situated not locally, then I get a error message like this: Could not bulk insert because file 'C:\Data\2003 txtfiles\abif_20031130.txt' could n...more >>

Hallo! Ich habe eine Tabelle mit einem Datensatz in ein Feld den Wert 'Technaflon Nasskamine' hat. Wenn ich so Suche wir der Datensatz gefunden: Select * from namen where contains(*, '"Technaflo*"') So nicht: Select * from namen where contains(*, '"*echnaflo*"') wie finde ich den Da...more >>

Hello, I have a situation where I have to run a Delphi 1.0 application on Win95 via ODBC to MS-SQL 6.5 server. This is working for me on several workstations. I always install 16-bit BDE and make appropriate changes to odbc*.INI files, etc. I have a machine which has just now been setup for t...more >>

I'm running into a situation that has me adding a value of "Unknown" to a reference table. I am being pulled between two trains of thought, and was curious to get other's input on in. I give an example below. 1-) Adding "Unknown" to a reference table is bad. Doing so effectively changes the...more >>

Hi, I like to have a SQL script which could update a table to set one attribute to a random value picked from a given list. The prototyping code is as below: select @value_list = ('John', 'David', 'Mathew', 'Paul') .... update EMP set emp_name = @random_name where ... where rando...more >>

im using asp.net, C# to enter data into a table in sql server...however im getting this error: Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the ...more >>

edit: this came out longer than I thought, any comments about anything here is greatly appreciated. thank you for reading My system stores millions of records, each with fields like firstname, lastname, email address, city, state, zip, along with any number of user defined fields. The appli...more >>

Currently we have SQL Server running on a single RAID5 array. The data and the logs are all written to this array. We don't have huge volume of activity, but it is growing. Most activity is from our website that interacts a lot with the database. We have read that it is a good idea to separate...more >>

Hi I have a table in SQL Server 2000 that has following data: PunchTime PunchType 11:45:00 In 12:45:00 Out 1:45:00 In 3:15:00 Out Is there a way in SQL to represent this in the following format: In Out In Out 11:45:0...more >>

Hoping I can get some assistance with an issue I'm surprised to see is not posted more often...maybe that means it's easy? I am working with Windows NT event logs and trying to calculate the difference in logon and logoff times for the different users that have logged onto the machine..... ...more >>

We've recently migrated from mdb to adp/sql server 2000. We used to have events attached to combo boxes such that when an item was chosen (change event), the event would cause another field in the same record to be set (set value macro). Now that we've migrated to adp, the event seems to tri...more >>

Hello, I'm trying to configure my MSDE 2000 installation to dump all databases and transaction logs to disk every night to be backed up by our backup software. All goes great in configuring the maintenance plan until I get to the retention part. I want to configure the backup plan so that ...more >>

Hi all, Hope someone can help me with this ... This is my query. The problem with it is that it only returns Areas with >0 Topics. So if a new Area is created, it hasn't a topic until one is created, and it doesn't list! Is it possible to return even those rows where the count is 0, or ...more >>

Hi, I have a need to process a column of data and get information from SQL 2000 and return it to the Excel Spread Sheet. The data will be a list of order numbers in column 1. I need to look up each order number and return infomration relating to the order from SQL. Can anyone point me to...more >>

I'm trying to come up with an elegant, simple way to compare two consecutive values from the same table. For instance: SELECT TOP 2 datavalues FROM myTable ORDER BY timestamp DESC That gives me the two latest values. I want to test the rate of change of these values. If the top row is a...more >>

I have a query that returns raw tick data from a table. Unfortunately after even a few days there are hundreds of thousands of rows so the following query is not efficient. SELECT * FROM RAWTICKDATA WHERE Status = 'I' AND ContractCode = ? AND RawTickID = (SELECT Max(RawTickID) FROM RAWTICKDATA...more >>

Hi all, Is there any obvious way to sum only certain rows. I suppose it's similar to cube or rollup but I can't get either of them to work. what I basically have is this... CREATE TABLE #TempTable ( [GLD_ACCTNG_PER] INT, [OrderNum] INT, [SummaryDescription] varchar(50), [SummaryAmoun...more >>

Hi Sir: Is any possible to run DTS package from Command Line ? Lucas ...more >>

Hi, Is it possible to install more than one instance of SQL on the same server? I am thinking of the SQL that comes with Windows 2003 SBS (Small business) -- Thank you Please post only ...more >>

i am beginer in vc++.i want help in the following questions. How can i create database program using sql server through codings.If we want DSN name it also create through codings. if u have any easy sample program please sent the following mail id. nevis_soft@yahoo.co.in...more >>

I have a DTS package that is importing a fixed length file. After installing SP3a (on PERSONAL & DEVELOPER edition) it will not allow me to assign more than 125 fixed length column positions. After hitting the Finish & OK button it just wipes out the column settings. I've reinstalled both Pe...more >>

I'm trying to generate a normalized XML document out of SQL server that reflects the data structure of a table. Eg. This is what I would like to get <table name='MtFeedback'> <field name="MtFeedbackIy" type="int"/> <field name="Title" type="varchar" size="50"/> <field name="First...more >>

First of all, I apologize if coalescing is not the right term to describe my problem. I have a tree where each node has the same set of attributes (is the same entity) but child nodes should inherit attribute values from parent node. for example, say I have the following table: (nodeId int ...more >>

Hi all, What are the fundamentals (fundamental functions) that most small to medium sized organizations that use MS SQL Server 7 or 2000 value most? What's your insight? OK, here's my biased definition of small to medium sized organization, annual revenue from 20m to 300m. Thanks. DL...more >>

I have been testing our SQL Mail setup in SQL Server 2000 (sp3a) and have found that when I attach results as a file, every other character is a control character which causes each real character output on a separate line. I have no idea why this is happenening, I've never seen it before. The c...more >>

I have a variable that I am passing to a stored procedure from a propritery software application. The variable it passes is the number of days that have passed since 1/1/1900. I cannot seem to locate a convert statement that is applicable. Any guidance would be greatly appreciated. Thanks...more >>

Hello... I am running into a problem while running a query..can some1 help.. this is the query : ************** SELECT * from Table S where S.dtDate1 BETWEEN dateadd(year,1,dateadd(month,-1,getdate())) AND dateadd(day,-1,(dateadd(month,1,dateadd(year,1,dateadd(month,-1,getdate()))))) *******...more >>

I have to write a master detail query, in which the detail record should be stored in a variable as Comma Seperated Values. Can anyone help me...... Sun *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, Is it possible to use wildards in SQL to drop a constraint on a table? Thanks!...more >>

Dear Expert, How can I reuse the column, instead of select the whole things again. Example as below : select column1 as A, column2 as B, column3 * A as C from dummy ; in MS SQL I have to do like this, select column1 as A, column2 as B, column3 * column1 as C from...more >>

Hello All, I'm trying to write a stored procedure which tracks the insert event in a Table A. When we insert something in Table A in Database 'FMDB', it inserts the same information in Table B in Database 'Wartung'. When I insert something with insert query visa SQL Query analyzer, it work...more >>

I have 1 table in a 200+ table database The database is Merge Synchornised and has been working fine for 2 years + The same database is at several customers and the DB is fully relational I have a table which creates client timeout errors whenever an insert or update is issued The table h...more >>