Sponsored Links

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Page 16 of 27

« First

Last »

Threads in Forum : microsoft.public.sqlserver.mseq

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Getting values from other fields using min & max aggregates On Wed, 7 Apr 2004 13:26:13 -0700, Gabe Knuth wrote: In that case, try: SELECT Score_Min=MIN(b.Score), Score_Min_PersonID=(select MAX(personid)... Gabe Knuth	04-07-2004 03:47 PM Hugo Kornelis	2	102
Deleting Model, MSDBData, Master Databases Can I safely remove the model, msdbdata and/or the master databases from SQL2000 (they may actually have been from SQL7) without affecting the... Carl	04-07-2004 02:46 PM Vishal Parkar	1	107
Get other fields while using min & max aggregate functions Hi all. I tried to search the forum for this, but I'm not entirely sure how to phrase it to get the best results, so I figured I'd post and hope... Gabe Knuth	04-07-2004 02:01 PM Gabe Knuth	0	121
Number to Date. Hi, The accounts package that we use uses MSSQL for its database. One of the tables is for recording sales transactions. The due date field in... Dylan	04-07-2004 12:51 PM Vishal Parkar	7	161
Dynamic query...problem "SELECT FirstName, EmployeeID, LastName, BirthDate FROM Employee " + iff(@p1 = 0," "," WHERE (DepartmentID = " + @p1 + ")") this query is not...	04-07-2004 07:12 AM	0	96
timeout Hi i am using mssql7,and sometimes i am getting this error(Microsoft ODBC SQL SERVER DRIVER TIMEOUT EXPIRED) while upating and fetching data from a... shif	04-07-2004 04:09 AM shif	0	149
Why The Difference In Speed? Hello. If I perform this query: UPDATE table1 SET field1='Y' WHERE field1 IN (SELECT field1 FROM table2 WHERE id > 0 AND id < 100); ....it takes a... chris	04-03-2004 08:18 PM chris	0	91
Missing SELECT statement, but where?? H I have created a question in Access and then copied the SQL question from it When I try to run it in eg SQL plus I get an error. I can't see... Christina	04-01-2004 10:38 PM Vishal Parkar	1	112
Support Does Microsoft not support English Query anymore? I cannot find any reference to English Query and .NET. Does Microsoft not consider it to be used... justinr	04-01-2004 09:01 PM justinr	0	107
cannot select chinese records Hi all, I have some problem when selecting records starting with chinese characters in my SQL Server All records can be displayed when I type... Jerry Lee	03-06-2004 12:34 AM Steve Kass	6	179
Group Table By Date And Filter By Earliest Date Hi. I have a view that lists account number, course date, and location as shown below. I'm trying to get it so it groups the table by date, which... mj	03-04-2004 08:19 AM mj	4	137
explorer causing sql.dll error windows explorer is causing an error and closing, only to cause the same error "explorer has caused an error in sql.dll. explorer will now close. If... anubis_vamp	03-03-2004 11:25 PM anubis_vamp	0	124
Internal SQL Server Error on indexed views Hi, I am getting an "8624 - Internal SQL Server Error" on SQL Server 2000 SP3 when inserting into a table which is used as the source of an indexed... Simon Kissane	03-03-2004 07:35 PM Steve Kass	2	126
Code to Return Row Numbers in a Query CREATE TABLE #num (num int IDENTITY (1, 1) NOT NULL, uniqKey int NOT NULL) --Create with a primary key for a link back to the table(s) that will be... Morgan Smith	03-03-2004 11:44 AM Morgan Smith	0	154
How to assign values to a TEXT datatype in SQL Hi all, I have very email body content stored in database field whose data type is text. I need to retrieve this value in side the stored procedure... newbie	03-03-2004 07:20 AM newbie	0	162
date from datetime Does anybody knows how can i reterive date from datetime field .i don't want time .Thanx in advance saurabh Saxena	03-02-2004 07:23 PM Ray Higdon	1	156
Select From Clause can i use a variable in the from clause of a select statement Carl B	03-02-2004 02:28 PM Anith Sen	2	118
SQL Server 6.5 Hi, I hit a message 'could not insert a backup or restore history/detail record in msdb.dbo.sysbackuphistory or sysrestorehistory. This may indicate... GW	02-29-2004 10:29 PM GW	0	117
Cannot Restore SQL 7 Database backup error message Dear All Please help me, i am using sql 7 and NT back office ver 4. my Auto shrink option was not selected hence the log file has increased by HUGE... Sujay Basak	02-29-2004 01:00 AM Nick Schueler MSFT	1	125
Shrinking SQL Server 7 log file in my database the Auto Shrink option was not selected hence the Log file has grown into 8 GB .... Now the db cannot be restored from Backup reports... Sujay Basak	02-29-2004 12:38 AM Nick Schueler MSFT	2	99
Re: Union query dropping "duplicate" rows hi don, This is expected behavior of UNION clause. The answer for your problem will be to use UNIAON ALL instead on UNION.Difference between UNION... Vishal Parkar	02-28-2004 03:51 PM Don Jellie	3	117
Arithmatic overflow with AVG? I've created a temp table with an int type field on which I am then trying to perform an AVG. I get: Server: Msg 8115, Level 16, State 2, Line... Mike Hoyt	02-26-2004 05:29 PM Anith Sen	1	145
Execute a stored procedure and place results in a temporary table Could someone please advise me on the syntax in Transact SQL to execute a stored procedure (that returns records) and then place the results in a... Alastair Bell	02-24-2004 12:02 PM Vishal Parkar	1	121
Joining Excel Database with MSDE Database Table, & Import My primary objective is to link an Excel worksheet with an SQL table, and then update the LOG_SOURCE column of the SQL table with the values from the... G. Benson	02-24-2004 08:41 AM G. Benson	0	77
SQL Command Line Consolidation My primary objective is to link an Excel worksheet with an SQL table, and then update the LOG_SOURCE column of the SQL table with the values from the... G. Benson	02-22-2004 07:56 AM G. Benson	0	114
SQL errors on start-up On startup I get erroe messages. Could not open SQLEV70.Rll SQL server\80\tools\binn\resource\1033\SQLSVC.RLL could not be loaded Run time error Charles Coggins	02-21-2004 12:15 PM Charles Coggins	0	151
INSERT I have ten tables. There is an ASP web front end. This is a work order and each table represents a page of the work order. They fill out the first... Darren	02-21-2004 01:37 AM Vishal Parkar	1	88
intersect function i just came across the "intersect" function and can't get it to work. i'm familiar with "union". i've copied the example from books online and i... burke	02-20-2004 03:46 AM Vishal Parkar	2	237
Script to copy table between databases I'm trying to write/find a script that will copy all data from a table in database1 to the same table in database2. The databases are on the same... newbie	02-19-2004 07:56 AM Vishal Parkar	2	148
How do I separate in SQL Hi, I have a field that uses "," to separate items Eg apple, pear, orange Monday, Tuesday, Wednesday, Thursday How can I split this into columns... Newbie	02-19-2004 05:14 AM Ray Higdon	2	112
Split Field or Extract a part I have been trying for some time to capture a part of a string to convert and sum a number accross my result set. The string looks like this: "abc,1... Robert	02-18-2004 10:21 PM Rohtash Kapoor	3	111
xp_sendmail Numeric Value Limitation. I am using SQL 7 xp_sendmail to send query results as a file attachment. It appears that the xp_sendmail does not allow long numeric value lengths is... Tim Martin	02-16-2004 09:46 AM Tim Martin	0	96
Convert string to Num I am using VB 6.0 with SQL 8.0. I want to convert string to number one of my field in table. I am doing something like this. EMPNo is string in... annu	02-16-2004 09:37 AM Rohtash Kapoor	1	160
SQL Commands(URGENT!!) Hi all, Can somebody tell me how to use SQL server from command line (i.e. sql's command line commands) thanx and regards Manoj Singh Manoj Singh	02-16-2004 02:31 AM Rohtash Kapoor	1	101
Help Primary Key violation I'm trying to port access DB to Sql Server database. With access I can insert several rows also if someone are present in the destination table. For... Andrea	02-15-2004 08:06 AM Andrew J. Kelly	3	118
Running SQL 2000 and Version 7 on same server and workstations Can we run a new program using SQL Server 2000 and an older program still running an SQL Version 7 database on the same network? We want to run both... Carolyn	02-13-2004 12:54 PM Cindy Gross	1	101
Connect errors (help!) While I am connecting to SQL server 2000 EE from a different client machine using Query Analyzer it gives me the following error message . Unable to... phil	02-13-2004 12:53 PM Cindy Gross	1	108
Locking a Record I have a multiuser application where the users will be asking to see and then update any record in a table. They will ask for the next... JoeTroia	02-13-2004 12:46 PM Cindy Gross	2	97
Interesting Updzte Hi All Got a interesting update statement that I am trying to perform. I have one table with a ID and 2 image fields, Image1 & Image2 I also have... Phil	02-12-2004 02:15 AM Phil	0	104
Need 0s instead of NULLs Is there a way to return "0" instead of "NULL" in a query? several columns that are from other views and are linked to a table where it returns all... Kole	02-11-2004 11:07 PM Rohtash Kapoor	2	105
DATE'S Hi All Just a quick thing can someone tell me what the format is when you want to convert the getdate() result to something like '11 Feb... phil	02-11-2004 08:10 AM Vishal Parkar	1	100
Need help with query logic I have a three tables: computer, accessory, monitor Each table contains a location and value. I want to write a query that will list all records in... brian	02-10-2004 07:06 PM Ray Higdon	1	107
Recreate joins between tables Hello Some replacement tables have been copied into the database therefore breaking the joins that where there I wanted to recreate the contraints... Rhonda Fischer	02-10-2004 06:24 AM Vishal Parkar	1	109
INNER JOIN and Parameters I have a web form that enters data into a table, wo_main, using an insert query. When submitted the form also inserts the same wo_number into... Darren	02-09-2004 01:30 PM Darren	0	100
send a query result by using SQL Mail error 2812? Error Massage: ODBC error 2812(42000)could not find stored procedure 'sp_setuser by login'. Exceute query is: USE master EXEC xp_sendmail 'SQLAdminX... lily	02-09-2004 10:57 AM James Goodman	1	162
LINKED SERVERS Hi all, I am having problems with refrencing a table on a seperate server than the one that I am working on (if that makes any sense) I have never... Phili	02-09-2004 05:29 AM Ray Higdon	1	95
User Function Syntax In the statement below, the function name need's to be prefixed with "dbo." to work. Is there anyway to make a User Function visible without... KLomax	02-06-2004 11:51 AM Vishal Parkar	1	108
how to select distinct rows from a table.. i want to select distinct rows from a table... can i use like this... select distinct * from table i need all columns of the table to be... krishna	02-06-2004 07:41 AM	2	98
select printing Table has 6 columns. One of the column say date contains date and null values. The same column I want to print in two columns as date and null... suj	02-05-2004 03:36 PM Vishal Parkar	1	172
QUERY Hi All It's getting to the end of the day and there is something that I just dont seem to be able to figure out. I have a number of... Phil	02-05-2004 02:21 PM Vishal Parkar	2	100

Page 16 of 27

« First

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off