| Groups | Blog | Home |
|
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 August 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 31 simultaneous stored procedures Posted by christoph at 8/9/2003 5:39:58 PM Hi there!
I have a challenging task.
Situation: A systems transfers data files to a folder and
updates the status in a SQL table. My duty was to pass
the files to another application and also update the
status table. I did it creating an updet and insert
trigger, that imports the files in...more >>
basic select, can anyone spare a couple of minutes please. Posted by Andrew Duffy at 8/9/2003 4:56:43 PM Hi i'm doing a select statement and I want to return out of the database for
a tipping comp the away team name and the home team name even though I
already have a handle on their team id's, I just don't know how to do it. At
the moment i'm executing:
select TEAM_NAME, TEAM_NAME, AWAY_TEAM_ID, ...more >>
OpenDataSource Insert into excel with no column headers Posted by njagga NO[at]SPAM ngpsoftware.com at 8/9/2003 4:39:36 PM Hello all,
Is it possible to insert data into an excel sheet with no columns
defined using opendatasource? Is there an extended property that can
be changed?
Thank you
Nik...more >>
Money data type Posted by sympatico at 8/9/2003 4:38:05 PM Hello,
How would I format a "Money" data type so that it displays two decimal
places?
I have a Money type field, but when the data is displayd on the web page it
cuts out the second decimal digit if the digit is a zero. For instance 2.50
is displayed as 2.5. I was under the impression that ...more >>
"Random" selection Posted by Ian at 8/9/2003 2:52:33 PM hi
i want to select a pseudo-random subset of records from a large data set.
any ideas how this is best achieved so that the query returns a different
dataset each time it is executed.
i am using ado.net (with c#) and sql server 2000.
thanks
ian
...more >>
TRuncating Transaction Log Posted by Rizwan at 8/9/2003 2:39:47 PM Can somebdoy please help me regarding transactions log. I was doing a lot of
testing on my database and now its final. Now I want to take a backup of
this database so that I can restore it on a client server. Problem is the
size. The .MDF file is just 7 MB but the .LDF file is 1.16 GB. How can I
...more >>
grab the time out of a smalldatetime Posted by Davef at 8/9/2003 7:53:47 AM Is it possible to grab 1:35 AM out of 8/9/2003 1:35:00 AM
--
______________________
David Fetrow
HelixPoint LLC.
http://www.helixpoint.com
davef@helixpoint.com
Interested in Affordable Email Marketing?
Check out the HelixMailer at http://www.helixpoint.com/helixmailer.asp
If you are...more >>
String Concatenation in Stored Procedures Posted by Peter Bjerkley at 8/9/2003 5:11:39 AM Hi,
I've been trying to use a declared variable that has a
string concatenation in my Select SQL statement but I've
not been able to get the Select Statement to work. Below
is my stored procedure:
CREATE PROCEDURE getAccessLevel
@CompanyId as int, @EmpRole as varchar(3)
AS
Declare @R...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trap the SQL Server Error Posted by Alastair MacFarlane at 8/9/2003 2:08:35 AM Dear All,
Can someone please advise where I can trap the errors raised by my server
when using ADO and VB? For example if I have a constraint, which during data
entry the user fails to add the proper data, I would like some validation
message to say inappropriate value (business logic in SQL S...more >>
Case Syntax Problem Posted by Scott at 8/9/2003 1:00:56 AM This sproc was fine until i added the Case When part. I've always used if
then and just wanted to learn to use Case When, but something is wrong with
my syntax.
Can anyone tell me what's wrong with the Case When part?
CREATE PROCEDURE GetDowntime
(
@sPlant Int = Null,
@sShiftID Int = Null...more >>
Invalid report schema question Posted by u352142333 NO[at]SPAM spawnkill.ip-mobilphone.net at 8/9/2003 12:48:59 AM In win2k sql , "query analyzer", executed a
"stored procedure". Checked the "write result to file".
It created a ".rpt" file. Then, in Crystal Report 9,
tried to open the rpt file, got "Can not open document",
"Invalid report schema".
--
Sent by msg_2222 from yahoo part of com
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |