|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Openquery syntax for function Posted by Lisa at 9/3/2005 8:26:05 PM There is a very complex query where I'm trying to call a function from a
linked server with input paramaters from the local database. This is the
general idea:
select openquery( linkserver, 'database.dbo.function( t1.c1, t2.c2 )'
from table1 t1
and table t2
where ...
I get a syntax er...more >>
How to handle large number of attributes for a dimension Posted by karenmiddleol NO[at]SPAM yahoo.com at 9/3/2005 8:05:39 PM I have a Product dimension on which I expect about 90 attributes
mainly they are related to classifying the material.
Can somebody please share ideas how I can implement such a large set of
dimension attributes any other alternatives you can think off.
Sometimes the attrbutes can be dynami...more >>
Assigning Permissions! Posted by Arpan at 9/3/2005 6:11:16 PM Suppose a SQL Server 7.0 database table has, say, 9 columns
[Column1....Column9] & only 3 users can access this table. Each user
has a password. Assume that the passwords of the 3 users are 'pwd1',
'pwd2' & 'pwd3' (without the quotes).
I want that if the password is 'pwd1', then that user shou...more >>
Select statement Posted by smk23 at 9/3/2005 2:50:01 PM In this statement:
"SELECT DISTINCT Address1 FROM Address"
I would also like to see a couple other fields like AddressID and City, but
want only the Address1 to be distinct. How would I write this?
TIA
--
sam...more >>
Understanding EXISTS Posted by Paul Pedersen at 9/3/2005 1:09:51 PM Working my way through t-sql here...
In a book, I was given this example:
SELECT Pub_name
FROM Publishers
WHERE EXISTS
(SELECT * FROM Titles
WHERE Titles.Pub_id = Publishers.Pub_id
AND Type = 'business')
I found that a little difficult to interpret at first, and also it s...more >>
How to upload dynamic text file !!. Experts Only !!! Posted by Ahmed Jewahar at 9/3/2005 5:05:40 AM Dear All,
I have project and I'm in the middle of system design & analysis. I
would really appreciate if you could share your knowledge in the
following area where I'm newbie.
In Win2k/Win2003 server, SQL2K is running. I have a folder called
"D:\Work" where I'm gettin many ".txt" (pipe deli...more >>
Fully qualified object names help reuse of execution plans. Posted by Damien at 9/3/2005 4:51:10 AM Fully qualified object names help reuse of execution plans.
Is this true? Discuss.
Also, what constitutes fully qualified?
Is it
server.database.owner.object
or can you get away with
database.owner.object
and still resuse your execution plans?
Thanks
...more >>
SqlException: Unknown error. Posted by Lloyd at 9/3/2005 12:51:35 AM I have some code doing a very simple select "select bonusid from game where
gameid=@gameid" that works about 98% of the time, but somewhere around two
percent of the time it throws an exception. If I go through the sqlerror's
in the exception all it has is the following:
Index #0
Message: Un...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Return One Row Per User, not TOP(1) HELP Please Posted by Eamon Straughn at 9/3/2005 12:00:00 AM SELECT AppFnd.afId, AppFnd.approve, AppFnd.Friend, AppFnd.apId,
AppFnd.UName, Friends.Message, Friends.Rating, Friends.apId AS Expr1,
Basic.Country, DATEDIFF(d, Basic.Dob, GETDATE()) / 364 AS Years, (12 -
(DATEPART(m, Basic.Dob) - DATEPART(m, GETDATE()))) % 12 AS Months FROM
AppFnd INNER JOIN Fr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |