|
|
|
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 Join another table with an existing join Posted by Henry at 6/25/2006 11:22:19 PM Hi
I have received some help from Wayne Snyder on this join (thanks Wayne) and
that works excellent, thanks Wayne!
However I need to join a third table "meters" m where I need to "present"
the fields m.unit and m.designation, and I also need a "where clause" m.name
like ar.name (m.name i...more >>
varbinary to float Posted by Roy at 6/25/2006 8:40:02 PM I need to export a binary column as a text file. I know the real data type
stored in the column. How do I convert a binary data type in the column to
types like float or smallint by using T-SQL?...more >>
Need a kick in the right direction w/this query Posted by Lucas Graf at 6/25/2006 8:26:24 PM Here is a link to the DDL since it would take up a lot of room here.
http://damageinc.org/DDL.html
After you use that to generate the table and some sample data, here is the
problem I need help with.
You will see the following data, if you use this query...
SELECT DISTINCT Apps.AppN...more >>
Select the duplicate field Posted by Gogzilla at 6/25/2006 7:32:01 PM Hi All
I have the data as the below table
Id Topic A Topic B
1 AA A
1 ZZ Z
2 BB C
2 YY D
3 CC H
3 CC V
4 DD G
4 DD Y
5 GG P
5 GG W
But my id field is duplicate, i would like to write the SQL statement for
selecting the data as the following results (order by Alphabet in both of ...more >>
Identify process causing huge transaction log? Posted by Sreejith G at 6/25/2006 3:15:01 PM On some weekends we are facing huge transaction log dumps, which cause
loghipping process delayed as it takes time to FTP the log. How can we
identify which process is causing the problem?
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking...more >>
Performance / Design Question Posted by Rob Meade at 6/25/2006 3:08:30 PM Hi all,
Ok - I'm building a database around the content of an XML file I've been
supplied with - the process is straight forward enough...
The supplier has provided in the XML file far more data/information than I
actually need at this point in time, however, there's nothing to say that
...more >>
Query Performance Problem Posted by Mark Pauker at 6/25/2006 12:36:13 PM We have an application that's been performing reasonably well for quite some
time. Something seems to have changed one morning last week, as the entire
application slowed down significantly. I have no idea what could have
caused the problem, as there's nothing out of the ordinary in any of t...more >>
Getting Return Value from system SPROC Posted by scott at 6/25/2006 11:26:51 AM I'm trying to learn how to write/use system sprocs for the 1st time. SYSTEM
SPROC below is a working sproc I have in the master db that returns a 1 if a
file exists and 0 if it doesn't. If I run QA CODE 1, my SYSTEM SPROC returns
the correct 1 or 0.
However, if I use my sproc as in QA CODE ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multiple Views & Web Form Posted by Chamark via SQLMonster.com at 6/25/2006 2:46:05 AM I have ViewA that sums up 4 fields from one table. I then have ViewB that
uses ViewA to calculate the results. Now I do this with 5 different tables
and then link them all to get my final results. Each View has a date range
(begin / end) that I need to pass from a Web form.
How should I go ab...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |