|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 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 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Processing rows in a trigger Posted by Leila at 9/2/2006 9:08:04 PM Hi,
Users perform updates on the table and they can affect more than one row in
single DML statement. What if I want to perform something on each record in
Inserted table? Should I necessarily declare a cursor?
Thanks in advance,
Leila
...more >>
Scheduled VS Made Posted by Paul Ilacqua at 9/2/2006 4:35:21 PM I am looking for the best method the extract "Supposed to make" - "Did
Make", where "Supposed to make" and "Did Make" come from different queries.
I need to show when parts are scheduled and not made, and when parts
are made and not scheduled.
I have no trouble pulling the data, the way...more >>
Need stored proc. Add record to Tbl2 if it exists in Tbl1 and not Posted by Sandy at 9/2/2006 1:57:01 PM Hello -
I have two tables. Tbl1 gets updated automatically. I would like to update
Tbl2 if a record exists in Tbl1 that is not in Tbl2 and delete a record from
Tbl2 if it is not in Tbl1. I am only concerned with one field -
Tbl1.FullName and Tbl2.FullName. They are both varchar(50).
...more >>
select last row for each value Posted by realgeek NO[at]SPAM gmail.com at 9/2/2006 10:55:01 AM Hi.
Say I have a table with 3 fields, Date, Price and Code. There are many
different priceswith different dates for each code. I need a join
condition that will add latest prices for each code into some big query
that outputs one row for each code.
The solution I came up with involves subq...more >>
Smalldatetime problem during INSERT to DB Posted by haldunn at 9/2/2006 6:55:02 AM Hi all from Turkey.
i'm using VB.NET and SQL Server 2005. I have an editbox(mask : dd/mm/yyyy).
And i want to insert it to table. My table's column is smalldatetime. when
i'm insert it, DB Column's value is being 01/01/1900 00:00:00. But i want for
example : 12/05/1969 (dd/mm/yyyy)... But i c...more >>
Some records in a column imported as null Posted by itsyash NO[at]SPAM gmail.com at 9/2/2006 4:58:13 AM Hi,
I am trying to use the import export wizard to transfer data from Excel
to SQL Server 2000.
The challenge:
I have a column which has numbers that are manually entered. Some
numbers have "/" between them. There are also a few email addresses in
the column but I cannot change that. Whe...more >>
Divide By Zero - How to Prevent with the following statement Posted by Mark Moss at 9/2/2006 1:04:33 AM Ladies / Gentlemen
Would one of you take a stab a converting the following statement so
that I do not have to worry about difide by zero errors.
Z4.ProfitPercent = ( ( ( Z4.CurrentPrice / Z4.CurrentSplit )
* Z4.TotalPOSMovement ) / ( ( ( Z4.CurrentPrice / Z4.Curr...more >>
Get the script for an object using T-SQL (without using SQL-DMO) Posted by arch at 9/2/2006 12:00:00 AM Is there any way to get the script (ddl) for an object (say a table) without
using SQL-DMO. I actually want to use only T-SQL to get the script for an
object. For example, I may want to write a query that returns a list of
objects that use a CASE statement by using a where clause that says
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |