|
|
|
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 |
Filter by week: 1 2 3 4 5 Old Pre-2003 Postings Posted by Mark at 10/7/2003 10:18:02 PM How do I get older bb postings. I was here about 9 mos ago
and read a post, now I can't find it anymore. I think it
was some time in 2002 or 2001. When I set the date back
that far I get 0 results....more >>
output the results of a select statement into two columns Posted by Calvin at 10/6/2003 5:06:17 PM I want to output the results of a select statement into two columns. Half of
all records will go in the first column, remaining half will go into the
second column.
Like this select statement will return one column "userid".
SELECT userid
FROM grouptable
But I want to output this userid ...more >>
Insert Sql Statement Posted by Vina at 10/6/2003 3:08:23 PM What is the syntax to insert a field data using a
variable.
TableName = Variable
I have a sql
Insert into TESTTABLE Item, Price From Tablename
I have a field TESTTABLE called Table, I need to include
in my insert statement to have Table = TableName.
I have tried the Set Table = TableNam...more >>
randomize the order of rows returned Posted by Calvin Steele at 10/6/2003 1:27:39 PM Is there a way ORDER BY clause can randomize the order of rows returned?
eg:
SELECT column1
FROM table1
ORDER BY column1 ASC
Here instead of ASC or DESC, I want the order to be random.
Is there is anyother way to do this if not possible by ORDER BY?
Thanks.
...more >>
INSERT , SELECT and UPDATE Posted by Vina at 10/6/2003 11:08:18 AM I have a sql statement
Insert Into testtable (IT) Select ITEM AS IT from
TableName
I would like to add a field in the Test table the
TableName for every record. Can someone give me an idea
on how the syntax be?
The situation is the TableName is changing so I want to
have a field in my T...more >>
SQL Query Problem Posted by Omavlana Omav at 10/5/2003 7:27:01 PM
Hi, I hv the following query that is returning correct values. However,
I want to add one more condition to this query.
select b.btdnumber as btdnumber,
b.btdtrfno as bbtdtrfno,
a.btdtrfno as btdtrfnohidden,
a.BtdAcno as BtdAcno,
a.BtdCertNo as BtdCertNo,
a.BtdShare as BtdShare
from s...more >>
W32.SOBIG.F@MM Posted by Lynne at 10/3/2003 4:39:33 PM I have the above virus and do not know how to get rid of it
but have been advised and can do it on my computer. Does
anyone know how. I can use the computer but am not great
at it.
thank you....more >>
ALTER TABLE changing DEFAULT value Posted by Dale at 10/2/2003 11:54:50 AM Hello,
I am frustrated. I have searched numerous websites
without the correct answer. I have a column:
FlgOne varchar(5) not null default 'inx'
I want to change the default of 'inx' to 'ppb'
ALTER TABLE invoices ALTER COLUMN FlgOne DEFAULT 'ppb'
does not work. What is the correct sy...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |