|
|
|
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 Advice wanted for database design concept Posted by Jake at 5/23/2004 7:31:48 PM Hello all,
and apologies if this isnt the correct group for posting this.
I am new to sql, and the thin background I have is MS Access and MS Exel, used in the past.
I have been reading this newsgroup for some time, but looks like everyone that has problems already have database structures ...more >>
Deleting records Posted by Elizabeta at 5/23/2004 7:26:04 PM I have an application that should archive records, meaning that I want to move entire record into another table, serving as archive
First, I copy the required record into the archive table
Then, I delete from the main table
I do it in one stored procedure
I use Begin Trans
after writing into...more >>
Why doesn't "where exists" work here? Posted by Sydney Lotterby at 5/23/2004 5:47:30 PM (SQL2K)
select * from insttype returns 247 hits
select distinct shortdescr, count(*) from insttype group by shortdescr
having count(*) > 1 returns 24 hits
I am trying to see all columns for the dups by using this ...
select * from insttype
where exists (select distinct shortdescr, co...more >>
Importing MSAccess data into SQL Tables Posted by Mark Findlay at 5/23/2004 11:52:19 AM I am attempting to import data from an MS Access 2000 table into a SQL
Server 2000 table, but NULL values in the Access table are causing the DTS
import to fail.
I thought that if I defined a column in SQL as 'NOT NULL', but assigned a
default value of '', then it would allow an import contain...more >>
export stored procedure to excel Posted by mike at 5/23/2004 10:29:41 AM Hi. Newbie question here. I have a stored procedure that
creates a crosstab and I can see the results of it when I
execute it in query analyzer like so:
EXEC procPlanPulmonary
I'm hoping to set something up where the results are
exported to an Excel spreadsheet instead but I'm not sure
...more >>
Query Posted by Mike at 5/23/2004 10:11:39 AM I am trying to set a query by the current date. Here is
the query:
select [Custinv].[RegisterNo], [Custinv].[LocationNo],
[Custinv].[InvoiceNo], [Custinv].[CustNo], [Custinv].
[InvoiceTime], [Custinv].[InvoiceTotal], [Custinv].
[InvoiceDate], [Custinv].[Method_Of_Payment]
from [Custinv]
w...more >>
adding database from existing db files Posted by toylet at 5/23/2004 10:05:54 AM I got a database sample.mdf and sample.ldf in the MSDE data directory. I
Would like to move them to SQL Server 2000. I copied the 2 files into
the data directory of SQL Server but SQL Server didn't report their
existence.
What command should I use to hook them up to the existing list of dat...more >>
.net connecting to Pubs database Posted by Brad at 5/23/2004 9:38:21 AM Hello, I don't know anything about .net, VB or aspx. I
have found the following example at a quickstart web
site. The application asks for the users name and a book
category (like Business). It then takes the category and
does a select on the pubs.title table looking for all
titles where t...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
date diff Posted by ori at 5/23/2004 9:25:26 AM Hi,
I'm trying to calculate the number of days from a specific
date to the end of its quarter.
I tried datediff from the date to the quarter+1 but i get
a diff of 3 month.
How can I get the last date of a quarter so I can have the
days num ? is the a simple formula for it ?
Thanks in ad...more >>
Example of a Hierarchic query in SQL??? Posted by SQL SQL at 5/23/2004 3:07:53 AM Can anyone please give me an example of a hierarchic query in SQL?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...more >>
how i can encrypt data Posted by kamal at 5/23/2004 12:35:36 AM hello,
i have a table name m_passwords with fields userid
varchar, password varchar
i want to store in password field encrypt value of
original data
how can i insert it and how can i retrieve it
i hope u understood
thx a lot for best reply
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |