| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Stored Procedure - Doesn't stop Posted by SAC at 6/21/2007 1:42:05 PM I'm trying to update a field in a table the sp seems to go on forever until
I manuall stop it. Maybe I have the BEGIN/END in the wrong place.
Here's the sp:
CREATE PROCEDURE [sp_UpdateCargoDeliveryDate]
AS
DECLARE @TWDLIN_Cursor CURSOR
DECLARE @LSHQTY [float]
DECLARE @LTWPO [float...more >>
Make Table Posted by pjscott at 6/21/2007 5:04:01 AM I'm using sql 2000 and Access 2003.
In Access there is a make table wizard that will create a table from a query.
How would I go about doing making a table from a view in sql 2000?...more >>
Evaluation version Posted by beersurvivor at 6/20/2007 11:44:00 PM Hi, guys,
well i have downloaded and installed SQL Server 2005 Enterprise edition
evaluation from Microsoft.
due to time constraints i am not in a position to buy the full version.
can i activate or register the evaluation version to a full version.
...more >>
SQL 2005 local server instance gone after removing SQL 2000 Posted by Doug Forman at 6/20/2007 9:10:01 PM Recently we upgraded our Windows 2000 with SQL Server 2000 to Windows Server
SBE 2003 with SQL Server 2005 (sp2).
The upgrade was successful, and we have been using our shared application
which uses the SQL 2005 Server ever since.
Tonight I removed the old SQL Server 2000 using Add/Remove ...more >>
Replace function question. Posted by Jim Moberg at 6/20/2007 8:54:03 AM Hi,
We sometimes get data from customers where the phone numbers will have
plethora of invalid characters in them. They could have _,*,&,#, ect... I
know that the replace function can be used to search for one character and
replace it with whatever you need.
I was wondering if it's pos...more >>
Query Help Posted by Hulicat at 6/20/2007 2:30:02 AM Below is a select statement that will be a stored procedure at some
point.
I will only be passing @startdate and @enddate as user defined.
For the purpose of testing I set them to dates
Note:
I am trying to get the data for @totalatstart"total opened at start"
and @totalatend "total opened...more >>
Remote connection with SQLEXPRESS? Posted by Ralf Kaiser at 6/19/2007 12:00:00 AM Hello,
i want to connect to another SQLEXPRESS server that is located inside our
local network. I am using "SQL Server Management Studio Express".
I have activated TCP/IP protocol for both servers and the SQL browser
service is running on both computers. To login i am using Windows
authe...more >>
Query How To? Posted by WANNABE at 6/18/2007 12:00:00 AM I am trying to advance my query writing abilities and would like to ask if there
is anyone out there who will not write the query for me, but guide me through
writing this query. I can use aggregate functions such as COUNT() and AVG() in
simple queries, but in something like this I am getting...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Rows to Columns Posted by WANNABE at 6/16/2007 9:25:29 PM How can I convert the results of this query
SELECT num1, COUNT(num1) Total
FROM tbl
GROUP BY num1
Which displays like this
Adult 2
Minor 2
BUT I WANT IT TO DISPLAY LIKE
Adult Minor
2 2
Can this be done and how?? I've looked at the new PIVOT, and I am using 2005, ...more >>
Complicated Query HOW2 Question Posted by WANNABE at 6/16/2007 2:25:25 PM I would like to direct this to someone who helped me on a previous query, but I
am not sure if that violates some kind of etiquette, Anyway, I Hope you know who
you are, You were a big help, thanks again!!
I would REALLY appreciate any help. I hope that with just a little more help I
should ...more >>
Help with database design. Posted by rhaazy at 6/15/2007 6:50:23 PM I am working on a server/client application where the client scans a
computer for all available mac addresses and stores the information
in
a database, associating mac addresses to assets. I see problems
occuring in terms of NICs being removed, changes to different
machines
on the network, ne...more >>
simple query question,for those who are in the know Posted by WANNABE at 6/15/2007 6:48:26 PM I've created a query that pulls one field from each or 3 related tables, but I
need to limit the rows displayed to only the newest entry for each user. How do
I limit the display like that ???
...more >>
How to copy a file in a stored procedure Posted by SAC at 6/15/2007 3:17:42 PM I have used a dts package to export date to a spreadsheet. I would like to
write a stored procedure to copy that spreadsheet to a subfolder.
How do I do this?
File system Object?
Thanks.
...more >>
Save file to subfolder Posted by SAC at 6/15/2007 11:48:41 AM I'm trying to save a couple files to a subfolder. So far this saves them to
the root directory:
I'd like the subfolder to be named yyyymmdd. This attempts to add the date
on the end of the file name but I'd rather try to figure out how to name the
subfolder. and then put the files in it.
...more >>
Case sensitive or case insensitive Posted by Dave K. at 6/15/2007 11:13:02 AM We use SQL 2005 and I need to know how to determine if it is case sensitive
or case insensitive. Our programmer is out on vacation and I have an
application I need to install that requires this information. I have done
multiple searches on this site along with google andhave yet to find out ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |