 group by query with join - problem [0 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
Hello you gurus!
I am working on a complex query and cannot figure out how it works.
Imagine tree tables (sample-code below)
1. holding the super-entities
2. holding categories with a...
please answer me !!! [1 reply]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
hi!
how can i debug my stored procedures or my t-sql code in
query analyzer?
i am registered sqldbg.dll and i run 'sqldbreg /RegServer'.
thanks.
saval
if not transcender than who? [0 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
I'll considering purchasing Transcender's prep exam for 70-229. Any
opinions? What's the best product out there?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just ...
DTS Package: Dynamic VS. Secure [0 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
I am faced with a dilemma: I need to set the connection to an Access
database on the user's machine dynamically at run-time, but I don't want to
give or hardcode the Package Owner password in...
Different plans for the same query [5 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
Sorry,but forgot another work around that is possible.
In the SQL statement, you could provide a hint to use LOOP
| HASH | MERGE as appropriate. In your case this appears
to be a LOOP suc...
Different plans for the same query [5 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
<
I have a problem with one query . On my development server
( Windows 2000 SP 2,SQL 2000 SP 2, 1 GB RAM, 2 Pentium III
600) query is using different from our Production server
( Window...
Extended stored procedure with dll cannot find function [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
you can use bumpbin to check you dll
to look the test function is export
if not,check you .def file
the bumpbin.exe in vc++ /bin folder
>-----Original Message-----
>Hello:
>
>I'm trying ...
Extended stored procedure with dll cannot find function [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
Hello:
I'm trying to create an extended stored procedure and use it with dll. I
create a dll and an ext. sp according to the instructions, but every time I
try to run it I get this error"
...
Query Analyzer [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
In VB6 :
How can I run commands and get the same results a Sp prints on Query
Analyzer ? Just the plain text isntead a recordset.
IIF or case in SQL [2 replies]
microsoft.public.sqlserver.programming, Saturday, April 27, 2002
I have a table......
create table usga
(
Name varchar(30),
ScoreDate datetime,
Score int
)
INSERT INTO usga ( Name, ScoreDate, Score ) VALUES ('Tom', '4/11/2002', 8...
Locking Problem [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
Hi All,
can any please help me in solving this locking problem.
I have a a t-sql like this
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
BEGIN TRANSACTION
--tryimg to lock a partic...
complex sql statement [5 replies]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
I have a table called usga with a name field, date field and a score field.
create table usga
(
Name varchar(30),
ScoreDate datetime,
Score int
)
INSERT INTO usga (...
SQL Server 7.0 Service Pack 4 Available [0 replies]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
We are delighted to announce that Service Pack 4 for SQL Server 7.0 has been
released for all languages and is now available on the Microsoft web site at
http://www.microsoft.com/sql/download...
Return Values [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
I'm using SQL Server 7.0 and MS Access 97 DAO application. How do I process
retun values from a Stored procedure using DAO recordsets. MY SP return 2
output values and expects 2 input valu...
SQL Syntax Question [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
I have :
SELECT conNumber, MAX(conAmend) AS conAmend
FROM tContracts
GROUP BY conNumber
HAVING (conNumber = '25656')
It returns the record I need BUT, I additionally I...
uery & quoted identifiers [2 replies]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
Am trying to update linked server usinguery to AS400
using DB2OLEDB driver.
However, column names start with $ sign. In the select for
theuery I specify column names explicit...
Different plans for the same query [5 replies]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
Hello !
I have a problem with one query . On my development server ( Windows 2000 SP
2,SQL 2000 SP 2, 1 GB RAM, 2 Pentium III 600) query is using di...
VB TextBox, SQL column, NULL [1 reply]
microsoft.public.sqlserver.programming, Friday, April 26, 2002
If you tab over a text box in VB, the value saved is "",
however, when you then insert that value into an SQL
column, it becomes a NULL. When you the retrieve that
NULL value from the dat...
|
