|
|
|
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 31 RAND() in a TF Posted by Stephen J Bement at 3/6/2004 3:25:21 PM I am trying to create database populator that gathers a random FirstName and
a random LastName. I need the output from the first stage to return a Table
variable( so I can JOIN to other tables). I am being thwarted by "Invalid
use of 'RAND' within a function."
Does anyone know of a way to acco...more >>
Time Intervals Posted by MikeM at 3/6/2004 3:16:06 PM I've capture total number of seconds from a start date and end date. I want to be able to display the time interval in
day(s) hours:minutes:seconds
Any assistance would be great
thanks
MikeM....more >>
Dynamic Cursor in Stored Proc. Posted by Larry Pensil at 3/6/2004 2:46:05 PM <thanks> I am new to Trans. SQL, so forgive in advance </thanks
In essesnce, the stored proc assigns a set of records from on user to another by taking the following steps:
1. Build a dynamic sql statement based on parameters passed (the where clause will change based on retrieval criteria user s...more >>
sort Posted by CSharp ( ILM ) at 3/6/2004 1:37:35 PM how to sort the following string column
1
2
10
3
4
11
as
1
2
3
4
10
11
and not
1
10
11
2
3
4
Thanks
...more >>
if statement in select clause Posted by santoshamb NO[at]SPAM yahoo.com at 3/6/2004 1:06:30 PM I'm creating an update sproc that will be used by a client program,
which will update a variable combination of columns for a particular
row. What I'd like it to do is if nulls are passed in for parameters,
then it will set a variable to whatever is currently in the database
for that record.
...more >>
join to get all combinations Posted by Joe Ross at 3/6/2004 11:30:10 AM I'm looking to do a join on two sets (from the same table) and end up with
all combinations of the two sets as my result set. So given:
Set1 contains A and B
Set2 contains C and D
I want my join to result in
A C
A D
B C
B D
I have some SQL that accomplishes this, but it seems like a comp...more >>
Slow Query Posted by Eyad at 3/6/2004 7:06:08 AM Hi everybody
- I have the following table [mt]
(Guid UNIQUEIDENTIFIER PRIMARY INDEX
Number INT, -- inde
Name VARCHAR(250)
Code VARCHAR(250)
Mask BIGINT, -- inde
.... and 50 more field
- This table has 160,000 record
- The following query
Select top 1 [Guid] from [mt] where [Mask] & ...more >>
difference between stored proc and user defined functions Posted by dk at 3/6/2004 5:42:31 AM
what is the difference between a sql stored procedure
and a sql user defined function?
tia,
dk...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
saving tables in MSDE Posted by Vic at 3/6/2004 1:20:11 AM hi,
i want to connect to tables stored in different data
sources (SQL Server or Oracle or Access etc), make the
necessary joins and store the result in an MSDE database
locally. how do i accomplish this using VB.NET?
thanks,
Vic...more >>
Add new records Posted by HartA at 3/6/2004 12:34:56 AM
I have a table where I just want to duplicate the data that's already
there. Except I want to change the first field to a new code.
I want to keep the old records around just in case of problems with new
format.
Record #1 in file.
Field1 - 100
Field2 - Address1
Field2 - Addr...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |