|
|
|
January 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 |
Filter by week: 1 2 3 4 5 Combining Values Posted by at 6/29/2007 4:03:11 PM I need to do something that goes against normalization, but it is what
the client wants. Let's say one person has several addresses. I need
to be able to take each of those addresses and combine them into one
field. So I need to take this:
John Doe | Address 1
John Doe | Address 2
Joh...more >>
Mass Update on Table with Trigger Posted by paulmac106 NO[at]SPAM gmail.com at 6/29/2007 1:20:04 PM Hi,
I need to update a field in about 20 records on a table. The table has
an update trigger (which updates the [lastedited] field whenever a
record is updated). As a result I'm getting an error: "Subquery
returned more than 1 value.", and the update fails.
Is there a way in the stored proc...more >>
Scope in derived tables Posted by Stephen2 at 6/29/2007 11:09:05 AM This is kind of what I'm trying to do in my MS SQL 2000 query. Should
I be able to reference s1.col1 inside the 2nd derived table?
I'm getting 'Invalid column name col1' and it's coming from the 2nd
derived table (I've commented out other refs to just it to check).
Maybe I need to use a temp...more >>
Connecting to SQL 2005 using VB6 Posted by Charlie at 6/29/2007 11:06:15 AM Is there some reference material that shows how to connect to a SQL 2005 DB
using Visual Basic 6? Any help is appreciated.
...more >>
Mismatch between Count(*) and Properties -> Rows Posted by teddysnips NO[at]SPAM hotmail.com at 6/29/2007 7:28:03 AM I have a client who has reported a discrepancy in their database. In
their test database a certain report returns 5,333 rows, but in the
production database it returns 5, 332 rows.
I'll get to the bottom of it in due course, but I came across an
oddity. I wanted to know how many rows there w...more >>
Output Column names in each Row along with the row Value Posted by Yas at 6/29/2007 3:09:59 AM Hello,
I was wondering if anyone can help me figure something out.
Is it possible to do a querey in MS SQL server and have the results
returned so that each result in each row is preceeded by the column
name?
eg. instead of usual output -> colName1, colValue1,
colName2,colValue2,colName3,c...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |