Viewing 15 posts - 3,436 through 3,450 (of 3,543 total)
Double Wow!
I have never granted any rights to public (and never will) but checked my servers using tim's code (great code Tim) to be sure (OK! phew!).
SQL security is a...
February 7, 2003 at 2:47 am
select count(distinct a.candidateid) as 'candidates'
from skillset a
inner join skillset b on b.candidateid = a.candidateid and b.skill = 'oracle'
where a.skill = 'xml'
select count(distinct candidateid) as 'candidates'
from skillset
where skill = 'oracle'
Edited...
February 7, 2003 at 2:22 am
Great topic. Always tried to find good way of incrementing id numbers. I still use non identity int columns (primary key) for my id's and set by using
select @id =...
February 6, 2003 at 10:47 am
This means that the mail server you are using does not allow forwarding of SMTP mail via a gateway. There are articles on the MS site referring to this subject...
February 6, 2003 at 10:19 am
Sounds like your server is trying to connect using Named Pipes. Use Client Network Utility on the server to create alias to other server and make sure network library is...
February 6, 2003 at 5:02 am
Sounds like your server is trying to connect using Named Pipes. Use Client Network Utility on the server to create alias to other server and make sure network library is...
February 6, 2003 at 4:49 am
or
select prspct_id,min(eventdate) from prospects group by prspct_id
not sure which is best for performance though!
February 6, 2003 at 4:39 am
Sounds like your server is trying to connect using Named Pipes. Use Client Network Utility on the server to create alias to other server and make sure network library is...
February 6, 2003 at 4:25 am
Sounds like your server is trying to connect using Named Pipes. Use Client Network Utility on the server to create alias to other server and make sure network library is...
February 6, 2003 at 4:14 am
try
select b.question_set_head,
b.question_set_tail,
b.question_no,
b.frame_file,
b.no_of_options
from route_detail d
inner join question_bank b
ON b.question_set_head = d.question_set_head
AND b.question_set_tail = d.question_set_tail
AND b.question_no = d.question_no
WHERE d.route_number = 4
and (select count(*) from route_detail where question_set_head = b.question_set_head and question_set_tail...
February 4, 2003 at 2:24 am
select TOP 2 b.question_set_head,
b.question_set_tail,
b.question_no,
b.frame_file,
b.no_of_options
from route_detail d
inner join question_bank
ON b.question_set_head = d.question_set_head
AND b.question_set_tail = d.question_set_tail
AND b.question_no = d.question_no
WHERE d.route_number = 4
If you want a random selection then that will involve...
February 3, 2003 at 11:24 am
Or, if you can produce the data in singles using some form of CR/DR id, e.g.
SELECT Prd.IDPrd, 'CR' AS 'CRDR', G1CR.IDPrdG1, G2CR.IDPrdG2,G3CR.IDPrdG3
FROM #Product Prd
INNER JOIN #ProductG1 G1CR ON Prd.IDPrdG1CR =...
February 3, 2003 at 3:57 am
You can use case statements to remove unwanted data and replace with zeros or as in the following blanks
SELECT Prd.IDPrd,
(CASE WHEN G3CR.RptPrd = 1 THEN CONVERT(varchar,G1CR.IDPrdG1) ELSE '' END)...
February 3, 2003 at 3:51 am
Please clarify re don't see all the products. When I run the sql I get one line per row in Table - Product.
Can u list the results from your test...
January 31, 2003 at 4:26 am
Will this do the trick
select s.salesman,s.date,
(case when (s.amount + isnull((select sum(amount) from Sales where salesman = s.salesman and date < s.date),0)) > l.Limits
then (l.Limits - isnull((select sum(amount) from Sales...
January 30, 2003 at 11:14 am
Viewing 15 posts - 3,436 through 3,450 (of 3,543 total)