Hi All, I need help to build up a query. The situation is like this: CREATE TABLE tblTest(ID INT NOT NULL IDENTITY(1,1), Qtr INT, Year INT, Amount FLOAT) SELECT Qtr, year, Amount FROM tblTest Qtr Year Amount 1 2002 100.0 2 2002 200.0 3 2002 300.0 4 2002 400.0 1 2002 100...more >>

Hello, I have a table called Agent which has 2 columns (AgentID and Phone). My second table is Phone_Numb (AgentID and Phone) I AgentID's are the same in both tables. I need to update the Agent table with the Phone numbers in the Phone_Numb table. Thanks for all your help!!!!...more >>

Hello, I created a DTS package to export data to flat file. This DTS package based on a view. Could you please give me a hint how to update this package dinamically every time when I update the view? Is it possible from C# code? Thanks, GB ...more >>

Hi, I have data like: Student Score John 83 Eric 76 John 93 John 85 Eric 72 I want to retrieve each one's highest score like Eric 76 John 93 I say : select Student, Score from Test group by Student, Score Order ...more >>

...more >>

I have two queries: 1) select * from machine1.db1.dbo.table1 where [varcharfield]='sometextvalue' 2) select * from machine1.db1.dbo.table1 where [guidfield] ='a-guid' Query #2 performs a magnitude worse than query #1. It looks like SQL is pulling all of the data from the remote table t...more >>

Hello there It seems to be wise that when i delete record with primary key all the records related to the table as foreign key will also be deleted. I can do this relation (as far as I know) when data in the foreign key and the data on the primary key are the same. But i can't do this whe...more >>

Using SQL2K I have an inbound Date Param @FiscalYear and it is a char(4) I want to use it in a Variable called Date Range Previously the code was written for use in Dynamic SQL so the whole things was written in a String context. What I am having trouble getting the correct syntax fo...more >>

I have a query, < select means, type from estimates > means type ----------------------------------------- ---------- 9.4033847799714302E-3 1 1.1766968108291099E-2 ...more >>

Folks, We're managing various types of transactions in our application, some of which have pretty complicated schemas. We've found, as the data in the tables increases, that some of our more complex reports are running too slowly. So we're starting to explore the idea of a separate table or d...more >>

Hi all, I'm stuck with it, I used 3 parameters: @fiscal_year, @last_quarter and @period Possible Values for @period : [1-4] possible values for @last_quarter : [1-12] so this procedure need to return two columns: quarter_year and quarter_mon let's assume that @fiscal_year = 20...more >>

I will be creating some "audit" tables that will essentially mirror some critical tables that will provide a snapshot of data before it's changed by a user. It's simple enough to get the db's user id if the table is updated directly from Query Analyzer or Enterprise Manager but I'm struggling wit...more >>

sql-svr 2000 in query analyzer ... connected to an external sql-svr ... how to tell the account username used to make the connection? (assuming sql-svr authentication or mixed-mode authentication) ...more >>

Hello, I have a job that runs a stored procedure that executes XP_SENDMAIL. It has in the past worked. I have tried to execute XP_SENDMAIL from SQA but it does not send any messages and states that the "command(s) completed successfully". As an operator I can send a test email from the pro...more >>

Hi, I have created two SPs returning recordset. Now I want to get the resultset as text (column data as text using some delimiter). Do we have anything which I can use to get text output ? OR how can I check result set is having result?? script sample would be appreciated. Thanks i...more >>

I can't seem to figure out how to execute an inner query (i.e., select @LastDate...), get the results, and use it in my final insert statement. What am I doing wrong.... Please help. ************************** here is all the code ******* drop table FetchLog go Create Table FetchLog (...more >>

sql-svr 2000 i use enterprise manager to "generate sql script" ... i include all stored-procedures & all user-defined-functions ... i leave the "generate the DROP ..." and "generate the CREATE ..." checkboxes checked (as is the default) ... i connect query analyzer to the target databas...more >>

I have a proc that looks like this: InsertEventRecord(@sEvent varchar, @sResult varchar,@dtData datetime, @sInitiator varchar) When I call it in Query Analyzer like this: exec dbo.InsertEventRecord 'FileImport','Success',GETDATE(),'System' I get the following message Line 1: Incorrect ...more >>

Hi I defined following table in SQL Server 2000, table1(f1 char(2)) and now I want to show following output(add record number): rownumber f1 --------- ---- 1 aa 2 ab 3 bb 4 bc how can I do it? I'd be thankful for any help. -- Using ...more >>

I tried to use CASE statement within the WHERE clause to set up different types of query but it does not seem to work. Am I doing anything wrong? Ex: ....WHERE indicator='Y' and case @type when 0 then 'num!=@type' else 'num=@type' end Sincerely, Wayne ...more >>

Hello, My name field in user table combines last name, first name and middle name. How do I return full name in alphabetical order like the following after typing search criteria "Smith". Smith, Aaron Smith, Aaron A. Smith, Aaron Brian ...more >>

I am using the following code to import month to date transactions. Within the BOLDetail table I need some additional information about the Supplier, Product, and Carrier, which resides in the SupplierInfo, ProductInfo and CarrierInfo tables. I'm using the JOIN statement to access that informatio...more >>

I have a select statement which returns this: order_id prod 1 'Prod 1' 1 'Prod 2' 2 'Prod 2' 2 'Prod 5' But I really want the data "flattened", i.e.: order_id prod 1 'Prod 1,Prod 2' 2 'Prod 2,Prod 5' Does anyone have a good ...more >>

I am putting HTML as a string into a cell of a table which is set to Varchar (8000) for data type. This is read back by a stored procedure and used as the body of an html email. My problem seems to be that the database thinks that there are more characters in the string that there really are. ...more >>

Hi ! Is there a simple way to Search in all tables from MSSQL DataBase ? Thanks ...more >>

When I create a datetime column, de field contains date and time, example: 10/10/2003 - 11:59:59 How can I create a column just date and a column just time???? ] How can I insert a datetime value??? INSERT INTO table VALUES (????????) Thank's And, please, see the "Inserted & Deleted" po...more >>

Hello, I am trying to learn how to create a stored procedure (school project - not required to create a stored procedure, but thought I would give it a good try). I want to create a procedure which has a select statement which returns a number of rows. I am going to call this procedure from ins...more >>

&#25253;&#38169;1058&#65306;&#26080;&#27861;&#21551;&#21160;&#26381;&#211= 53;&#65292;&#21407;&#22240;&#26159;&#21487;&#33021;&#38506;&#31105;&#2999= 2;&#25110;&#23427;&#30456;&#20851;&#32852;&#30340;&#35774;&#22791;&#27809= ;&#26377;&#21551;&#21160; &#25105;&#27809;&#26377;&#25913;os&#30340;&...more >>

Hello everybody, How can i set the job result to ERROR? Thanks Leandro L S Vitoria - ES BRAZIL ...more >>

Hello, I have a table that has the following structure:- Ref, Product, Goods Value 1,Prod1, 50 1,Prod2, 60 1,Prod3, 20 2,Prod1, 25 2,Prod3, 5 2,Prod3, 19 3,Prod1, 5 etc. -------------- I need to produce a view that shows the highest product value in the reference e.g Ref, Prod...more >>

Hello, We have copies of SQL Standanrd and VB 6. We would like to produce automatic report from our server on a nightly basis and was wondering about best practise. Thanks Julie...more >>

Hi All, Does anybody know of a way to clear a systems application log from either TSQL or VBScript? Any help much appreciated. Thanks, Steve ...more >>

Hi All I am trying to return all records with a length less than 8 with leading zeros. Below is an example of what I am trying to achieve: create table pad ( col1 VARCHAR(10) ) insert into pad values ('1') insert into pad values ('12') insert into pad values ('123') inser...more >>

Hi, I have a table (30 columns, 100,000,000 rows, 10GB) with some computed columns. If I change the formula of a computed column (by the Enterprise Manager) it takes very long time (2 hours). Is it normal? Why? The column is not indexed and is without statistics. Thanks for answer Marti...more >>

How do you compile c program to access the sql server data? Can it support embedded sql?...more >>