|
|
|
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 |
Updating several fields in a table with a select statement Posted by Chip at 11/29/2004 10:09:18 AM Hi,
Is there a way in T-SQL to update several fields of a table with fields from
another table using a select statement based on a key? I remember doing that
in Oracle. If so, can you please give me the syntax. Thanks....more >>
Can you select from a Derived table calling a stored proc? Posted by we7313 at 11/29/2004 9:23:02 AM I know the sql is incorrect on this but was wondering if something like this
was possible:
select * from
(
exec storedProc1 'value1'
) a
--
will...more >>
Max Number of Stored Procs in 1 Database (sql server 200) Posted by we7313 at 11/28/2004 4:19:03 PM Whats the maimum number of stored procedures you can have in one database?
Would I notice any performance degredation if I had over 2,000?
--
will...more >>
Optional Inner Join Posted by we7313 at 11/27/2004 1:03:02 PM I have a select proc that will take a bunch or criteria parameters. Based on
how many are not null I would like to decide how many inner joins to do.
for example:
select H1.Priceid as HotelPriceId,H2.Priceid as AirPriceId,
H1.VendorPackageId from
(
select HA.PriceId, HA.VendorPackageId fro...more >>
How to FTP via VPN to sites with real adresses on different IP's ? Posted by Jason Robertson at 11/25/2004 5:42:59 PM Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites u...more >>
"Length" in table design view Posted by cmaso at 11/23/2004 11:41:03 AM I haven't been able to find an answer to this simple question from any of the
online documentation. In table design view, each one of my columns has a
datatype and length. Specifically, I have a column of dataype "ntext" with a
length of 16, but I don't know what that "16" means. 16 Bytes? How...more >>
Odd pivot table type query Posted by Shawn at 11/22/2004 3:49:47 PM I've been unable to find a way to write the following
query.
Assuming this table:
Year Quarter
---- -------
1990 1
1990 2
1990 3
1990 4
1991 1
1991 2
1991 3
1991 4
...more >>
change date format Posted by Newbie at 11/20/2004 8:48:43 PM I have a table with a date field. I need to convert the date so that it
returns in a text format of DDMMYY - no separators.
How do I do this?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL-query, optimizing Posted by Ingar Eide at 11/8/2004 12:46:45 PM Hi,
I have some SQL-statements that are very slow, and I'm wondering if I can do
this in a more efficient way.
The problem is that I need to list out _detail information_, but the where
condition check _sum of the group_.
Here is a simple example of a query (from Northwind):
I would like...more >>
How: Persistant record order Posted by Gary K at 11/7/2004 8:17:02 PM Does anyone know a (relativly) easy way of keeping records in their created
order? (or a specific order, and maintaining that order through
additions/deletions/changes)
I'm interested in a general method (ie, works for everything), but I'll use
my specific example as explaination.
The ExamTe...more >>
DateDiff problem Posted by Strugglin' at 11/5/2004 6:27:03 AM I have a db with a table that records details about order transactions. The
main columns I am concerned about are the "Transacton_Type" column and the
"Date_Time" column. Each order has more than one transaction/rows in the
table (ie. Pending, Shipped, etc...), with each transaction having i...more >>
Help with a multiple table query Posted by Dave Lugo at 11/3/2004 8:00:03 PM Hi,
I need help in constructing a query against my Db I have. The DB I have has
122 Tables and 15 columns in each. I have information in a column in one
table that I need to query with data in a column on another table. In other
words, In Table ad, i have a column called ENTRY_ID that I wa...more >>
pb with "QUOTED_IDENTIFIER" Posted by philned at 11/2/2004 1:54:55 PM hello,
I've a problem with a trigger :
this trigger update a file with an index field but it's return an error
: UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
parameters
for information, this is my trigger :
CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |