|
|
|
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 Top Few Results for each row in a one-to-many result set Posted by EradicusMax at 11/12/2006 11:21:26 PM I'm sure someone has had to do this before for a batch process. Is there a
way to return the first few records for each row of a result set. Lets say I
have a table (Accounts) with
AcctNbr, LastName,FirstName,State
I have a second table (Phones) for the phone listings of the the US with
...more >>
SQL Variant Comparisons Posted by Don Miller at 11/12/2006 9:23:12 PM I'm trying to figure out SQL_Variant comparisons but I am apparently missing
something.
When I created a test database (below) my queries are returning non-numeric
rows that I do not want. When I run "select * from test where myvariant >
3" I get:
id myvariant
6 5
7 10.3
10 ...more >>
using SQLCLR VB.NET Posted by phil at 11/12/2006 8:19:01 PM I've just started to integrate a VB.net assembly into an SQL-SERVER database
I've brought in the assembly and created an SQL procedure which finds its
way to the VB code
It all worked fine while I was just handling simple commands to test it out
but now I've added some database accessing and I...more >>
Which User is the current user authenticating with ? Posted by Michael Tissington at 11/12/2006 6:13:20 PM - This needs to work under SQL 2000 and SQL 2005.
- Using Windows Authentication.
I have an application which users SQL Users to provide additional security.
When a user connect to the database using Windows Authentication,
how can I found out which user they authenticated as. ?
If the us...more >>
Kill Process - Sp_who Posted by WCM at 11/12/2006 1:50:01 PM re: Sql Server 2000:
We need to run a RESTORE on a .bak file every day at a specific time to get
yesterday's production data into our development db. Consequently, the
procedure we write needs to kill certain processes prior to the RESTORE.
We are writing the proc so that it delivers the ...more >>
Need enhancement help w/ query that rotates table Posted by KenKhanh at 11/12/2006 1:41:04 PM Hi All,
It took me a week to learn and get to where I am w/ the current query
below that rotates a table the way I wanted. But now it gets more
complicated. Can someone help me enhance the query? Thanks in
advance.
I don't know what to do if I need more than one values returned from
SUB...more >>
Find a Date string in an ntext field Posted by Aubrey at 11/12/2006 7:06:02 AM In an Access Project I am trying to find Records where the Date in the
timestamp is different than the one embedded in another field.
Data types: NDate datetime 8, NMemo ntext 16
This syntax is not allowed:
SELECT NDate, NMemo
FROM dbo.tblNotes
WHERE CONTAINS(dbo.tblNotes.N...more >>
Text Result - Grid Result performance Posted by Alex at 11/12/2006 12:00:00 AM Hello
I have SQL Server 2000 SP3
I run a query on the table which has 32000 rows. When I set result to
Text in QA it takes 40 sec , however , If I set it to Grid Resuilt it
takes 10 sec only
Well , I don't have WHERE condition in that particular query , just wanted
to know why i...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Newbie: Users/roles web application best practice Posted by Mike at 11/12/2006 12:00:00 AM I'm moving classic asp and dotnet apps to use sql server (2005 express)
instead of Access. I have IIS and SQL Server on the same machine. All
interaction between each app and its datastore will be restricted to
executing stored procedures, so I know that once I have the correct account
set...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |