|
|
|
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 |
query Posted by Tiffany at 11/30/2005 6:35:02 PM Hi,
I have some models that have hyhen in between. e.g.1200LD-VCD, abc-1234
May I know how to remove the hyhen.
Thank you
...more >>
SQL HELP WITH LAST TIME ONLY Posted by TYE at 11/28/2005 4:13:07 AM I have got a SQL query that get information from different databases,
I have all the information that I need but now I want the last information
I have three columns they are the following
Number
Durations
Date and time
I want to only select the last day and time from each records, at ...more >>
Merging mutliple rows from one table into columns in an other Posted by Yeroon at 11/19/2005 9:48:02 AM Hello,
I have two tables. One is an export from a different database and one is the
destination table.
The Export table looks something like this:
EmpID = the ID of an employee
Contract = Code for the contract(s) the employee might have
MainContract = if -1 it's the main contract, else ...more >>
Grouping by Distinct Posted by PML at 11/17/2005 5:26:05 AM Hi,
I have 2 columns of data, one has an Agent code and the other has
information about the Agent. There are duplicates of the Agent code in the
1st column, but different info in the second. For example:
Col 1 Col 2
Agent 1 Data 1
Agent 1 Data 2
Agent 1 Data 3
...more >>
Comparing Data between Tables Posted by Randaddyz at 11/16/2005 11:53:09 AM I messed up and now we have two tables that have slightly different
information. What is a query that would allow me to look at the data
differences between the two tables?
--
Ever Learning Net Admin...more >>
Conditional Join Posted by Daniell at 11/11/2005 12:17:02 PM What I have are two different tables that I am going to join. Everything in
the first table should be pulled. The second table should only pull the
information when the field ACTION equals the word "ORDERED". Is there a way
to join two tables on just a literal
Table A
Tran Date_ORD ...more >>
Return single line Posted by Daniell at 11/10/2005 1:50:14 PM What I am looking for is to read a file that has three columns to it and
return the lastest part number with the newest date.
part Number Date QTY
2534 100102 20
2534 100505 24
2534 092104 95
2534 092505 87
2534 ...more >>
IF statement in SQL? Posted by bakedmike via SQLMonster.com at 11/8/2005 12:00:00 AM Can I write an if statement in T-SQL for MSSQL2K or do I have to do it in the
WHERE clause?
Would like to say:
IF field1 = e
insert into db2.accounts from db1.accounts where in db2.employee
IF field2 = c
insert into db2.accounts from db1.accounts where in db2.company
--
Message pos...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Max Posted by Travis at 11/7/2005 8:31:14 AM Hi ,
I have a list of data as show below ,
Data1 Update Date
--------- ------------
1 01-01-2004
2 01-01-2004
3 01-01-2004
1 01-01-2005
2 01-01-2005
3 01-01-2005
How can I build a q...more >>
Finding the Shift for current hour Posted by Pradeep TN at 11/5/2005 7:43:02 AM I have a table which stores the shift timing like this:
ShiftId StartTime EndTime WeekDay Shift
1 6:00:00 AM 6:00:00 PM 7 Shift A
2 6:00:00 PM 6:00:00 AM 7 Shift B
4 6:00:00 AM 6:00:00 PM 112 Shift C
8 6:00:00 AM 6:00:00 PM 112 Shift D
16 8:00:00 AM 5:00:00 PM 62 Day
32 8:0...more >>
No Decimal trailing sign Posted by Stan at 11/3/2005 5:49:12 AM I have a field defined as (decimal 9(15,2)) and the recipient of a conversion
..txt file wants to see just the meaningful digits, no decimals, no zero fill
but does want to
see a trailing minus sign for negative numbers. So they want to see 550.45
as 55045 and -45.25 as 4525-.
--
Stan ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |