|
Top number of records per a category
How do I query the top 10 customers for each salesman? If I use the select
top(10), then I only get 10 results.
For a basic structure, say I had 3 tables: customer, salesman, and sales.
Customer - custid, custname, etc
Salesman - salesid, salesname, etc
Sales - id, custid, salesid, qty, desc, unit ...
Fri, 14 Jan 2005 14:38:13 -0500
|
2 servers
in our lan we have 2 sql 2000 servers ( "A" & "B") I'm trying to retrieve
data from sql "A", while log in on a session of sql server "B" .
I use the "sp_addserver" to add the procedure and I got this message:
Server 'server_B' is not configured for DATA ACCESS.
any help would be most appreciate.
220 5006 ...
Fri, 14 Jan 2005 11:31:02 -0800
|
Search stored procedures for a certain text string
We have a database with approx 120 stored procedures in it and no access
to the original scripts.
Is there any way to search a database's stored procedures for a certain
code text ie: a search for "select datediff" code in all the stored
procedures.
Thanks220 500645 <50VFd.78536$Xk.49221@pd7tw3no>
X-Trace ...
Fri, 14 Jan 2005 19:24:49 GMT
|
sql query question
Hi all,
I need to create a view in sql7,
The table look like this:
field1 field2 field3
A abc/xyz 500.00
B mnc/opq 255.00
C xyz/abc 550.00
D opq/mnc 123.00
E hnc/yun 25.00
F inm/mnb 453.00
...
Fri, 14 Jan 2005 14:01:16 -0500
|
BCP Primary Filegroup is full
I have a large import through BCP, I get the error message "Primary
filegroup is full" after a long while. I looked in the properties of the
database and it is set to automatically grow file by 10% and unrestricted
growth. Why is it hitting this error then?
Thanks
Chris
220 500635
Fri, 14 Jan 2005 12:58:15 -0600
|
Dynamic SQL Question....
Hi all,
I'm building a stored procedure that takes a few input parameters where each
of the parameters represent columns from different tables in the database.
The parameter's can be null or populated. I can build the WHERE clause of
the SELECT statement dynamically, not a problem.
The question is how do ...
Fri, 14 Jan 2005 13:05:10 -0500
|
Setting up a linked server
Is there a way to set up a linked server for a unix box running DB2? I have
been able to connect, but always end up crashing SQL SERVER.
Thanks
...
Fri, 14 Jan 2005 09:53:03 -0800
|
DB scripting and View dependency problem
When we script a a database, we get a lot of CREATE VIEW
statements. Unfortunately, they are sometimes "out of order", i.e.
the Enterprise Manager seems not to care about dependencies.
Did we miss an option or is there a (not too expensive) tool that
can arrange the views so that we don't have this problem? O ...
Fri, 14 Jan 2005 10:01:28 +0100
|
Building a "rolling" invoice number SP in MS-SQL
Hi,
I am fairly new to MS-SQL and stored procedures.
I need to create a unique continuous "rolling" invoice number which is
assigned when I create an invoice. The trouble is that I cannot do:
read current invoice_no
update invoice_no +=1 in a single row table
because I cannot guarantee tha ...
Fri, 14 Jan 2005 17:03:53 +0000 (UTC)
|
Setting null to 0
Try this:
update your_table
set qty = 0 where qty is null
>-----Original Message-----
>Hi I have a table with a field "qty" that should contain
a number. Some of
>the values is today NULL. Is there a script to run on the
table to set all
>records with qty = null to qty = 0
>
>TIRislaa
>
>
>.
> ...
Fri, 14 Jan 2005 08:56:12 -0800
|
Find user permission
I need to run a report per database that has for each
user the permissions that they have down to the table
level to include stored procs and user defined functions.
Does anyone know a query I can use to generate such a
report or can you tell which system tables I can query
against? Thanks! ...
Fri, 14 Jan 2005 08:52:36 -0800
|
Unique ID
Does anyone know of an id that uniquely identifies a database or some way
this can be accomplished? ...
Fri, 14 Jan 2005 07:57:04 -0800
|
Heirarchy Procedure
I have a table that looks like this...
employee_id,email_address,manager_id
12345,12345@wherever.com,77777
77777,77777@wherevere.com,88888
88888,88888@wherever.com,11111
66666,66666@wherever.com,88888
45678,45678@wherever.com,77777
78910,78910@wherever.com,77777
From the table we know that 12345 reports ...
Fri, 14 Jan 2005 10:54:03 -0500
|
Programming to remote server
I've been asked to create some web pages with select parameters to pull data
from a remote sql 2000 database where I have basic select permissions but not
the ability to create/save stored procedures/views/tables. I understand that
stored procs are best (?) - faster, easier. What's my best course of action? ...
Fri, 14 Jan 2005 07:53:03 -0800
|
Passing control flags to stored procedure
Wanted to know which among these options is better and why? Or if their
could be scenarios where we could opt for one of these.
a) flags passed from code to control the execution of queries within a
stored procedure i.e. - where queries within a single stored procedure
are controlled by flags passed to them ...
Fri, 14 Jan 2005 15:41:52 GMT
|