|
|
|
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 Expanding Hierachy with multiple parents Posted by hai_hoang NO[at]SPAM hotmail.com at 11/29/2003 9:59:28 PM I have a user assigned multiple roles and a role can be inherited from
multiple parents (see below). How do I answer such questions as "How
many roles does the user belongs to?" (no re-enter allowed and no
deep level restriction)
I answered the above questions by using .NET but I think it ca...more >>
Distributed queries bug in SQL Server 2000 Posted by adlisita NO[at]SPAM msdnnospam.com at 11/29/2003 4:57:43 PM In 2002 was reported a bug in SQL Server 2000 that would
not allow to run a distributed query on a remote server.
This bug report was posted at the following URL:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%
3B323711
I wanted to check if the bug was fixed but I did not find...more >>
understanding logic Posted by Stevie at 11/29/2003 2:55:23 PM Hi I have a trouble with some logic.
I want a list of users who have never purchased a sony (so)
laptop (lt).
select * from ius_orders o
inner join ius_cust c
on c.ord=o.ord
where mfr <> 'so' and category <> 'lt'
Does this look correct or will this include all customers
who have never p...more >>
Clustered Index Not Working Posted by Jim Ferris at 11/29/2003 10:51:20 AM I put a clustered index on a table with 2 columns
-nationalityid int identity PK
-nationality varchar(50)
the clustered index is on nationality
however; when i do a select i still get a record set back
ordered by
the nationality id...what am I doing wrong?
-Jim...more >>
how do I generate an event in SQL Server? Posted by karensundq NO[at]SPAM yahoo.com at 11/29/2003 7:04:59 AM hello there!
I want to generate an event in SQL Server when certain data appears in
a table. I have though of various approaches to this but they all seem
to have big drawbacks. What is the right way to solve this common
problem?
My ideas so far (with drawbacks) are:
1. Use xp_cmdshell in ...more >>
Insert/select data from an 'Image' data type column Posted by Murali at 11/29/2003 4:41:06 AM
I want to insert or retrive(select) the data from a 'Image' data type column through a SQL query
Can you suggest on this? Thanks in advance."...more >>
Merge Back 3 Data Files? Posted by Michael L. at 11/29/2003 1:12:25 AM Hi there,
When I had space issues, I had to split my database into 3 seperate data
files.
I've detached it, and finally moved all 3 files to a new, clean server with
plenty of room.
Is there any way to merge back 3 data files into 1 big file? is there any
difference in speed or stability i...more >>
Help with this proc code? Posted by ScottF at 11/29/2003 12:21:05 AM I have a crystal report that runs a stored procedure. The guy who ran our IT dept before me put together the code, and it's up to me to fix it. It's going to take a more experienced SQL coder than I am, to fix it i think. I need to make a minor adjustment to fix the problem, or change the whole thin...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Returning formated date Posted by Don Grover at 11/29/2003 12:16:34 AM Hi
I have to return dates formated in different ways in an asp page from sql
server.
What function can I use or how can I return dates formated like so
I tried DATEPART ie.. but that does not work they way I would expect
"dd/mm/yy"
"dd/mm/ccyy"
"mm/dd/ccyy"
"mm/dd/yy"
"dd mmm ccyy"
"cc...more >>
Stored procedure mails to selected records Posted by bus at 11/29/2003 12:13:39 AM Hi,
I know how to do this in ASP while using SQL server but I want to have
it done by a stored prodedure and sql agent. Maybe somebody can help
me out:
I want to select records that are not older than 6 months. This is
calculated on the value of a record called Date. So Date minus 6
mont...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |