|
|
|
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 How to get a value from another column where MAX(field) = TRUE? Posted by Sander at 2/15/2004 8:57:24 PM Hi! I hope somebody has a faster solution for me!
Basicly I have a table containing:
client_id, orderdate, category, amount
I want to select the amount where MAX(orderdate) = true grouped by
year
I currently have:
SELECT
amount
FROM orders A
INNER JOIN
(SELECT
client_id,
...more >>
how to scramble data in a table Posted by SND at 2/15/2004 7:37:02 PM Does anyone have a neat way to scramble data in one table?
I have a Person table with fields (PersonID, LastName, FirstName,
MiddleName). PersonID is a sequential number from 1 - 1,000,000 and there
are NO gaps in the sequence. I need the last names to be scrambled with
last names and so for...more >>
error systax :156 Posted by Eselyn at 2/15/2004 6:08:06 PM CREATE PROCEDURE dbo.updateadminpass
(
@adminname1 nvarchar(50) ,
@adminpass1 nvarchar(50)
)
As
UPDATE admin SET
adminpass = @adminpass1,
WHERE adminname = @adminpass1
GO
well here is my coding. I'm new learner in sql.Please tell
...more >>
create multiple tables Posted by Paul at 2/15/2004 5:56:08 PM What's a good way to create 7000 tables and fill them with data from existing text files?
I have 7000 text files with stock quote data in them and I'm considering writing a long sql script that creates the tables and inserts the data from the text files, if that's possible.
Is this the way to ...more >>
SELECT DISTINCT? Posted by Jon at 2/15/2004 5:54:48 PM Hi,
using sql server2000/win2003
2 tables
CategoryClicks
CategoryID int
UserID int
ClickDate datetime
CategoryName varchar
Category2
CatID int
ParentID int
CategoryName varchar
I want to join the 2 on CategoryClicks.CategoryID = Category2.ParentID and
pull up the 5 most recent (di...more >>
Logged Actions Posted by Paul Ilacqua at 2/15/2004 5:29:41 PM Is there a simple answer to what actvities trip up a database that needs
point in time recovery. I keep my BCP Bulk /copy actvities for off times
followed by a full backup. Will Select Into break my Tranasction Log Chain?
I use my own built log shipping from a 7.0 db to 2000. I backup up once...more >>
Alter table by adding new column with not null Posted by jungewum NO[at]SPAM yahoo.com.au at 2/15/2004 5:23:56 PM Hi,
I have an existing table Student and I want to add a new column
address2.
alter table Student add address2 char(80) not null;
I got the following error:
ALTER TABLE only allows columns to be added that can contain nulls
or have a DEFAULT definition specified. Column 'address2' can...more >>
Count Query help Posted by Mike Barbone at 2/15/2004 2:37:41 PM Hello,
I need to do a simple count query for a column, QColumn for each value in
the column. I know the basic, SELECT QColumn, Count(QColumn) FROM myTable
Group By QColumn will return what I'm looking for, with a normal column that
holds 1 value.
In this instance, QColumn is varchar(12) and...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
what is the value of a currency format column and.... Posted by Trint Smith at 2/15/2004 10:15:14 AM can you change the format after you already have the column format in
there with data?
Thanks,
Trint
..Net programmer
trintsmith@hotmail.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
Query Posted by jen at 2/15/2004 9:01:38 AM Hello Gurus.
I have data something Like this
seqnum job createddttm
1 100 01/01/2004
2 200 01/10/2004
3 300 01/15/2004
4 100 02/01/2004
I want the Distinct Latest(createddttm is max) Jobs
Result should be as fol...more >>
insert current datetime Posted by Dmitri Shvetsov at 2/15/2004 1:52:03 AM Hi,
Can somebody write a command to insert a new record with a current SERVER
datetime in a column? This column supposed to be a PK. Is it possible
without a SP?
Dmitri
...more >>
Help Primary Key violation Posted by Andrea at 2/15/2004 12:56:02 AM I'm trying to port access DB to Sql Server database.
With access I can insert several rows also if someone are present in the
destination table.
For example if I have 20 rows in the dest table and I want to insert 30 rows
from orig table to dest table, but 20 rows are present in the dest table, ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |