|
|
|
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 |
Help adding fields to a table Posted by Dan at 6/28/2007 12:50:04 PM I have a list of values in one field in a table, and I want to modify another
table that I have to add a new field for each value in the other field. In
case this doesn't make sense, I've posted examples below -
Table 1
Field 1
values - Apple, Pear, Banana, Orange
Table 2
I want to cre...more >>
how to assigned float number to DB ? Posted by guy at 6/23/2007 1:38:00 AM how can i assigned a float number with only one digit after the dot to the DB ?
i mean that i want to write this number 0.1 and not this 0.100000000 (that
what the sql does for me now..)
im using a storage procedure for this purpuse, so maybe the problem is there..
thanks !!
...more >>
Left Outer Join Only Including Matching Rocords Posted by Stan at 6/22/2007 12:31:02 PM I am executing the following SQL statement in Management Studio in a SQL
Server 2005 environment:
Select
wl.wmslocationid,il.itemid,il.citullcastartpickinglocation,il.citullcaendpickinglocation
from wmslocation wl left outer join inventitemlocation il
on wl.wmslocationid = il.citullcastartpi...more >>
Query blues... Help! Posted by Scagnetti at 6/12/2007 3:23:00 PM I have a security app that is like this: a Facility has many Apps and those
Apps may have any combination Modules, Roles, or Privileges.
Problem Query: Put together a query(s) that will delete all records related
to a single Facility.
CREATE TABLE Applications
(Appl_ID int ...more >>
Drop a Global Temporary Table using Classic ASP Posted by juan.oceguera NO[at]SPAM nav-international.com at 6/11/2007 1:44:37 PM Good Afternoon,
I am hoping someone can help me out. I want to drop a global temporary
table in classic asp after my recordset has completed printing out
it's rows.
I tried executing the following statement and I get the following
error:
Drop Table tmm_a03_gtt_YYYJCO3_0611154125
Micro...more >>
Calender Month, Trended Report Posted by Wez at 6/7/2007 1:54:02 AM Hi,
I have one table with two columns, namely "SaleValue" & "SaleDate".
A snap shot of the table is as follows:
SaleValue SaleDate
--------------- ------------
500.23 2007-06-02
601.45 2007-06-01
300.21 2007-05-30
761.00 ...more >>
Get Quick results using "Row Locator"s (fileid+pageid+rowid) Posted by Manasvin at 6/6/2007 6:23:54 PM Hi.
I've posted this to the SQL wish center (Connect/sqlserver/feedback) as a
suggested new feature.
(https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281531).
Would appreciate your comments and thoughts towards feasibility and
usability.
Suggested feature ...more >>
Creating View Posted by IronSights at 6/6/2007 1:40:01 PM I have a database I am working with that has three tables in it.
Two of the tables will be filled with information once a record is
submitted. The other one requires a response and will only get populated with
information when another transaction is fired.
(i.e. Record Submission sends an ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |