| Groups | Blog | Home |
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 Converting delimited varchar @parameter for use in NOT IN() Posted by Patrick Russell at 3/7/2005 8:12:57 PM I am creating a stored procedure which is passed a comma delimited string of
ids as a varchar datatype. The param is to be used in an SQL statement such
as:
CREATE PROCEDURE GetFromTable
@IDs varchar(255)
AS
SELECT * FROM table WHERE iId NOT IN(@IDs)
GO
The problem is that the iI...more >>
Temp table does not always get correctly populated Posted by kjhealey NO[at]SPAM gmail.com at 3/7/2005 2:03:45 PM Using SQL Server 2000, I have a stored procedure that creates a temp
table and populates it with statement similar to the following:
select Col1
into #TempTable
from Table1
where Col2 = @Var1
In my test case, the temp table should always be populated with 50
records. However, sometimes (...more >>
Store Procedure at startup Posted by Jinsong at 3/7/2005 1:14:01 PM Hi Group:
I have a store procedure. When I first run it in Query Analyzer, it
takes 25 seconds to finish, but after that, it only takes about 2
seconds. In my application, I create a ADO connection to the database
to execute the store procedure, then close the connection. this makes
the execu...more >>
DBA need domain admin rights? Posted by nlehrer NO[at]SPAM yahoo.com at 3/4/2005 2:01:40 PM hi,
does a sql server DBA need to be a win2k domain administrator to
effectively do his/her job?
...more >>
Curiosity sql EM question Posted by Herb Bartow at 3/3/2005 7:28:28 PM Anybody know why in sql 2000 enterprise manager, if you
edit a table or view, the 'dialog box' or 'model window' has the
minimize and close icons in the upper right corner BUT if you edit
a stored procedure, no icons ????
We reinstalled couple times and installed service packs before
we real...more >>
Select statement question Posted by Paul Singleton at 3/3/2005 9:20:09 AM How do I build a select statement that will show me all records in a
table where there is more than one record for TICKETID?
In other words, I want to know which TICKETID numbers show up more than
once in the table.
Thanks!...more >>
Remote queries using sp_executesql run inconsistently Posted by vogelm NO[at]SPAM meijer.com at 3/3/2005 7:11:28 AM This one has stumped me!
I recently implemented a process to monitor database usage and growth
on our production servers. I use on server as the "master" that
collects data from all the other servers into one database. The
problem I'm having is that only every other day the process completes...more >>
Database design question Posted by Tim Mavers at 3/2/2005 8:52:56 AM I have a series of database objects that represent things such as people,
accounts, etc. I have a set of options (boolean) that I need to add to
these objects. Normally I would just create a bit field for each one and be
done with it. The challenge however is that there could be hundreds o...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Degree of separation search Posted by Shabam at 3/1/2005 2:36:37 AM I have an application that lets users search based on degree of separation,
so for instance, a user can search for age, hobbies, etc. and limit the
search to just users who are 1 degree separate, 2 degrees separate, or 3
degrees separate.
However as it stands now, searches are taking a long lo...more >>
Year function vs between Posted by ambradnum NO[at]SPAM hotmail.com at 3/1/2005 2:27:27 AM Hi there
Is there any difference in speed between
WHERE Year(SomeDate)=@SomeYear
and
WHERE SomeDate BETWEEN @StartDateOfSomeYear AND @EndDateOfSomeYear
Which is preferred?
TIA
Alan
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |