|
|
|
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 August 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 Inserting Records from Table type to Temp table Posted by Uma at 1/21/2006 8:37:02 PM Hi,
I want to insert records from table type to temp table without using cursors
in SQL Server 2000 stored procedure.
Regards,
Shanmugam
...more >>
Help with a complex Join Posted by daben at 1/21/2006 6:29:32 PM All
I could use some help with a complex join. I have 3 SIMPLIFIED
FICTIONAL tables (add table scripts and data on bottom of message):
In words I want the following:
a resultset of the avg(x), count(flag), sum(flag) for each and every
(outer join) Station_Number where cast_id<>'full' and...more >>
Changing the database from MSAccess to MSSQLServer. Posted by Jack at 1/21/2006 5:46:01 PM Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack...more >>
continuous dates Posted by NJ at 1/21/2006 3:29:06 PM Hi Guys,
I have a sql query that returns a count of a certain column say the
number of bugs per week on a week by week basis. there are some weeks
which have no bugs and these weeks are not returned. How can I write a
sql query that has all the weeks whether there were bugs or not and
return ...more >>
Problem with too many queries. Posted by Vani Donthula at 1/21/2006 3:28:14 PM Hi
I have 3 tables and I have to do search feature with 12 drop downs i.e 12
Parameters.
I have to select 1or2 fields from each tables.
There are almost more than 1000 queries,when I placed these in codebehind of
dot net program it was giving me a CLR ERROR,
Now when I am doing these q...more >>
VIEW will not UPDATE with INSTEAD OF TRIGGER Posted by Dave at 1/21/2006 2:31:03 PM I created a view on a table and added an INSTEAD OF TRIGGER to the view.
The idea was to have all access (including data modification) go through
the view rather than the table.
I tested this concept (or I thought I tested it) and everything seemed to
work fine.
However, I recently dis...more >>
Update Help Posted by Sean John at 1/21/2006 11:44:36 AM
How can I update data on this column called address1. The path is
'c:\apps\MailBox\Attach\El Poder'
and I want it changed to
'c:\apps\Sever1\MailBox\Attach\El Poder'
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Whare are temp table names padded with underscores? Posted by Bill at 1/21/2006 11:08:56 AM Using SQL Server 2000, when I look at the name column in
tempdb..sysobjects the names of the temporary tables I have created are
always padded to the full length of the field with underscores. Is this
normal? Is this always the case on every SQL Server installation?
I am trying to test for the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can CONTAINSTABLE be made to match unconditionally? Posted by Greg Smalter at 1/21/2006 10:50:02 AM Say that users searching a Books database are able to search by Author,
Title, and Publisher using three separate text boxes. They can choose to
leave any or all text boxes empty if they do not care to filter by that
particular item.
Say I have a query that looks similar to this:
b.* FR...more >>
Confusing CONTAINS behavior Posted by Greg Smalter at 1/21/2006 10:41:02 AM I'm experimenting with the CONTAINS operation and I've come across some
confusing or inconsistent results. The following results are exactly the
same if the search terms are enclosed in double quotes so that they are
treated as a phrase.
I'm searching a Books table for books whose Author c...more >>
Making a term found in a string the subject Posted by philipbennett25 at 1/21/2006 7:52:25 AM Hi,
I am trying to make a term from a string into the subject and then be
able to count the occurences of this.
using:
Where (Fail_Desc like '%C[1-999]%' or Fail_Desc like '%U[1-99]%')
Which would output:
Fail_Desc
Replace Capacitor C123
Replace Capacitor C145
Replace Capacitor C1...more >>
String Manilpulation Posted by SouRa at 1/21/2006 12:33:02 AM Hi,
I want to display the name in Title case (like this - Soura Raja)
Please advise me.
rgds,
Soura...more >>
Time format hh:mm:ss pm Posted by SouRa at 1/21/2006 12:31:02 AM Hi,
I want time 'hh:mm:ss AM/PM' like this format.
Can u tell what are the ways to except substring using.
rgds,
Soura...more >>
Need the Guru HELP. Ðåáÿòà, ïîìîãèòå! Posted by Kachmaryk Yuriy at 1/21/2006 12:03:48 AM I have 3 tables:
Teble #1 - CUSTOMER -----------------------------------------------
|---CustomerID---|---CustomerCODE---|---CustomerNAME---|
|----------------------|---------------------------|------------------------
----|
| 1 | 01020304 | Custom...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |