| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Query for sorting out matching record Posted by mk at 1/14/2004 11:51:56 PM dear sir ,
i have two table test1 and test2 with same tabel fileds.
create table test1 (route char(6) NULL,
Driver int NULL)
create table test2 (route char(6) NULL,
Driver int NULL)
in test1 i have date as follow
route driver
101 00...more >>
Query on 2 different DB's Posted by brian at 1/14/2004 1:56:04 PM Can I join together tables from different databases.
For Example:
Test.Customers
LS.Shipping
If so do you just need to make sure that the full path is
specified in the entire query?
Thanks...more >>
*= to Left Outer Join Syntax Posted by Chris at 1/14/2004 4:36:16 AM How do I convert the following to ANSI SQL 92 i.e. use LEFT OUTER JOIN etc
SELECT TP.Period
TP.SiteId
SA.TillId
CP.ProductTypeID
CP.ProductID
CP.CountryProductId
IsNull(P.OpenBa, 0.00) as OpenBal
IsNull(P.LastShiftClose, 0.00) as LastShiftClos
INTO #PosThisPerio
FROM NewPositi...more >>
Converting Varchar to DateTime Posted by LilBill at 1/13/2004 1:54:41 PM Hey,
I need to update a table with the most current date in a table that has
just been populated with data from a mainframe where the date is stored
mmddyyyy ('12311997') a DTS package inserts the dates into a varchar
field. I have tried
UPDATE ArchiveControl SET ThruDate = (SELECT
CO...more >>
need some advise Posted by Newbie at 1/13/2004 9:32:01 AM i have various database in our company and would like the
others (client pc) able to enter/modify data to the
central database in the server. what kind of setup should
i plan to have?
network setup:
multiple pcs
1 server (plan to install ms. sql 2000)
do i need special program such as...more >>
DateDiff Syntax help please Posted by James Mckillop at 1/13/2004 6:32:29 AM I am trying to get infomation from a field that is
storing dates. I need to using a date find out what
records were processed on that date. Someone told me I
could use datediff and I can't quite get the syntax right.
I tried
Use wss
Select *
From cartonlist
where closedtime>= dated...more >>
how to get the desired results by SQL scripts? Posted by alex lee at 1/13/2004 1:21:24 AM drop table mytes
g
create table mytes
sn int
code varchar(8)
ins_no varchar(6)
g
insert mytest values(1, '01', 'A'
insert mytest values(1, '01', 'B'
insert mytest values(2, '02', 'A'
insert mytest values(2, '02', 'D'
insert mytest values(3, '01', 'A'
insert mytest va...more >>
Printing results pane Posted by T. at 1/12/2004 2:23:05 PM Is it possible, after running a SELECT statement, to
print the results pane? I have been cutting and pasting
into Excel, but if there is a way to get it to print
directly, it would save me some time?
T...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
DateTime Formatting Posted by Terry Steyaert at 1/12/2004 11:49:17 AM We use MSDE in multiple languages. In our MSDE database,
we have several DateTime columns. In English MSDE, we
format the date in a string as ' %B, %d, %Y %H:%M:%S', so
the string comes out like: ' March, 25, 2003 00:00:00'.
This works just fine. In using our system with French,
we r...more >>
Finding column names Posted by Mike Hoyt at 1/12/2004 11:05:24 AM How can I get a list of all of my column names and
associated tables in a given database? TIA Mike...more >>
Update Syntax Posted by Bill Papi at 1/12/2004 9:56:18 AM I have been going nuts trying to figure out the correct
syntax to update from one table to another. Here is what I
have....
Table1
ServerName IPADDRESS BUILDNUM (and a few others)
Table2
ServerName IPADDRESS BUILDNUM (and a few others)
WHat I am trying to do, is to take ...more >>
sql parser-table name Posted by Arrun S at 1/10/2004 3:06:05 AM H
I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem
TIA
Arrun S...more >>
get rows based on month and year ints Posted by Mark in Miami at 1/8/2004 11:04:41 AM I have available the month and year integer. I need to
generate a query that will get all records where
startdate falls in the month and year supplied
SELECT * FROM vwEvent WHERE StartDate .... [month] and
[year] is the same as the 2 integers I have....
Am I making sense??...more >>
combining left outer joins Posted by Hortence at 1/8/2004 9:51:09 AM I need to run a query in Query Analyzer that pulls data from three different tables. I need every row from Table 1. I need the corresponding rows from Table 2. Table 2 does not contain a row for every row in Table 1, so I need it to return "null" wherever Table 2 does not have a row corresponding...more >>
compare multiple datefields within one row Posted by Erwin at 1/8/2004 5:55:14 AM Hi,
I have a table with multiple date fields per row:
NAME PLDAT1 PLDAT2
PLDAT3
Name1 15-12-2003 11:00:00 16-12-2003 16:00:00 16-
12-2003 20:00:00
Name2 15-12-2003 10:00:00 16-12-2003 18:00:00 15-
12-2003 08:00:00
Name3 15-12-2003 18:00:00 14-12-2003 13:00:00
00:00:00
I would ...more >>
Nested? Posted by Igloo at 1/8/2004 3:46:05 AM Hi all
I have a query that looks like so
SELECT GLDCT AS [Doc Type], GLDOC AS DocNumber, GLALID AS Person_Nam
FROM F091
WHERE (GLAID = '00181913'
However by stipulating that GLAID = GLAID I cannot get the person_name as not all the GLALID fields are filled in. from my reading ...more >>
Row date and Time Posted by Alexander Lucas at 1/8/2004 12:10:03 AM How do I write a query in sequel which will return the
date and time of when a row was written to a table.
Thanks in advance...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |