all groups > sql server (alternate) > october 2004
Filter by week: 1 2 3 4 5
Terminology question - set of related records in multiple tables
Posted by Steve Jorgensen at 10/31/2004 10:27:56 PM
Terminology question:
Is there a term for a set of records related directly or indirectly by key
value in several tables? For example, a single invoice record and its line
item records -or- a single customer, the customer's orders, the order lines
for those orders, the customer's invoices, an... more >>
Newbie backup Question
Posted by Fred at 10/31/2004 2:58:19 PM
I have a table in sql 2000 that is storing Financial Tick data. The database
size now appears at about 30GB and I have decided to backup the database and
store the data offsite.
Here is where I am confused about whether only a Database (complete) backup
is necessary or whether I must also incl... more >>
Report Services Examples.. please.. VS.NET
Posted by Karina Gamez at 10/30/2004 5:07:18 AM
Hi..
Im newbie on Report Services with VS.NET... I made a cube on olap.. and
I try to lear some mdx for my reports..
But, in the report designer... I need a lot of help..
Please.. anybody.. can help me¨??
Thanks a lot...!
Karina Gamez
*** Sent via Developersdex http://www.de... more >>
How to upload table to sql?
Posted by Evgeny Gopengauz at 10/30/2004 5:07:17 AM
How to upload a content of a table into sql-file (the set of INSERTs)
using standard MSSQL utilities?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!... more >>
How to upload a table as sql?
Posted by Evgeny Gopengauz at 10/30/2004 5:07:17 AM
How to upload a content of a table into sql-file (as a set of INSERTs)
using standard utilities?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!... more >>
How to find out workstation name from net_address
Posted by ericyang1991 NO[at]SPAM hotmail.com at 10/29/2004 4:23:40 PM
Hi,
Is it possible to know workstation name from data in column
net_address from master..sysprocesses?
TIA... more >>
Selecting All Parents in a Path Enumerated Tree
Posted by nutgg001 NO[at]SPAM sneakemail.com at 10/29/2004 3:02:21 PM
Hi,
I have a tree structure which is maintained through the use of a path
enumerated column:
CREATE TABLE items (
item_id NUMERIC NOT NULL,
path VARCHAR2(64) NOT NULL
);
The path is is a colon separated list of ids of the nodes of the tree.
So, for example, in this structure:
0 ->... more >>
Newbie help: sql string conversion
Posted by steve at 10/29/2004 2:37:25 PM
Hi,
I am trying to avoid a horrendous amount of coding and see if i can get away
with a complex sql statement.
I have data values (measurements) which I have stored in the database in the
form of STRING so that i can keep the original format.
They look like this:
000078 -> 7... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Problems with MSDE
Posted by Markus Graf at 10/29/2004 12:18:19 PM
Hi all
I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation
was not the problem, but if i would connect with a client like dbamgr2k
or the MS Enterprise client, the client hangs up. If i try a nonlocal
server, it hangs too. What's the problem?
Markus... more >>
View stored procedure permissions
Posted by tcaylor NO[at]SPAM thomasnelson.com at 10/29/2004 11:15:54 AM
We are running SQL Server 2000 Developer Edition. I don't want to
make the developers the sysadmin or even the dbo in the user
databases. Is there a way to give them access to only view the
permissions for the stored procedures in the user database without
making them dbo?
When I take them... more >>
checkpoint command and backup log
Posted by louisducnguyen NO[at]SPAM gmail.com at 10/29/2004 9:51:35 AM
This is maybe a dumb question but I couldn't find a definitive answer
on BOL.
Looking at my backup script. If I issue a CHECKPOINT, does this truly
force all transaction log entries to the data file? Therefore, making
it unnecessary to BACKUP log (just BACKUP database is needed).
Louis... more >>
Still Trying to Figure Out Identification of SQL Server Stored Proc. Permissions via VB
Posted by bmccoll1 NO[at]SPAM midsouth.rr.com at 10/29/2004 7:30:59 AM
I've looked through many suggestions and partial examples all over
this newsgroup and still am not coming up with anything that does
specifically what I'm wanting to accomplish.
I'm writing a VB 6.0 application which uses SQL Server as the
back-end.
Here's an example of what I'm wanting to ... more >>
Alternative to this clumsy effort?
Posted by drmcl NO[at]SPAM drmcl.free-online.co.uk at 10/28/2004 3:26:45 PM
I have a little problem that I think I solved with a sledge-hammer and
thought I'd post here to see if there was not perhaps a more elegant
and probably quicker solution.
Essentially I have a unique display condition on a table that must
return data in a certain way. The problem column in quest... more >>
help needed converting C float value to DBNUMERIC ...
Posted by Giovanni Azua at 10/28/2004 2:30:39 PM
Hello all,
I need to return back to TSQL two numeric values from an
Extended Stored Procedure developed in C. As result my C
dll program produces two float values, the TSQL side expects
to have exactly: numeric(10, 5) and numeric.
Given that the structure to fill-up is DBNUMERIC defined
as... more >>
Partitioned view broken after moving table to new filegroup
Posted by tom_hummel NO[at]SPAM hotmail.com at 10/28/2004 12:52:08 PM
I am using SQL Server 2000, SP3.
I created an updatable partitioned view awhile ago and it has been
running smoothly for some time. The partition is on a DATETIME column
and it is partitioned by month. Each month a stored procedure is
scheduled that creates the new month's table, and alters th... more >>
encrypt(string) Question!!
Posted by rrey2279 NO[at]SPAM aol.com at 10/28/2004 9:01:08 AM
SQL Server 2000:
########################################################
I run the following as a normal query from Analyzer:
########################################################
SELECT encrypt(user_password) FROM emp WHERE user_id = 1
################################################... more >>
location coordinates query
Posted by John Paine at 10/28/2004 8:06:52 AM
Hi All,
I've been struggling with how best to define a query to get a list of unique
coordinates from a database table and my SQL skills are not good enough to
work out a good solution. The basic table structure is as follows:
CREATE TABLE [Readings Data Table] (
CY DOUBLE,
PY DOUBLE,
... more >>
DTS - help
Posted by gelangov NO[at]SPAM hotmail.com at 10/28/2004 7:21:20 AM
Create a table (each time different table) – we have a DTS to do that
-- 1
There is a fixed delimited text file; we need to Import this file into
the created table above and we have another DTS to do that. –2
We want to combine these two DTS into one.
The problem is when the table does no... more >>
Transaction log file too early to apply
Posted by watuni2000 NO[at]SPAM yahoo.co.nz at 10/28/2004 7:18:04 AM
Hi
I implement a manual standby by backing up Transaction log files every
hour
and database nightly and restoring these on a standby server.
Every thing works fine but the Transaction log restore fail with error
listed
I am sure the database backup finishes before the transaction log
backups... more >>
SET options have incorrect settings: 'ARITHABORT'
Posted by iqbalkotwal NO[at]SPAM hotmail.com at 10/28/2004 6:43:57 AM
Hi,
I am getting the following error when I run a stored procedure in
which I am inserting/deleting data from a view that selects from a
remote table.
INSERT failed because the following SET options have incorrect
settings: 'ARITHABORT'
The first statement in the stored procedure is 'set... more >>
odbc index problem
Posted by thew NO[at]SPAM ltons.freeserve.co.uk at 10/28/2004 2:10:42 AM
Hi all,
Here is a brief description of a problem I encountered, and how I
found a work around after 3 long days.
I have a VB6 app that uses ADO and ODBC to get communicate with SQL
server 2000 (sp3, running in win2003).
Everything was running great for a few weeks, but one day an update
st... more >>
Any MS SQL server driver for JDBC for window NT ?
Posted by 01512244d NO[at]SPAM polyu.edu.hk at 10/27/2004 8:26:10 PM
Dear all,
Any MS SQL server driver for JDBC for window NT ?
Thanks for reply.
Victoria... more >>
Extended Stored Procedure problem (srv_describe function)...
Posted by Giovanni Azua at 10/27/2004 4:44:16 PM
Hello all,
I have spend quite some time now but don't manage to
find out how to have the srv_describe function working
properly for target NUMERIC(x,x) and NUMERIC types.
Already tried several alternatives like e.g.
// ...
PVOID pvdata1;
strcpy((char*)pvdata1, "12345.6789");... more >>
Character Field Formats
Posted by csomberg NO[at]SPAM dwr.com at 10/27/2004 1:25:38 PM
I was wondering what everyone felt about the fomats in character
fields where the front end application accepts anything.
I wouldn't want a customer table where the customer name was lower
case on one, upper on another and who knows on the third.
If character fields are not consistent, then ... more >>
SQL buffer size
Posted by Rudi W at 10/27/2004 10:45:21 AM
Hi there
Anybody know how to increase the MS SQL server buffer size?
I get an error when trying so insert some pictures as OLE objects. When
transfering to the server i get an error, that the buffer sizes needs to
be increased.
Regards
Rudi W.... more >>
query help
Posted by parth_ai NO[at]SPAM yahoo.com at 10/27/2004 10:34:55 AM
I have the following table -
Name Enrolment# File#
x 422 011
y 421 022
z 444 023
a 345 024
I have to produce the following table -
S.No Name Enrolment# File#
1 a 345 024
2 y 421 ... more >>
Not applying the initial snapshot when setting up Tran Repl.
Posted by alan.frush NO[at]SPAM healthtrio.com at 10/27/2004 9:28:39 AM
I am setting up a combination of transactional and merge replication
on a very large database and do not want to apply the initial snapshot
since this would take to long. I am doing this with scripts that were
previosly created when the database was not this big. I want to copy
the publisher D... more >>
Updating from a Text File?
Posted by steveosit NO[at]SPAM gmail.com at 10/27/2004 8:44:29 AM
Hi All,
I'm not that great with MS-SQL, as I never really have any occasion to
use it. However, I need to get this one thing working and don't have
a clue where to start.
I have a comma-delimited file that's delivered to the server every
night that contains updates to one of the tables. I... more >>
inserting data into a database alphabetically
Posted by mdavis0307 NO[at]SPAM sbcglobal.net at 10/27/2004 6:12:08 AM
Hello, is it possible to insert new data into a datbase
alphabetically? For example when a user enters a new row of data, I
want the row inserted in the correct order. I do not think this is
possible.
Thank you for the help!... more >>
JDBC for MS SQL server
Posted by 01512244d NO[at]SPAM polyu.edu.hk at 10/27/2004 3:19:36 AM
Dear all,
Where can I find JDBC for MS SQL server?
Thx for reply.
Victoria... more >>
Stored Procedure Source Control
Posted by karlbutcher NO[at]SPAM gmail.com at 10/27/2004 2:50:05 AM
Hi,
I am trying to put SQL Server Stored Procedures into Sourcesafe as per
the Microsoft Knowledge Base article 818368, but have run into a
problem.
The web server is SQL Server 2000 running on Windows 2003 Server. The
client dev environment is Visual Studio 2003 Enterprise Developer
Edition... more >>
String Manipulation SQL
Posted by justkule NO[at]SPAM yahoo.com at 10/27/2004 12:14:28 AM
We have some rows that we need to do some tricky string manipulation
on.
We have a UserID column which has userid entries in the format
firstname.lastname and i need to change each entry to
lastname.firstname
Can this be done by some script?
Thanks so much for your help.
Sid... more >>
Connection problems
Posted by William F. O'Neill at 10/26/2004 9:10:26 PM
Am working on a SQL Server 2000 db with Powerbuilder 8 as the frontend. For
months our endusers connected thru the SQL Server native driver for version
6. Now, have just ported the application to Powerbuilder 10, and I
understand that the native drivers for SQL Server 2000 no longer exist in... more >>
Output Parameters versus Recordsets in Stored Procedures
Posted by Darter Dan at 10/26/2004 6:17:35 PM
I've read that stored procedures should use output parameters instead of
recordsets where possible for best efficiency. Unfortunately I need to
quantify this with some hard data and I'm not sure which counters to
use. Should I be looking at the SQL Server memory counters or something
else.
... more >>
SQL 2000: Users, Roles, Permissions management
Posted by littletinymonkey NO[at]SPAM hotmail.com at 10/26/2004 2:43:11 PM
I am in need of a utility (stored procedure, third party app, etc)
that will help streamline the process of managing and auditing object
permissions, users and roles on multiple sql server 2000 instances
with multiple databases on each instance. That's a quick overview of
what I need, do I need ... more >>
sql server transaction logs
Posted by afsinclair NO[at]SPAM optonline.net at 10/26/2004 1:49:05 PM
I recently performed an SQL server 2000 installation. Other than
placing the program files on C: and data on D:, I saw no option to
install transaction logs in an alternate location.
What is the best practice with SQL server 2000 for location of
transaction logs? I remember that Microsoft us... more >>
VLDB Replication or Dev Copy
Posted by csomberg NO[at]SPAM dwr.com at 10/26/2004 12:18:39 PM
I have a production database that is in the low gigabyte size and
growing steadily. No issue there.
I wish to completely refresh the development database daily on a
second server. What is going to be the fastest easiest way to do this
with hindering performance on the production system ?
Th... more >>
behavior of SQL on joined queries
Posted by Metal Dave at 10/26/2004 12:12:37 PM
Hi all,
Currently our product has a setup that stores information about
transactions in a transaction table. Additionally, certain transactions
pertain to specific people, and extra information is stored in another
table. So for good or ill, things look like this right now:
create table ... more >>
datetime JDBC date conversion
Posted by kmilburn NO[at]SPAM austin.rr.com at 10/26/2004 11:50:45 AM
I am writing a datetime field value to MS SQL Server 7 in the following manner
via a stored procedure:
// item to be written is originally a java.util.Date object
java.util.Date fromDate;
// I'm inserting it here into the database
cstmt.setTimestamp(8, new Timestamp(fromDate.getTime()));
... more >>
Checking the type of a variable in SQL
Posted by ramziabb NO[at]SPAM gmail.com at 10/26/2004 11:46:03 AM
Is there a way to check the type of a variable in SQL? I want to know
if a variable is a float or a string.
Thanks,
Ramzi... more >>
Moving a database between two SQL Server with different patch levels
Posted by giovanni.clayden NO[at]SPAM lstrillium.com at 10/26/2004 8:57:41 AM
Hi,
I need to move a database from an instance running SQL Server 2000 SP3
to another running SQL Server 2000 SP2. Can I just use backup/restore
or detach/reattach and let SQL server take care of any downgrading (if
any).
Many thanks
Giovanni... more >>
please help
Posted by kalikoi NO[at]SPAM yahoo.com at 10/26/2004 4:58:29 AM
if i query like
select * from table1 then i will get the following
****************************************************
Ticker col2 col3 col4 col5
----------------------------------------------------
BRK.A 2003-05-02 70400.00 0.00 78500.00
FARM 2003-05-02 326.25 3.60 370.99
... more >>
variable scoping problem
Posted by Robert at 10/25/2004 10:08:17 PM
Greetings
I have been trying to write a script that will list out the size of each
user table in a specified DB. I am running into a scoping problem when
trying to format my display. I am sure there are several ways to derive the
results. My method won't allow me to
select count(*) f... more >>
Storing Documents and Images - In the database or as a link?
Posted by Dave Smithz at 10/25/2004 8:49:31 PM
Hi There,
Being quite new to MS-SQL I would like to ask if there is a general opinion
of what approach should be taken to storing things like external documents
and images in databases.
Should the actual files be stored within the database, or instead should
links to the files on a file ser... more >>
Indexed Views - Group By Redundancy
Posted by chrisrath NO[at]SPAM aol.com at 10/25/2004 8:25:49 PM
I have a table that I want to have a precalulcate length on a character field
and group and sum up. Thought I could do this by creating a view with a group
by clause that includes the sum function. Unfortunately, the compiler
complains with:
A clustered index cannot be created on the view... more >>
rating system
Posted by landofjeremy NO[at]SPAM gmail.com at 10/25/2004 7:07:19 PM
this is probably a simple sql solution, but i could use some help.
i've got one table that has rows of documents, and another table with
any number of ratings for each of the documents. The rating table is
linked with an id column. the issue i am running up against is
returning a single average ... more >>
Convert MySQL script to SQL Server script
Posted by Wes Graves at 10/25/2004 6:47:19 PM
Hi there,
I have a few MySQL scripts that I need to run in SQL Server. However the
syntax is just slightly different and I was wondering if there is a tool out
there that can quickly convert these scripts so that they will work with SQL
Server?
Anyone have any ideas (other than manually co... more >>
SQL Query Help
Posted by gary_brunton NO[at]SPAM hotmail.com at 10/25/2004 5:37:22 PM
Assume I have the two following tables:
Employee
---------
ID HoursWorked Contract
----------------------------------
1 50.0 01
Fund
--------
FundType Rate EmployeeID
-------------------------------------
HW 4.3 1
... more >>
Execute without Insert
Posted by harlan NO[at]SPAM elementalcomponents.com at 10/25/2004 1:40:57 PM
Is there a way to let an account have execute permission on a stored
procedure but not let that stored procedure run insert , delete, or
update records. Basically only let them run or create stored
procedures that do selects.... more >>
records won't delete
Posted by alloowishus NO[at]SPAM yahoo.com at 10/25/2004 12:52:51 PM
I have some records that will not delete, whenever I run a delete
statement in the Query analyzer, it never completes the statement, and
I am only deleting one record at a time. Can anyone tell me why a
record wouldn't delete?... more >>
|