|
|
|
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 31 Columnheaders from query analyser to excel - SQL 2005 Posted by menno.abbink NO[at]SPAM gmail.com at 7/23/2006 10:41:09 PM Hi,
When building queries I'm used to analyse the results within MS Excel.
Whe I use SQL 2005 to do this, the columnheaders aren't included in the
copy/paste action, in SQL 2000 they where.
How can I do this now?
Thnx.
...more >>
Automatic triggers Posted by panda at 7/23/2006 10:10:01 PM Hi,
I have a table that has a timestamp of when the entry was modified. Is there
a function or procedure / trigger that will be able to check daily to see if
three months has passed since the entry was modified?
Thanks...more >>
HOW TO USE JOIN QUERIES Posted by vincentstudy at 7/23/2006 9:55:21 PM hi to all,
i am using ms-sqlserver2000. i am not understand left
join right join and outer join how to use this, and where to use this
queries.
by
vinci
...more >>
Extracting item detail from an invoice table... Posted by ITDUDE27 at 7/23/2006 8:10:02 PM Hello,
I need help with a sp that I currently have that is extracting data for a
commision report. the current report is displaying ( Invoice_num,
payment_amt, last_paymentDate, location_id, rep_id, comm_amt, total_amt) .
Now I need to check against another table to check the if the Item_i...more >>
A Complicated problem Posted by mita at 7/23/2006 1:57:01 PM Hi guys
I have not been able to solve this problem from quiete a long time.My
question is
i have two tables- practices and practitioner
the practice table contains information on the practices that are performed
by practitioners in different cities and a field called Cost
And an additiona...more >>
thanks Posted by mizi at 7/23/2006 11:24:20 AM Hi, David. thanks for your reply. I also don't understand what are they
said. I cannot get an example code from they after I contact them several
times. below is what they said :
"While we do not allow remote
connections to our database servers, you can connect to another MySQL
server from ...more >>
Pattern Matching Posted by Bahman at 7/23/2006 10:37:02 AM Hello!
How would I do pattern mathing, such as:
'ABBBC'
as in: an A, one or more B's, and a C
i am trying something like '[A][B][_][B][C]' but obviously it wouldn't work
if the number of B's changed.
thank you!
-Bahman...more >>
select all values that contain something in their group Posted by JR at 7/23/2006 9:47:07 AM I asked a similar question to this before from more of an update query
perspective, however this is more basic select question to get me
started in case someone knows.
Unique ID: Value1
1 123 E
2 123 A
3 123 A
4 2...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Selecting Last, First Names query Posted by Stephen K. Miyasato at 7/23/2006 9:46:08 AM I'm trying to parse LastName, FirstName Initials Such that I can check for
duplicate names.
I'm having problem in terms of deleting the 3rd part of the name if present.
Select Substring([Name],1,(CharIndex(',',[Name])-1) )as LName,
Substring([Name],charIndex(',',[Name])+1 ,Len([Name]))as ...more >>
SQL to update values based on a grouping Posted by JR at 7/23/2006 9:12:23 AM I have a bunch of records that have data set incorrectly for one of the
values. I need a quick way to fix them. here's the deal:
UniqueID ID: Value1 Value2 Value3
1 123 0 E 2
2 123 0 A 3
3 ...more >>
Sql Performance Posted by Aviad at 7/23/2006 4:28:01 AM II have here 2 example of automate generated sql queries that result the
same. The second one is much much faster than the first one. Can u please
explain me why?
(the [ST_CU_PR] is a view created :
CREATE VIEW DBO.ST_CU_PR
AS
SELECT DBO.TBLSTORES.FLDID AS [STORE ID],
DBO.TBLSTOR...more >>
How to Access a remote sqlserver Through a Proxy Server? Posted by mizi at 7/23/2006 3:51:31 AM Hi. I'm using web hosting services of a company. I try to connect to a
remote SQL Server from the hosting account. But they told me I must use a
"proxy aware" code to connect to the SQL server through their proxy server.
How can I do this? I searched the Internet and can only find a webproxy
...more >>
if row exist update else insert value Posted by Gazi at 7/23/2006 2:48:53 AM Hi,
I want to copy multiple tables from one database source (Progress 9.1D,
ODBC) to another database (SQL Server 2005). For this i want to use stored
procedure and a linked server. What i need to do is check if a row already
exists in the destination table, if so update the values, if not ins...more >>
if row exist update else insert value Posted by Gazi at 7/23/2006 2:47:21 AM Hi,
I want to copy multiple tables from one database source (Progress 9.1D,
ODBC) to another database (SQL Server 2005). For this i want to use stored
procedure and a linked server. What i need to do is check if a row already
exists in the destination table, if so update the values, if not ...more >>
SQL Help Posted by Andrew at 7/23/2006 12:00:00 AM Hi,
Following on from my previous post about searching,
If I want to search my products table for a single word I'll use:
WHERE fieldname LIKE '%paramater%'
But how do I deal with a potentially unlimited amount of search paramaters?
For example:
if the search criteria is: "param1...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |