|
|
|
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 |
Table Query Posted by Ryan Mcbee at 10/29/2007 7:06:01 PM I have a table that has the following three fields and values that I am
trying to build a query on;
Column name-FEDERAL, FICA1, FICA2
Values- 1 , 100 , 200
2 , 300 , 400
How can I get a query to look like this?;
Column- TaxCode, ...more >>
Select Formatted Text From Table Posted by Tsheth at 10/24/2007 8:59:01 AM Hi,
I have a text column in a table and data stored in it contains formatted
text (with carriage returns, tabs, and spaces). When I perform a select on
that column, data returned is non formatted. How do get the formatted data?...more >>
Pulling data that could be in one of 2 tables Posted by Matt M at 10/24/2007 7:03:03 AM Note: I am using this to create a report with SRS
I need to pull some data that could possibly be sitting in one of two
tables. Table1 is the "Current" table that holds Orders that have not shipped
yet. Once all of items on the Order have shipped the Order moves to Table2
and an invoice is ...more >>
Quarterly Data Syntax Posted by Ryan Mcbee at 10/22/2007 7:36:03 AM I am trying to build a query that will return what quarter the data is in.
How would I begin to build this logic? In my table, all I have is a single
date of the transactions. My date column looks like this; "2014-02-01
00:00:00.000".
Thanks in advance,
Ryan...more >>
indexes and selects Posted by analizer1 at 10/19/2007 9:57:01 AM Im trying to figure out the best way and/or fastest way to Match some data
comming in....example below
the below is all the incomming information i recieve to match to a row in
our system, we do send out a TransactionId but reports comming
back in do not reflect this id.. so i have to match th...more >>
Aggregate rows in a Table Posted by Sasikumar at 10/17/2007 2:14:14 PM Hi,
I have a Table with rows as below
A 1 10
B 1 15
A 2 3
A 1 5
A 3 10
Since the 1st & 4th row has values of A & 1 in first & second column, I wanted to aggregate the values in third colum. I wanted the result to be
B 1 15
A 2 3
A 1 15
A 3 10
How can this be done?
From ...more >>
Select without blank spaces Posted by Ryan Mcbee at 10/15/2007 7:29:05 AM I am writing a query in which I want to select a field and not have the
trailing blank spaces. Here is my query: select employid, lastname + ',' +
frstname as name from upr00100
The results look like this "West ,Paul" or "Mcbee
,Ryan"
How can I get results...more >>
Query for only specific rows in a table? Need Help with Query Posted by Gordon at 10/9/2007 8:39:00 AM We have a stored procedure that removes old data from a very large (millions
of rows) table and puts it into an archive table. It grabs the top 5000 rows
and moves them.
B/C the database is in production and is heavily used, the job is run every
5 minutes
to avoid performance issues. Whe...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using Update...Set to update a table Posted by Dan at 10/4/2007 7:54:00 PM I have a table (we'll call it table A) with two fields in it; one is an ID,
and the other (named "State") currently only contains null values. I'd like
to update the "State" field with values from another table in the database
(table B). The two databases share the same ID field, so I can join...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |