Viewing 15 posts - 2,701 through 2,715 (of 6,036 total)
Jeff Moden (12/11/2008)
Heh... well, someone had to answer it! 😛
Give the world a chance!
:alien:
December 11, 2008 at 1:46 pm
Jeff, I know, you've got SQL2k5 to play with, but this is SQL2k forum, remember?
😉
December 10, 2008 at 10:27 pm
rbarryyoung (12/10/2008)
I think that this will do it.
I think not in SQL2000.
December 10, 2008 at 7:47 pm
In which table do you store connections between each top level navigation and its child pages?
December 10, 2008 at 7:08 pm
Zahran (12/10/2008)
SELECT a.* FROM OPENROWSET('SQLOLEDB',
'Trusted_Connection=yes;Integrated Security=SSPI;DataSource=''10.0.172.53'';' ,
'SELECT * FROM ODS.dbo.retdacct_account') AS a
Zahran, you use single quote in connection string which is inapproppriate there.
Proper quotes for...
December 10, 2008 at 2:13 pm
It may be declared as a parameter of SP.
December 10, 2008 at 1:37 pm
SELECT O.*
FROM dbo.Order O
INNER JOIN (
select MAX(OrderDate) as MaxDate
from dbo.Order ) LO ON O.OrderDate= LO.MaxDate
December 10, 2008 at 12:36 pm
sabarichandru (12/10/2008)
its not a assiginment .. part of my project . but they ask me not to use table fields directly u should specify the values to derive the...
December 10, 2008 at 11:43 am
sabarichandru (12/10/2008)
but i should not use table fields .
Why?
Is it kind of assessment?
December 10, 2008 at 2:29 am
SELECT Date
FROM Calendar
WHERE Date BETWEEN @StartDate and @EndDate
December 10, 2008 at 1:51 am
Heisa (12/9/2008)
But that would mean an extra step, that would make the process slower...
1 write operation (actual insert of a duplicate) equals 4-5 read operations (checking if the same key...
December 9, 2008 at 3:12 am
Prevent duplicates from being inserted.
December 9, 2008 at 2:31 am
Bob Hovious (12/8/2008)
Who said it was a bug? 😉
In this topic - nobody. Yet.
But I know at least 2 guys who took my scripts with STR in it and...
December 8, 2008 at 3:02 pm
I'm not picky at all.
Especially when someone agrees with me 😉
Just wanted to show how to use "a bug" as "a feature".
😎
December 8, 2008 at 2:10 pm
Bob Hovious (12/7/2008)
Another difference is that STR will return a string padded with blanks on the left.
In most cases it's actually an advantage.
Most of our customers require numeric values to...
December 7, 2008 at 6:19 pm
Viewing 15 posts - 2,701 through 2,715 (of 6,036 total)