i am running windows 2003 server, visual studio 2003, and beta 2 of yukon . I am getting the error when i try to compile the assembly -see below. What am i doing wrong? Thanks,Peter C:\projects\yukon test 1>csc.exe /t:library /r:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Bin...more >>

How can I output the contents/result from a stored procedure to a text file ? Thx....more >>

Dear All, How can I format the sum of a numeric figure with thousand separator? i.e. if the sql return 1000 --> display as 1,000 Pls. advise...more >>

What are Has Indexes and how is it different from Clustered and Non clustered Indexes? Thanks ...more >>

hi, another question about sql server 2000 dts. before we drop an employee's account, we would want to make sure that his accounts won't be used in any dts package connections on all of our sql servers. is there an automated way (by code) that I can change this employee's account into...more >>

Hello, I have the following procedure. When I run this procedure and insert into the database the new record the @alldesigns field is always blank. Is there a limitation on concatenating variables: the line in question is set @alldesigns=@alldesigns + ',' + @designnote I hope this isn'...more >>

i need to sum a column in a table, which is joined to another table. It works fine, but I also need to get sums from a 3rd table which is joined, and when I try and do this, the sum from the other table gets screwed. i.e. tables and values a-> theID, locationName b-> theID, chickens c-...more >>

Hello, In our office we have one server and several laptops connected to our network. The application I'm writing will run on the laptops, and connect to the server for database access (currently running SQL Express 2005 for development purposes); the application both reads from and mak...more >>

I have the proper Data Source Connection and driver on my Windows 2003 server for accessing a Progress 9 database. I am able to use a connection string with Reporting Services to query that Progress Database without any problems. However, when I try to create a linked server for that Progres...more >>

I am trying to do a query that use the value of the first table if it does not fit a criteria on the second table. If it fit the criteria ('coff') then use the value on the second table. Select if tableB.c = 'coff' then tableB.amount Else tableA.amount from tableA join tableB on a=b ...more >>

I'm tring to do a query of the Sysobjects table to get index information. I've be able to construct a query for the table and column information, but I can't find the appropriate data for the indexes. I'm looking for Index name and index text or index fields. Here's what I did for table and ...more >>

How do I produce the following results from the following table? -- Desired results: clm_id type amt 0001 A 100 0001 B 200 0001 C 300 0001 D 400 -- Existing table & data CREATE TABLE [dbo].[tst_crh] ( [clm_id] [int] NULL , [type1] [nvarchar] (255) NULL , [amt1] [money] NULL , ...more >>

As part of upgrading our system to newer version, We have to update multiple tables which could potentially have several million records each (schema + data updates) and this is causing serious performance problems, sometimes even running out of disk space. The database size seems to grow beyo...more >>

Hi, I have a table with 3 columns: MatNr, Quantity, and Operation Date in quantity could be value (+) or (-). Table is sorted by 1. MatNr 2. Operation Date I am looking for solution to summaries quantity grouping by MatNr till SUM(quantity) is bellow zero. and then break loop and go to...more >>

I have to write an application that deals with clients in multiple countries. The addresses, phone numbers, country id[social security number] and currency information has to be stored into a database. Is there any white paper, or book or site that has information on designing a database t...more >>

How would I use a variable to select a time period as shown below. The example below returns error: Incorrect syntax near '@Timeperiod' Am i missing something here? Declare @Timeperiod as int set @Timeperiod = 7 Select * from X where (datediff(d, usdateopened, getdate() @Timeperiod)...more >>

I am not able to cature digits past 6 deep after the decimal point when I use division... Any ideas?...more >>

Hi there, I would like to see if anybody can recommend me a good paper related to designing data security, meaning for example, a generic scheme that can be used to determine what data can users see (for example, witch states they can see, what employee info they can see and so on...more >>

Hello every One, Can anybody teach me how to call a function inside a stored procedure.. I want to know it badly... thanks... ...more >>

How can I format the date to view it without the preceeding zeros? For example - I want to see 10/07/2004 as 10/7/2004. The purpose of this is that - I am using ASP script on my web page and the 'date' function returns the date as 1/1/2004 vs SQL where I get 01/01/2004 when I use the c...more >>

Hi all I was hoping you would know the answer to this question. I am trying to decide if I should change my triggers to a Stored procedure. The application is used by 5 to 10 people at once. No 2 people can have the same record set open for editing at the same time. I have restricted it b...more >>

wxp pro sp1 , sql-svr-2k sp3 Table1 has PK column "RecordID" (Identity=Yes, IdentitySeed=1, IdentityIncrement=1) Table1 also has the non-nullable column "LicenseNumber". Table1 doese not have a unique index or constraint on the "LicenseNumber" column. Table1 contains groups of rows t...more >>

I need to call a COM object method using sp_OAMethod that expects a string array as one of it's parameters. Is there a way to represent a string array in SQL? Thanks, Chris...more >>

I couldn't find a group dedicated to SQL 2005, so I'll ask here and please redirect me if it's more appropriate somewhere else. I'm not a pro DBA and don't always remember all the syntax to create views, joins, relationships, constraints, etc. That said, I'm very accustomed to enterprise m...more >>

I got this error message: The name 'CODE_CA' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. after running the following code in Query Analyzer: begin of code: declare @fname varchar(200) declare @str_movefil...more >>

Hi, I have the foll query in a stored procedure SET @sql = N'SELECT archive.quantity FROM customer,archive,iss WHERE customer.bill = "5000" AND archive.number = 002 AND archive.deliv = NO AND iss.number = archive.number AND iss-...more >>

I have SP in SQL Server: CREATE PROCEDURE Admin_BuySellCompanyInsertUpdate @CompanyName varchar(50) @Address1 varchar(50), @NewBuySellCompanyID int output AS INSERT INTO dbo.CompanyData (CompanyName, Address1) VALUES (@CompanyName, @Address1) SELECT @NewBuySellCompanyID = SCOPE_IDE...more >>

Is there any difference beetween importing stored procedures with osql and isql???? Is it possible that some stored procedures works differently if it's imported with osql or isql???? TIA. ...more >>

Hi all, I'm using SQL Server 2000 running on Win2K Adv Server, my query is: SELECT Amount, TaxAmount, 'TaxRate' = TaxAmount/Amount FROM Orders After execute I've got this result Amount TaxAmount TaxRate 8,800,000.000 800000.0000 .0909 5...more >>

The schema is a little complicate so I have not included it but hope you can understand what I'm getting at here .... I have something like SELECT ContactID, Group1, Value1, ... with several JOINS Each Contact can be in multiple groups. The SELECT returns all the Contacts and the groups ...more >>

I would like to have people email a certain address, and have SQL Server "suck in" those emails into certain tables on the database. Is this even possible? Thanks Owen PS. replies cc'd via email appreciated owen.southwood@mantix.com ...more >>

Hi, Is there a function available to calc the average, excluding the highest and lowest number, but not duplicate of the same? TABLE1 5 1 2 1 4 So 5 will be excluded since it's the highest and 1 since it's the lowest but not the second 1. Result should be 1 + 2 + 4 = 7/3. Thanks ...more >>

what's the best way to select return a record set of all rows that have been entered since midnight. I'd like to be able to run the query any time, and get all records for today since midnight. CREATE TABLE [dbo].[Table1] ( [c1] [name] (10) NULL , [d1] [datetime] NOT NULL , [c2] [char] (1...more >>

I have a DTS package that needs to insert the excel data into this table. [AgentLocatordata] ( [ID] [int] NULL , [Agent] [varchar] (10) NOT NULL , [ShortName] [varchar] (6) NULL , [BusinessType] [varchar] (6) NULL , [DisplayName] [varchar] (100) NULL , [BusinessName] [varchar] (100) N...more >>

HI,=20 I have a SQL string I would like to assign a string to based on certain = conditions. I use a CASE statement but keep getting an error. For example: declare @strSQL varchar(30), @value varchar(30) select @value =3D 'Blah' Select Case=20 when @value =3D 'blah' then @strSQL...more >>

Hello Experts, I created an INSTEAD OF trigger which doing some checks: CREATE TRIGGER [T_mytable] ON [dbo].[mytable] INSTEAD OF INSERT, UPDATE, DELETE AS If 'bla' <> 'bla' begin RAISERROR('no action allowed.', 16, 1) Rollback Tran end when Insert a record into mytable, even th...more >>

Hey all, I was wondering, is there an easy way to reset an autonumber field back to 1? thanks in advance, rodchar...more >>

I've got a SQL Server job created that I want to set/change the scheduled time for via a table trigger. I'm wondering how to do that. Specifically, I've put a trigger on a table so I know when records have been inserted. Once that happens (meaning records are in the table), I want the tri...more >>

I don't know if this is the right group. If not, please redirect me. I tried the DTS group and received no answers to this post. I know how to create tables (CREATE TABLE ...). What I would like to know is if I know what values need to populate the various fields in a table, is there a ...more >>

Getting an arithmetic overflow error and I don't know why... Here are some details: SELECT @@cpu_busy successfully returns 134217727 SELECT convert(int,@@cpu_busy) successfully returns: 134217727 declare @cpu_busy int SELECT @cpu_busy = convert(int,@@cpu_busy) returns error: Arith...more >>

I want to raise an error in my stored procedure and then have the code go to a specific part of the sproc to deal with errors before exiting. Is this the right way to go about doing this? e.g. if (condition) begin rollback tran raiserror goto on_error end --other stuff ...more >>

Does anyone know if there is/are a T-SQL command(s) to temporarily disable a trigger? (a bit like SET ANSI NULLS OFF/ON) ? All I can think of doing is editing the existing trigger with a "return" statement at the start. Or I could drop it, however then I will need to recreate it. S...more >>

While looking for efficient ways to compute a column with accumulated sum I saw a construction like this declare @tmp decimal set @tmp = 0 update table set @tmp = acc_sum = @tmp + value This method was indeed faster than any other I could come up with. However, it depends on the order in...more >>

Dear All, I am performing a EXEC sp_MSforeachdb @command1="print '?' DBCC CHECKDB ('?')" on my server each night, and was wondering how to send the results to myself. TIA...more >>

When i use in vb6 SqlServer 2000 connection all doing well. Then when i use MMC and terminate it, memory usage (using taskmanager) riseup automatically. Why ? I use WinXp Sp2, but this happens on every clients/server i try to use mmc. Why ? Does exist a way to programmatically stop memory us...more >>

HOW CAN I EXECUTE THIS ORACLE STATEMENT : EXECUTE IMMEDIATE ' SELECT FIELD NAME FROM TABLENAME WHERE CNDTN'INTO VARIABLE_NAME INTO SQL SERVER THROUGH SP_EXECUTESQL PROCEDURE ...more >>

If I have a number of datasets in Access, is it possible to pull the three datasets together and hook them up to an excel pivot table for analysis? How could this be done if possible? Is there an equivalent or better feature alternative to pivot tables in SQL? Can this be done without pre-co...more >>