|
|
|
January 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 |
Filter by week: 1 2 3 4 5 OR in the WHERE Clause? Posted by Alex at 6/30/2006 2:45:20 PM I am trying to create a system that will select candidates for a job
based on certain criteria (i.e. Supperted States)
The candidates are allowed to choose up to 5 supported states. The
problem comes when creating the query to pull the candidates out.
I can get it to work with only one supp...more >>
memory usage/allocation/paging question Posted by tlyczko at 6/30/2006 8:43:19 AM Are there any *negative* consequences to SQL Server 2000 Standard
paging to disk more often if one reduces the amount of available RAM
from 2.0 GB to 1.5 GB to give the OS and other apps enough RAM, other
than things possibly being "slower" and whatever wear and tear could
happen to the disk dri...more >>
Returning the newest rows Posted by pltaylor3 NO[at]SPAM gmail.com at 6/30/2006 5:17:34 AM I have a query set up that returns the data that I would like, but I
would only like the latest data for each vehicle number. The query I
have set up is
SELECT TOP 100 PERCENT dbo.vwEvents.EventName,
dbo.luSessionAll.SessionName, dbo.luOuting.OutingNumber,
dbo.luVehicle.VehicleName, dbo....more >>
SPROC won't execute - insufficient permissions Posted by teddysnips NO[at]SPAM hotmail.com at 6/30/2006 2:08:50 AM I'm trying to use the SPROC below (courtesy of Erland!) to capture the
error message but it fails owing to insufficient permissions (I can't
reproduce it just now, but I think it's because it can't get access to
the DBCC OUTPUTBUFFER).
How do I give the SPROC permission to execute?
Many tha...more >>
Does anyone know of a tool that allows a SQL Server database to be Posted by kesarr NO[at]SPAM gmail.com at 6/30/2006 1:35:43 AM Does anyone know of a web based tool that allows a SQL Server database
to be
adminstered from the Internet? (in php)
...more >>
inserting into two tables and transaction problem Posted by Habib at 6/30/2006 12:14:54 AM CREATE PROCEDURE SimpleInsert (
@custname custname_type,
@carname carname_type)
AS
BEGIN TRANSACTION
INSERT Customers (CustName) VALUES (@custname)
IF @@error <> 0 BEGIN ROLLBACK TRANSACTION RETURN 1 END
DECLARE @custid int
SELECT @custid = scope_identity(...more >>
Sending email (recipients) Posted by B at 6/29/2006 6:46:27 PM Follow-up to my original post.
Is it possible for the "objEmail.To" to lookup the values from a sqlserver
table?
At the moment, I type the email address separated by a semi-colon.
TIA~
Set objEmail = CreateObject("CDO.Message")
objEmail.From = "send@test.com"
objEmail.To = "rece...more >>
SQL Server 2005 Express Posted by Birdman at 6/29/2006 6:35:49 PM I previously had the beta installed on my PC. I unistalled it to install
SQL Server 2005 Express Advanced, and it is telling me I still have the beta
version installed. It is not listed in add/remove programs. I am lost.
Please help.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Export Image Data Types to Local PC from SQL Database Posted by manmit.walia NO[at]SPAM gmail.com at 6/29/2006 1:48:58 PM Hello All,
I am stuck on a task that I need to complete. What I have is a SQL 2005
DB running with a Table called Docs. The table structure consists of
the following:
Table Structure for Docs
------------------------------------
DocID int - Primary Key
ClientID int - CustomerID
Creat...more >>
Update statement, then insert what wasn't available to be updated. Posted by rhaazy at 6/29/2006 11:52:12 AM Using MS SQL 2000
I have a stored procedure that processes an XML file generated from an
Audit program. The XML looks somewhat like this:
<ComputerScan>
<scanheader>
<ScanDate>somedate&time</ScanDate>
<UniqueID>MAC address</UniqueID>
</scanheader>
<computer>
<ComputerName...more >>
left() and right() function in MS SQL vs MS ACCESS Posted by sql guy123 at 6/29/2006 11:40:22 AM I normally use MS ACCESS vs MS SQL,, which has a left() and right()
function. I need to use MS SQL for this project but I am not familiar
with it. I have read a few books, but can not figure out how to do
this. Please help.
If I need to compare the first 4 letters of a field, with the first...more >>
Calling a SP inside a cursor loop.. Posted by satishchandra999 NO[at]SPAM gmail.com at 6/29/2006 9:57:49 AM I have SP, which has a cursor iterations. Need to call another SP for
every loop iteration of the cursor. The pseudo code is as follows..
Create proc1 as
Begin
Variable declrations...
declare EffectiveDate_Cursor cursor for
select field1,fld2 from tab1,tab2 where tab1.effectivedate<Getda...more >>
Differences between SQL2000 Dev. Edition & SQL2005 Dev. Edition Posted by x-rays at 6/29/2006 6:34:17 AM Hello all,
Can anyone tell me or suggest links about differences of SQL Server
2000 Developer Edition & SQL Server 2005 Developer Edition?
Specifically, I need to know about the licencing policy.
So far I know that SQL Server 2005 Developer Edition is licenced for
develpoment (what else), t...more >>
mysql database session management with cj tracking Posted by Nospam at 6/29/2006 2:08:56 AM Does anyone know of any session management with mysql scripts that uses cj
tracking?
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |