Hi All, I have a query which returns rows like this: Week Year Name Amt 15 2003 Name01 35.0 20 2003 Name02 8.0 15 2003 Name03 36.0 16 2003 Name04 2.0 15 2003 Name04 20.0 13 2003 Name05 3.0 14 2003 Name05 3.5 15 2003 Name05 6.25 16 2003 Name05 4.0 17 2003 Name05 5.0 18 2003 Name05 9....more >>

Hi, I have been trying to debug store procedures in my C# applications. I have found some vb examples on the internet and followed it. So far it doesn't work. Is it possible to do this in C#? or is this something that I can only do in VB. Maybe I'm doing something wrong. Here is some inform...more >>

Hi, we use VB & command object to update SQL 7.0 database. We had this strange problem. VB DLL returned "Communication Link Failure". Can I get some information on show to solve this problem, or how the problem can be repeated. Thanks alot & regards Ravi ...more >>

Hi Guys, I have a question, an immediate help is requested. create table try (id int, status int, dob datetime) combination of all 3 fields forms a primary key. data is as follows: ID criteria dob 1 30 2003-01-01 00:00:00.000 1 60 2003-01-10 00:00:00.000 2 60 2003-01-10 00:00:00.000 2...more >>

Scenario: My trigger code uses sp_OAMethod which will call a COM object method to insert data into another system. I check the return value from sp_OAMethod and from the methods return parameter. On success or failure of the method I log an entry into a table from within the trigger. If ...more >>

Thanks. But I am using the ADO query to update the text as=20 in the following: Ado.Edit; Ado.FieldByName('DataText').AsVariant :=3D WideStrVar; Ado.Post; The '=E7' will be converted to 'c'. How can this be solved? Lou >-----Original Message----- >If your database's non-Unicode code ...more >>

Hello, I am trying to create a join that will combine all information that is the same and also give me all the information that is different from both tables. I tried doing a union but I do not have a equal number of columns between tables. Right now I am doing a left outer join but it only ...more >>

SQL SERVER 2K We have 30 databases each for one business units. Now I am consolidating few tables from 30 databases to one database for Analysis purpose. Now my tables in Central db have millions of records. I need some tips to handle this huge tables for query purpose (already applied wit...more >>

Hi there. I have filled a temp table which has the follwing data: Date %-Gesamt %-Projekt %-Other 2002-01-01 90.27 67.25 23.03 2002-01-02 80.69 71.25 9.44 2002-01-03 80.72 67.66 13.06 2002-01-04 74.9 62.37 12.53 2002-01-05 90.44 71.68 18.76 2002-01-06 11.25 10.69 0.56 2002...more >>

Query to find the table name from any given field/column name? ------------------------------------- Say I have two tables, I want to return the table name given a certain field. My proc will create a working temp table with have a fieldname and a value (N,V) pairs I will then create a ...more >>

Following is my query: declare @dtStart datetime, @dtEnd datetime, @sdt smalldatetime, @sdt1 smalldatetime set @dtStart = '2003-07-01 00:00:00' set @dtEnd = '2003-07-30 23:59:00' set @sdt = convert(smalldatetime, CONVERT(varchar(8), CONVERT(varCHAR(8), @dtStart, 112)) + ' ' + convert(varch...more >>

How to do to create for instance, a called field to WALK that can be underground, earthy, 1o floor, 2o floor, etc. I used: create table ionarios( n_func int not null primary key, nome varchar(80) not null, WALK set('subsolo','térreo','1o walk','2o walk') not null, ... ...more >>

trying to get 3,510.92 as result from.... Select convert(SMALLMONEY,3510.92,1) midl CONVERT (data_type[(length)], expression [, style]) bol says that style 1 will format with commas but I've tried every variation I can think of. Value Output 0 (the default) No commas ...more >>

this should be a comman task. how can I enforce that the rows to insert to the table have unique key values? I am writing the C# code in which I try to update the SQL database. When multiple users try to insert into tables the key that is unique in the local key space could be non- unique ...more >>

I am trying to create a table by passing the name of the table to create. Here is a section of the sp. Any help is appreciated. CREATE PROCEDURE [dbo].[sp_CreateMyTable] @TableName varchar(255) AS Set QUOTED_Identifier on Declare @strName varchar(255) IF (@TableName <> '') P...more >>

i have an interesting problem (may be simple to experienced programmers): i want to create an n x n table that represents an n x n matrix, where there are n rows and n columns. the 1st row has values that equal the column names (this is like a crosstab query in access). the trick is that r...more >>

I have about 12 pages of FOXPRO codes to be written up in SQL. However, there is a SCAN command beginning in page 2 and ENDSCAN ends at page 12. The SCAN command in FOXPRO is for processing one record at a time. It will move to the next record when it reaches ENDSCAN. Within the SCAN- ENDSC...more >>

I have embedded SQL statements within a C source module. When I compile the output of the nsqlprep utility, with Visual Studio 6.0 (and Visual Studio 6.0 libraries), the compilation completes successfully. However, when I precompile this same module, using nsqlprep, with the Visual Studio....more >>

Hi, Is it possible to execute a Stored Procedure (sp_B) from within another Stored Procedure (sp_A) and insert the results from sp_B into a temporary table in sp_A? Thanks, Carl ...more >>

I'm trying to find a way to do a replace a in text data type. I have a fairly good idea of how to write it, but I was curious if someone knew of one that existed already. ...more >>

Whenever I try to do a large update to my SQL database 10 minutes through the update Query I receive this error message Could not allocate space for object '(SYSTEM table id: - 333902149)' in database 'TEMPDB' because the 'DEFAULT' filegroup is full.. What causes this? How can I set th...more >>

There are times when, based on security or other constrants, not all fields of an update are not defined and I need a way to tell the proc not to update those fields. Is there a way to do this? In the code below, I would like to have a way to have a way to leave pkDinersStatus as it current...more >>

I have a tag table: tagkey,tagname,description... etc. 12,'MetGB021WT','XYZ' 13,'MetGC021WT','X1Y1Z1' 14,'MetGD021WT','X2Y2Z2' ....... I have data table tagkey,datetime,value,quality 12,'2003-01-01 00:00:00',23,192 12,'2003-01-01 01:00:00',23.12,192 12,'2003-01-01 02:00:00',23,43,192 ....more >>

I am getting this error 7405 which is 'Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query' in so many inconsistent ways. For eg. when stored pr...more >>

How can we update (re-compile) a view when the underlaying table has been modified. In some views we are using SELECT table.* statements? TIA, Rene p.s. For people that don't know this problem: when a view is using a SELECT * statement and fields are added/removed from the table the vie...more >>

Mr. I have a file TXT (separate with '; ') that need to matter for SQL SERVER using DTS. One of the fields of the table destiny is of the type SMALLDATETIME and it accepts null values. Only that DTS always imports him/it ' 1/1/1900 00:00:00 ' instead of NULL. What do need to do to correct ...more >>

would like to know if I am using my transactions correctly, former: begin tran insert into... update... commit tran the problem is that the bank is joined while it doesn't liberate the transaction, any user it gets to use. This certain that? ...more >>

Is there functionality available that would judge the cost of a query before running and let the user know that what they are attempting to do will take a while? I have used execution plans before, but is there a way to return information that could be displayed to a user before the query...more >>

Setting Database Compatibility Level in SqlServer7 ------------------------------------------------------------------------ When you right click a database in Enterprise Manager there is a TAB "Options" that gives u the option to set the Compatibility Level. How Would you set this in SQL7....more >>

Is there any way to load balance a session in SQL Server so if that session is performing a CPU intensive task it would not take down the whole server. Thanks ...more >>

We just upgraded from SQL 6.5 to SQL 2000. We also have moved SQL Server to a much beefier machine. Actual data access in our database is much faster, but we've noticed that the speed of the application itself has slowed down some because sp_sproc_columns now seems to take quite a bit longer to...more >>

I have a text column w/ a character (=E1) that I want to=20 delete. REPLACE(mytextfield, '=E1', '') does not work w/=20 text field? =20 Any ideas on how to deal w/ this?=20 Thanks in advance, Chris...more >>

i've a table with clustered index. one of my queries took 2min 40 sec when i have only clustered index, but when i add one more non clustered index it's taking 9min. noticing this, i deleted non clustered index and teste again, it took only 2 min, why adding non clustered index taking 9 ...more >>

I have a tag table: tagkey,tagname,description... etc. 12,'MetGB021WT','XYZ' 13,'MetGC021WT','X1Y1Z1' 14,'MetGD021WT','X2Y2Z2' ...... I have data table tagkey,datetime,value,quality 12,'2003-01-01 00:00:00',23,192 12,'2003-01-01 01:00:00',23.12,192 12,'2003-01-01 02:00:00',23,43,192 .....more >>

How do I convert a Char(4) column to numbers. For instance, 1990 is stored as char. I want to convert to number and be able to increment it by 1. Thanks in advance....more >>

Is there any way (accessing a system table?) to create what would be an "on Delete" trigger for every table in the database? I would like the same SQL code to be performed whenever a user deletes a row from any of the tables in our databse. In addition, an indication of the table that wa...more >>

Hello, I am new to using SQL and have a question regarding triggers. What I am trying to do is when one field in database1 is update I want a trigger to go out to multiple databases and set a field in database1 equal to a combination of those fields. So far I have gotten it to work wit...more >>

I created a linked server, I set linked server login as EXEC sp_addlinkedsrvlogin 'servername', false, NULL, NUll,Null ( I understand all users in host server should be able to access the linked server) I can run the select statement from the host server, but when the insert trigger is ...more >>

Hi, I am developing Client/Server application using VB 6.0 and SQL 2000. This application involves record locking. This means each user once open a record for add/update/delete, then other users can't access the same record. I was thinking doing this at application level with VB 6.0 and ...more >>

I use the linked server MS SQL with another MS SQL (2000). I need to use stored procedure on linked server, but in documentation says "Although the query may return multiple result sets, OPENQUERY returns only the first one" Can i another way to getting more as first one result without rewri...more >>

I'm trying to use the OPTION clause in a view which keeps returning a syntax error. If I run the sql code for the view by itself, it works fine but it almost seems that I am not being allowed to use OPTION in a view. Here's a scaled down version of what I am doing: SELECT f._obsD...more >>

I have a table that contains meter reads (lets say for a water meter). Here's the (simplified) table and some data.... CREATE TABLE [dbo].[MeterReads] ( [MeterID] [int] NOT NULL , [MeterReadDate] [datetime] NOT NULL , [MeterReadingDialOne] [int] NOT NULL , [MeterReadingDialTwo] [in...more >>

Hello All, Is it possible to trigger a full database backup on certain activities. For example if I want to perform a full database backup(automatically) after anyone performs a SELECT INTO or BCP statements. Is it possible? My database is in Bulk_logged recovery model and I am ...more >>

Dear All I am currently creating an SQL database and eventually place it on the internet. I would like to test it, but I thought, since I am new to SQL Server, I would like to test my viwes and stored procedures in an Access 2000 project file. The question is: do I need to have an SQL d...more >>

-- ****************************************************************************** -- JOIN "treatise" -- by Roger Williams [07/29/2003] -- ****************************************************************************** -- -- Create test tables -- IF EXISTS (SELECT * FROM sysobjects WHERE name =...more >>

I am not quite sure how explain what I am trying to do! So here goes … I have 2 tables T1 and T2. T1 has lots of fields that reference data from T2 via a reference code EG T1 F1 T2.F1 F2 T2.F1 F3 T2.F1 T2 F1 Reference co...more >>

I have a table using Full Text indexing on a column called Keywords: When I do a search on the database I am not getting results for certain searches: e.g.: Keywords field: 296924 : Electronica, Techno : Playful : Howly - 2.36 version. Upbeat trance techno beat with slight aerobics style...more >>