|
|
|
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 SQL Server and union queries Posted by Marty at 10/31/2003 9:14:32 PM I need to create a union query. When I do I receive an
error message that says "The Query Designer does not
support the UNION SQL construct.". How can I get around
this.
Thank you in advance for any help that anyone can give me.
Marty...more >>
List non-sequenced number Posted by KG6LFZ at 10/30/2003 3:48:03 PM I have Access 2000 database. In its table, there is a
field, called Case and field type is number.
Usually its data is in sequence. But sometimes, it skips
one number. I want to list the beginning of records, and
end of sequence.
For example, data is 1, 2, 3, 5, 6, 7, 8, 10, 11.
Rep...more >>
Insert Date field. Posted by Munish Sharma at 10/30/2003 2:16:01 PM Hi,
I've two columns in table importDate(char) and Import_Date
(Datetime). I want to import the data of char field in to
datetime field. when I'm trying to insert tha data is
getting messed up.
Please let me know if I've to use any function to convert
Char field to Datetime.
Regards,...more >>
CASE statement in a WHERE clause Posted by anonymous at 10/30/2003 9:18:06 AM Below is my WHERE clause:
WHERE SOP10200.SOPTYPE = 2 and
SOP10200.QUANTITY > 0 AND
SOP10100.DOCID NOT IN ('SP','DF','TS') AND
SOP10100.VOIDSTTS = 0 AND
SOP10100.DOCDATE >= @StartDate and
SOP10100.DOCDATE <= Left(@EndDate,12) AND
(CASE @SelectBy WHEN 1 THEN (IV00101.USCATVLS_1
BETW...more >>
Temp table names Posted by Dinesh Balakrishnan at 10/30/2003 3:22:48 AM Hi,
I am trying to work out the actual table names for
temp "#" table names created in a session.
For e.g if i have a seesion which has created a temp table
#temp1 what will be the actual table name in sysobjects?
I can see an entry in tempdb..sysobjects saying
"#temp1___________________...more >>
Reading Registry Entries... Posted by Santhosh at 10/29/2003 12:05:54 AM Using DBCC commands or any other commands is there a way i
can check for the
registry entries made on that machine???
Santhosh.C.
...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |