hello, can somebody show me please how to solve this structure of the first table id (primary key) f1 (varchar field) nr (numeric field with values from 1 to 100) structure second table id2(autonumber) id (integer value ) f2 (varchar field) the value from table 1 have to be insert...more >>

I am playing with the CTP if SQL 2005 and loving it. However I was under the impression that this new SQL server version WOULD support separate date and time fields. Is this planned as a last minute change before release? Reasons to have separate DT fields: 1. Tracking dates where we cou...more >>

When an user opens any form to alter some given, if or user to open the same screen and to try to consult the same registration everything is joined until that the first user liberates. However, the times an user is in the office and the other in the branch, the second is without to know that is ...more >>

I have a 250 MB XML file that I need to put into a SQL server database. I remember years ago I did something in VB where I could stream a .CSV file straight into an Access Database. I can't remember how I did it though. There should be a really slick way to bring an XML file directly into S...more >>

Hi, I need some assistance with a query. To be honest, I'm not even sure it can be done. I'll try to keep the information limited to only what's relevant to what I have and what I am trying to achieve with this query. I have a table that contains around 100,000 records. For the sake of this...more >>

I read the message with the subject "Can I recover?". It states that the user only has a copy of the database backup in February and he executed an update statement without a where clause. He wants to know if it can be recovered... From what I know, if the February backup was a Full backu...more >>

I'm trying to write a query that I can fire off from my VB6 application to see if a table exists in SQL Server. I have found several that use multiple lined Transact SQL but the error out on me. Is there a simple query I can use suitable for passing through an ADO command string? I ne...more >>

