| Groups | Blog | Home |
|
March 2003 April 2003 May 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 |
Find unmatched records Posted by msmith1265 NO[at]SPAM hotmail.com at 9/26/2007 1:56:08 PM I have a table that holds donation amounts and dates. Here is a
simplified version of it.
Table Name: Donations
Fields:
Member_ID
DonationDate
Amount
What I need to do is find every Member_ID who made a donation in 2006
that did not make a donation in 2007. Is there any way to do this?
...more >>
Group By Multiple Date Columns Posted by sqlhiker at 9/22/2007 3:02:16 PM Hi All,
Thanks for dropping by my post.
I have a table which is of this form.
ID MS030_A MS030_F MS036_A MS036_F MS040_A MS040_F
ZZ0023 2/16/06 2/16/06 8/10/07 8/10/07 11/21/05 11/21/05
ZZ0031 8/10/07 4/5/07 8/9/07 8/9/07 3/22/07 3/22/07
ZZ0077 8/9/07 9/7/07 8/10/07...more >>
Copying tables without data Posted by tcb at 9/21/2007 12:37:51 PM I have an existing SQL Server 2005 database. I want to copy the
tables without data into another database.
This seems like a simple thing, but I am new to SQL Server and can't
seem to find the answer.
How do I do that?
...more >>
Problem with Select Into and Insert Into.. Records Always Inserted at the Top Posted by PavanR at 9/21/2007 7:44:02 AM Friends,
Take a look at the Code Below :
drop table t5
go
Select * into T5 from (Select * from T1) a
Insert Into T5 (f1,f2) (select top 2 f1,f2 from T2 )
The above code from a T-SQL always inserts Records from T2 at the TOP
of T5.. have also tried dividing Select Into and Insert Into i...more >>
How do I use ORDER BY CASE with multiple fields Posted by Karl at 9/20/2007 7:01:18 AM I have a fairly complicated stored procedure which can be ordered by
the user by use of a sort parameter (@Sort) of data type int
The code for this ORDER BY CASE is shown here...
ORDER BY CASE
WHEN @Sort = 0 THEN [CourseCode], [FullName]
WHEN @Sort = 1 THEN [HierarchyName], [Full...more >>
Using wildcards in group by and having expressions in MS SQL Posted by Karl at 9/19/2007 3:34:36 AM Hi All,
I have the need to perform a query on data at a certain hierarchical
level to return summary data.
If I explain what I want things might make more sense...
At the moment I have a view that shows how many courses have been
allocated to users throughout the entire company, how many ...more >>
SELECT * vs SELECT col1, col2 Posted by Danny Burton at 9/17/2007 9:25:30 PM I know that in order to reduce network traffic you should always select only
the columns you require but I have a stored procedure which must **always**
return all columns from a specific table.
When returning all columns from a table is there any performance gain (or
any other reason) for ...more >>
Error converting data type nvarchar to float Posted by Jerry at 9/15/2007 3:48:08 AM Hi all ~
I'm trying to update the items table column picturename:
UPDATE ITEM
SET ITEM.PictureName=IMAGES$.PICTURE
--ITEM.ExtendedDescription=SHEET1$.Ext_Discription
FROM DBO.IMAGES$,ITEM
WHERE ITEM.ITEMLOOKUPCODE=IMAGES$.UPC
I recevied the folowing error:
Server: Msg 8114, Level 1...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Query to a Table... Posted by Blue Streak at 9/14/2007 2:00:34 PM Hi, folks!!
I need a little advise from the gurus of this group. I am trying to
copy data from a view/query in one database into another database as a
table to troubleshoot a project I'm working on. One database is MS-
SQL Server 2000 and my database is MSDE 2000. I have tried the method
o...more >>
Replication issues after a Database Restore - Unable to drop or create Transactional Replication Posted by Query Builder at 9/13/2007 10:01:29 AM Hi,
I have transactional replication set up on on of our MS SQL 2000 (SP4)
Std Edition database server
Because of an unfortunate scenario, I had to restore one of the
publication databases. I scripted the replication module and dropped
the publication first. Then did a full restore.
When...more >>
SQL 7 & Server 2003 Posted by Neil at 9/13/2007 12:00:00 AM Has anyone heard of any problems running SQL 7 under Windows Server 2003?
We're upgrading to 2003 and are wondering if we can keep SQL 7 with the new
OS.
Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7
mode? Or would it be better to just convert it to SQL 2005?
...more >>
SQL Report Query Posted by MC at 9/5/2007 1:32:13 PM I have a report query I can't figure the select on. The table is like this:
Account Customer Operation Amount
-------- ---------- ---------- --------
1 10 4 30
1 10 5 15
1 ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |