| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | How can i automate updating all of the databases on a SQL
server. I would like to add an view to each database with
the server. Excluding system...
D.Dorsey
|
08-11-2003 12:32 PM
D.Dorsey  | 0 | 101 |
| | | Please help,
I open SQL Server Enterprise Manager and I try to
open SQL QUERY ANALYZER but nothing happended. Do I need
to set up something ? ...
don takeoka
|
08-09-2003 10:45 PM
don takeoka | 0 | 98 |
| | | look at osql in bol
Nigel Rivett
|
08-08-2003 09:41 AM
lindawie | 1 | 89 |
| | | 'User' limit may be the same as ~2GB. I woulg you are more concerned about
the maximum number of connections rather than users. You can do:
SELECT...
Anith Sen
|
08-08-2003 09:08 AM
Anith Sen | 0 | 92 |
| | | See following example:
note: you will have to make use of CONVERT function.
Ex:
create table #t(code int, endtime varchar(500))
insert into #t...
Vishal Parkar
|
08-07-2003 09:30 PM
JJ | 1 | 93 |
| | | How do you create a second table based on an existing
table. I have tried create table X as select * from y and
many other similar variations and...
Keltie
|
08-07-2003 07:07 PM
Nigel Rivett | 1 | 103 |
 | | I created a stored procedure in my database and it was working fine
yesterday. I added another column to my table and now receive this
error...
kidnap
|
08-07-2003 12:54 PM
kidnap | 1 | 203 |
| | | Err, this is possible only with SQL 2000. Probably you can use SQL Server
2000 client tools(Query analyzer) to connect to SQL 7 server. and try...
Jeff Schmitt
|
08-07-2003 08:22 AM
Vishal Parkar | 2 | 88 |
| | | I have 2 databases within SQL Server 2000. What I want to do is create a
view in database A that references tables in database B. Is that...
Micheal
|
08-06-2003 08:28 PM
Ray Higdon | 1 | 89 |
| | | Here are 2 statements, first is the one having problems:
(look at the Gals selection criteria and the answer).
SELECT l.OrdNo, o.OrdNo, l.LoadNo, ...
Christopher Borys
|
08-06-2003 01:13 PM
Christopher Borys | 0 | 113 |
| | | I want to create a 'view' but have a condition on a column based on another
column. Basically, I want to do this:
CREATE VIEW MyView
AS
SELECT ...
Micheal
|
08-06-2003 12:33 PM
Micheal | 2 | 96 |
| | | I would like to zip up 10 Gig backup files after the
backup is complete and then delete the backup file. Can
this be done automatically using DTS or...
Neal
|
08-05-2003 01:47 AM
lindawie | 1 | 103 |
| | | Is there a way to generate result files from SQL that have
all character fields enclosed in quotes? Any help would
be appreciated. Thanks
Steve
|
08-05-2003 01:44 AM
lindawie | 1 | 106 |
| | | Hi,
I might be posting this in the wrong section, but I really
need help with this, so if this is the wrong section,
please direct me to the right...
Brian
|
08-04-2003 03:56 PM
Brian Jorgenson | 1 | 83 |
| | | Can you post your table structure including column names, datatypes, keys
etc? Also post a few INSERT statements which can create the sample data...
Anith Sen
|
08-04-2003 03:16 PM
Rob | 1 | 98 |
| | | I am using stored procedures to create two related table
that I wish to then join into one. When I try to
reference them a stored procedures I get...
Dan Cawley
|
08-04-2003 08:44 AM
Dan Cawley | 0 | 88 |
| | | select a.*
from data_part a inner join
(Select max(Date_Time)date_time, part from Data_Part
Group By part)b
on a.date_time = b.date_time and...
Vishal Parkar
|
08-01-2003 01:51 PM
Vishal Parkar | 0 | 96 |
| | | Hopefully, this is an easy question and I'm just having a
case of temporary stupidity. I'm using the following SQL
string --
Select...
Dan Sprouse
|
08-01-2003 01:47 PM
Vishal Parkar | 1 | 97 |
| | | Hi
Sorry i dont know if this is a right place to post this question..but i
couldont find any other place to post it..so please forgive me if i am
in...
Amir Ghezelbash
|
07-31-2003 11:15 PM
Amir Ghezelbash | 0 | 87 |
| | | you are crossing the boundaries of money datatype choose
an alternative datatype to store value of 999999999999999
probably bigint/decimal.
From...
Vishal Parkar
|
07-31-2003 10:04 PM
Vishal Parkar | 0 | 84 |
| | | I have a strange problem.. The following update query is
not working
update userinfo set userstatus=0 where enddt is not null
and...
Vijay
|
07-31-2003 09:07 AM
vkpalivela | 2 | 78 |
| | | It's hard to say without details of the tables and
datatypes.
Are the columns that are being compared of the same
datatype?
Is 'A*' meant to be a...
Eric
|
07-31-2003 08:42 AM
Eric | 0 | 75 |
| | | Has anyone used a migration tool to move an Oracle environment to an
equivalent SQLserver environment?
Thanks.
Stephen
set
|
07-30-2003 05:05 PM
Vishal Parkar | 1 | 103 |
| | | Without a repro, it is impossible to understand your requirements. Can you
post your table DDLs, sample data & expected results?
--
- Anith
( Please...
Anith Sen
|
07-30-2003 12:14 PM
Anith Sen | 1 | 91 |
| | | How can I split the numbers to thousand digits in SQL 2000?
SALES (FLOAT)
SELECT SALES FROM...
avni erbey
|
07-30-2003 10:10 AM
Anith Sen | 1 | 76 |
| | | Can anyone please give me a categoric answer to the
following questions please...
1. Does SQL Server 7.0 run on a windows 2000 server and if
not are...
Stotty
|
07-30-2003 09:12 AM
Ray Higdon | 1 | 99 |
| | | If you have configured linked server correctly the syntax would be
insert into <sql_database>.<object_owner>.<object> (dest_col1,dest_col2)
SELECT...
Vishal Parkar
|
07-30-2003 01:08 AM
Vishal Parkar | 1 | 79 |
| | | Hello,
Anyone know how to retrieve SP version info in SQL 2000?
thank you in advance.
bernard
Bernard
|
07-29-2003 04:45 PM
Ray Higdon | 3 | 105 |
| | | I am trying to run a query like the following:
set rowcount 5
Select distinct col0 from tab0 where date between 'date1'
and 'date2'
sort by...
Casey
|
07-29-2003 02:56 PM
Anith Sen | 1 | 90 |
| | | From an earlier post, I was informed one way to find a
common set of values in a table is with a self join. Here
is a query I constructed with many...
Pam Downey
|
07-29-2003 02:55 PM
Anith Sen | 1 | 98 |
| | | Suppose we have a table with student names and marks. How do we get the 3rd
highest marks using SQL. I know that if we use top 3 we could retrieve...
netnews.worldnet.att.net
|
07-29-2003 04:17 AM
Michael Shao [MSFT] | 2 | 107 |
| | | create table #t(
ID varchar(6),
period datetime,
acct_no varchar(6))
insert into #t select 1, '20030401', 'ABC' union all
select 2, '20030501' ...
Vishal Parkar
|
07-28-2003 01:42 PM
Pam Downey | 1 | 102 |
| | | Hi Pam,
I'm not sure if this helps.
How are you getting the list of accounts to search for?
It's hard to see how this could be expanded to cater...
Eric
|
07-28-2003 01:40 PM
Pam Downey | 1 | 84 |
| | | The problem is I have a table called Products and a table
called Order_Items. Customers can place many orders so
what I want to do is for one...
Angela Anderson
|
07-28-2003 11:55 AM
Ray Higdon | 1 | 98 |
| | | Dear Sir,
Please help me to overcome the above mentioned error which
I faced for the first time since 5 years.
While restoring database from backup...
SANJAY JOIJODE - MUMBAIINDIA
|
07-28-2003 10:22 AM
SANJAY JOIJODE - MUMBAIINDIA | 0 | 123 |
| | | Anyone have e solution for resolve this error??
I have windows 2003 server and sql server developer
edition:
evente id: 19011 category:...
jari
|
07-28-2003 05:41 AM
jari | 0 | 154 |
| | | your SQL statement looks correct . what i 've posted is from the view point
of T-SQL.
First two lines are T-SQL syntaxes. hence there must be...
Vishal Parkar
|
07-27-2003 11:05 PM
Vishal Parkar | 1 | 96 |
| | | I think that you mean doing this:
stop all process named SQL something
edit the windows reg
with regedit32
look for SQL keys and remove them...
wisdommdk
|
07-24-2003 11:16 PM
wisdommdk | 0 | 98 |
| | | I've gotten it now. Thanks.
Dan.
Dan S.
|
07-24-2003 03:11 PM
Dan S. | 0 | 138 |
| | | Check the following example:
create table customer_detail(customer_name varchar(500))
insert into customer_detail values('mr john')
insert into...
Vishal Parkar
|
07-23-2003 05:19 PM
Wes | 2 | 77 |
| | | Hi,
Can i use MS SQL 7.0 on Windows XP O/S to access
data/communicate with DB on the Hosting providers Server?
or is MS SQL 7.0 only compatible with...
Derek
|
07-23-2003 12:42 PM
Derek | 6 | 108 |
| | | yes, it will give you the desired result ie average of "festqty" for each
"switch type". if you want average of all "festqty" then remove group...
Vishal Parkar
|
07-23-2003 10:39 AM
Vishal Parkar | 0 | 103 |
| | | Sorry to bother you, I just got it working, not quite
sure about order of INNER JOINs any reference to a
white paper or quick reason why would be...
Rhonda Fischer
|
07-23-2003 09:10 AM
Rhonda Fischer | 0 | 99 |
| | | probably you are prefixing columns in the query with wrong alias name used
for the table. or you might be using wrong table name. If you are...
Vishal Parkar
|
07-23-2003 09:02 AM
Vishal Parkar | 0 | 84 |
| | | I am trying to output the results of a SQL query (Server
2000) to a text file that can be sent to an internal web
page. I can view the resulting data...
Wayne Freeman
|
07-23-2003 07:24 AM
Vishal Parkar | 1 | 104 |
| | | Hi Vishal,
Thanks for the information.
However, i have just found out a way to get the list of tables in a MySQL
database and would like to share...
netnews.worldnet.att.net
|
07-23-2003 05:06 AM
Vishal Parkar | 4 | 87 |
| | | I need some help knowing where to start of a query. I
have a set of records. Each record has an account number
and a period. I am interested in a...
Pam Downey
|
07-22-2003 04:29 PM
Ray Higdon | 1 | 89 |
| | | Hi Bill,
I think you are trying to convert a 3 digit or more number
to a 2 digit DECIMAL.
Change DECIMAL(2) to DECIMAL(3) and see what values...
Eric
|
07-22-2003 10:34 AM
Eric | 0 | 121 |
| | | Hello,
I could not construct an SQL query that would return
an Entry of maximum date per Trailer Number, it still
returned more than one of the same...
Rhonda Fischer
|
07-22-2003 08:13 AM
Eric | 1 | 82 |
| | | Hi
Does any body know a sql statement that would retrieve the table names
within a database. Kindly note that I just want to retrieve the list of...
netnews.worldnet.att.net
|
07-22-2003 06:01 AM
Vishal Parkar | 4 | 89 |