hello everyone, just having trouble with an update statement. so i started off with a table like so: create table foo ( id uniqueidentifier not null primary key nonclustered, name varchar(50) not null, type int not null, datecreated datetime not null default getdate(), constrai...more >>

I am trying to write a trigger that will update the field linedescription in my commondata table depending on what is entered or changed in the field specname in my components table. I created the trigger below, but it does not work??? Please help? CREATE TRIGGER [EleSpecInfo] ON [Compone...more >>

Can I trigger the xp_sendmail using Lotus Notes? What do I need to get this going? TIA -- Lito D...more >>

Hi All I have been told to write a script that runs the following statements on a production sql server database: Use Db1 Go UPDATE dbo.tb12 SET ColNotified = 1 WHERE Status ='A' Go I dont know where to start from and where to even look to do all this. Pls hlp. Thank you i...more >>

In BOL I've been reading up on OpenXML, sp_xml_PrepareDocument, OpenRowSource, OpenDataSource, etc, but have not yet found a way to link to and query an XML file. What I'm looking for is something like sp_xml_PrepareDocument that will let me read an XML file from disk. Suggestions? Thank...more >>

A week ago, I had to change my view to 'Results in Text' in SQL Query Analyzer. All I did was choose 'Results in Text' from the menu and ran my query. Now, whenever I open SQLQA, it always puts the results in text, instead of results in grid (which is what I want). I've looked in the opti...more >>

I have two tables, one with basic info about employee and the other one with hierarchical data (employee ID, supervisor ID) Following query returns the name, id and child count. Problem is that it returns the entire table. I am only interested in records whose supervisor id is 55 (or whate...more >>

I have a database that will be accepting foreign characters from different languages, as in Germany, Russia, Japanese, Chinese and so on. I was wondering if there was anything different you need to set up on the database for this to work properly, as I am currently working in a database and an...more >>

Hi all, I've got a SQL 2000 SP4 server with a database that has 3 data files and 2 logs files. I no longer need the 2nd log file and I would like to remove it. How is this best accomplished with no or at least extremely minimal downtime. Is it done the same way I remove a data file? D...more >>

Hi, How can I change the Identity Property of a column for an existing Table which contains data? I also need to change Seed and Increment. If I change the Identity Property of a column Object then I get the Error: [SQL-DMO]Modifying existing table column is not supported through this ...more >>

An update statement was made against a table that did not include a 'where' clause and hence all the records were updated and basically destroying all the data. There is no recent backup of the database ( the last one was in February). Is there anyway to get back to the the way the table was bef...more >>

Hello, How can i truncate tables where there are references to foreign keys? Normally is use the truncate table statement. Anyone knows a simple solution for this. Thnx...more >>

I would like to have a procedure that I can call that will drop all foreign keys. I can get the constraint name from sysobjects if I select all fkey constraints, but how can I get the associated table name so that I can plug that into an alter table statement? I appreciate any suggestions....more >>

Does anyone know how to make a store procedure that takes a string and concatinate with another string to form a table name. For example, I have a table name 'tape001' and 'tape002'. I have a store procedure name spShowTape. I want to print results from table tape001 by calling 'exec spS...more >>

I have an appointment table (appts) and a charge table (charge). For the day the query is run, I want to return anyone with an appointment that has a balance on the charge table. I am looking at doing a subselect but I'm having a syntax problem. select APPTS.ACCOUNT from APPTS wh...more >>

Hi How to check the indexname is exist in the table (WHERE name = mytable.indexname)? IF EXISTS (SELECT name FROM sysindexes WHERE name = mytable.indexname) DROP INDEX mytable.indexname Thanks. ...more >>

I hope this makes sense and is not too general. I have a stored procedure where I use cursors. I would like to wrap a = code block making it part of a BEGIN, COMMIT, and ROLLBACK transaction.=20 Is there a certain recommended way to do this? Thanks, Yosh...more >>

I've added a column to my table as a computed value, pretty much only to populate it for the existing data. I want to do this, then drop the computed value, make it's new column NOT NULL and lay over it a unique constraint. Can I drop the computed value w/out dropping the column? -- Lynn...more >>

Hi, I have two servers MM1 and MM2 each with a database named DBA. I want to create a Multi step job on MM2 that will backup MM1 DBA and restore it on MM2 DBA. I can code the restore SQL on the MM2 DBA, but how does one code the job step on MM2 to backup a the DBA database on MM1. The...more >>

Can anyone give me an example on how to use DECLARE to create a table variable? Thanks in advance Dimitris ...more >>

Here are my tables CREATE TABLE Employee ( Employee_ID [int] IDENTITY (1, 1) NOT NULL , Name varchar(30) ) CREATE TABLE Employee_Hierarchy ( Employee_ID [int] NOT NULL , Parent_Employee_ID [int] NULL) I need a query where given an employee_id, it should return the name of all the...more >>

I have a table with Names and Dates in it. AppName Date App2 9/6/2005 11:22:38.00 AM App2 9/5/2005 09:18:23.00 AM App1 9/6/2005 11:22:23.00 PM App1 9/6/2005 04:09:11.00 PM App2 9/4/2005 08:01:17.00 AM I need a select statement tha...more >>

Here is what I am wanting to do. I have webpage that displays a report. The users can choose to show a single day(past or present) or a range of date. What I would like to create is a stored procedure that I can pass a start date and an end date. based on the values passed, return the appropr...more >>

Anyone know why this would happen... I added a reference to the SQLDMO COM object, imported it on top of my code.. then this test code fails Imports SQLDMO Module Module1 Sub Main() Dim i As Integer Dim oNames As SQLDMO.NameList Dim oSQLApp As SQLDMO.Application oSQLApp = New ...more >>

Hello, Thank you for reading my message. I would like to copy data from one database that gets its tables truncated every three days to an another database that will act like an archive of the first database. I tried using the differential backup strategy but it did as I expected only backe...more >>

I created a table in SQL Server 2000 with this code: CREATE TABLE Sales_Order (Customer varchar(8), Product varchar(5), Quantity int) and then entered some values. Later I tried to use this PIVOT code: SELECT * FROM Sales_Order_ PIVOT (SUM(Quantity) FOR Product IN ([Bike],[Chain])) AS ...more >>

I'm running dbcc checkcatalog('DB') and I'm getting the following error: Table error: Object ID 98815414 (object '98815414') does not match between 'SYSCOMMENTS' and 'SYSOBJECTS'. I have checkcatalog with repair_allow_data_loss but it doesn't fix it. I have also used checkdb and checktable...more >>

Greetings, I like to write my inner joins as below, but someone at work tells me its not as 'performant' as using the 'inner join' statement. Is this true ? Is there a better way to write it ? thanks Mike SELECT count(*) FROM resources a, assignments b, timesheets c, timesheetpayr...more >>

I have a table with 2 million + rows. I need to allow the user to do a query such as is shown below. I have full text search enabled on this database, and have built a text search catalog for it. The problem is, that I keep getting timeouts on the query. Granted, I can increase the timout ...more >>

Is there a quick way or a SP to know or calculate the size of a table in a SQL database Thanks in advance Salam...more >>

I run the below on the box that has psExec installed as sa (dbo) in QA. The MSSQLSERVER service is set to Local Account. Domain\Administrator will run c:\psexec \\10.2.27.230 -I cmdmgr_Resume.bat from a CmdExec job sucessfully. I run same from command prompt successfully. Do I have to set MSSQL...more >>

Hi All I have a procedure which runs to do various tasks but I have one particular task which reads maximum numbers from two tables (one current one history) and then takes the highest of those two numbers and increments it to get the ID number used to insert a new row into the current tabl...more >>

In QA I can alter a table with ALTER TABLE dbo.Incidents ADD NewIncident int NOT NULL default 0 However later on I wish to remove the default on this column. However upon creation the defualt is given a name like DF__Incidents__NewIn__05D9AC15 Can I a) Give a name to the default upon cr...more >>

Hi, I have been using the isql command via the xp_cmdshell in MS SQL for some time now for the purpose of creating pre-formatted articles for our press department (saved as .xtg format files for input into Quark). This works extremely well, and any "PRINT" statements in the sp are spooled o...more >>

Hello, I have a problem with creating INSERT statement. I have 3 tables, which look something like these: PLANS ------ id_plan ..... TasksOfPlan ------------ id_tasksofplan id_plan task DETAILS ------- id_details id_tasksofplan date hours All ID's are autonumbers. I wa...more >>

HI to All! Is there anyway to improve the performance of Queries involving Substring clause. i have indexes on the query columns but performance is not good. e.g if i use a query without substring it gives me result in less than 1 seconds over a more than 1.3 million rows and when i use subs...more >>

At the moment, we don't have a development server and develop on our production server. We develop on "DEV_MyDatabase" and then deploy changes to "MyDatabase". This has 2 problems: (1) linked views from other databases have to change, and (2) sometimes we accidently go into the wrong data...more >>

Hi folks! I am wondering if anyone out there has been able to use the NOT FOR REPLICATION field constraint when implementing a manual replication process? From what I have read, only the inbuilt replication methods can actually insert identity fields without SQL Server happily updating it's i...more >>

Dear All Can I Alter tables to change the columns orders, Or Add Column in a specified order? How? Ahmed ...more >>

Hello, Apologies if this is in the wrong newsgroup... I have followed the tutorial in Books Online that is called "Creating the nwind Virtual Directory". Everything looks ok but I get an error that says: - "HTTP Error 404 - File or directory not found. Internet Information Services (IIS) whe...more >>

I just inhertied a database. In it are multiple tables that keep track of a users profile. In each table is a modified_date field. That date only relates to that table and not the entire profile. There was never a central modified_date for the user. I need to be able to check the users ...more >>

Hi I've a varchar field and I need an SQL to get all the rows where this field has 2 points Field1 row1 pippo.it row2 pluto.venice.it row3 minny.ba.it In this case row2 and row3 Can you help me? thanks ...more >>

Hi all, Is there some way to calculate the date for the monday (monday is first day of week where I live) of a given week? I.e. given the week number 36 the function should return September 5th, 2005. Regards. Sune ...more >>

Test post - please ignore. For some reason, when I joined this group, Outlook Express didn't show any messages. Cheers, Rob. ...more >>

Consider the following two queries which are return identical results. The only difference is that in #1 the expression to limit the records matched against UserProperties is performed in the where clause whereas in #2 it's carried out in the join. Is one anymore efficient than the other? I ha...more >>

Hi, I want to write a sp which gives me the relation between a table and the stored procedures which belong to that table. I mean, lets say USER table and GetUserDetail ( select * from USER where ......) sp exist. GetUserDetail is dependent on USER table. How can i get stored procedure...more >>

Program Error establishing a debugger session with the server. See debug log for more information. Why? What do I should? Thanks! ...more >>

Hello, I have a question about the executing of an SQL clause in xp(extended stored procedure). I saw the examples about the ODS: xp_gettable_dblib and xp_gettable_odbc. When I call xp_gettable_dblib, this xp execute the SQL clause in session, which is different from the session from which it i...more >>