|
|
|
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 Windows Process Hanging in WinApp Posted by Pratik Mehta at 5/20/2007 11:11:01 PM Hi All,
I am trying to run following command to execute SQLCmd command in a seperate
process in a windows application. This SQLCmd command is intended to execute
SQL batch statements against the sql server database.
Process process = new Process ( );
process.StartInfo.Arguments = "-S psi-...more >>
Query Posted by vanitha at 5/20/2007 10:45:00 PM Hi,
I have 3 tables Scheduled, parameters, parametervalues. help me to identify
duplicate scheduled instances. To be a duplicate all of the following must
be the same:
RID (ReportID)
Delivery Method (PDF or Excel)
Frequency
All parameter values must be identical
the delivery met...more >>
Dynamic Insert Statement error Posted by David Bell at 5/20/2007 8:04:31 PM Hi all,
Can't get the following procedure to work:
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO
USE VBForum
GO
ALTER PROCEDURE proc_VBForum_Insert_LoopUp
(
@Descriptor VarChar(50),
@TableName varchar(75)
)
AS
DECLARE @UID [uniqueidentifier]
DECLARE @cmd VarChar(400)
SET ...more >>
Best approach Posted by SpaceCadet at 5/20/2007 7:11:00 PM Hi there,
I am stuck on getting the following stored proc (listed at end of post) to
work... it is all fine up until the delete statements... but from that point
it does not work as I expect...
The stored proc is meant to build a list of items that can be deleted
(details stored in the ...more >>
Top 5 Grouped Posted by mal at 5/20/2007 6:39:01 PM Hi Guys, can someone help me with the following please.
I have 8 product types, and I would like help with the code, that will list
the Top 5 products by sales quantity, grouped by each product type.
Any suggestions will be most helpful, thankyou :-)
--
Mal Haddon...more >>
Moving 200 database from a disk to another Posted by TheBrain at 5/20/2007 5:20:00 PM Hi everybody,
I have a great problem.
I need to move more than 200 SQL 2000 database from the current drive (D:)
to the new and more capable drive (E:) that i've installed on my server.
So the procedure i think to use is this
a) detach all the database (using a stored procedure)
b) copy th...more >>
casting an integer as varchar Posted by jonefer at 5/20/2007 4:55:02 PM I have two loops - it seems as though my concatenation is setup exactly the
same for both loops - yet only the FIRST one works.
what did I do different in the second loop that doesn't allow the
concatenation?
--FIRST LOOP
set @count_inc = 1
--use the MaxCourses to determine how many colu...more >>
query? Posted by x taol at 5/20/2007 1:35:42 PM
<x Table>
dt product
2007-02-14 whi
2007-05-14 gal
2007-04-14 pan
2007-03-14 gal
<y Table>
dt2 product unit_price
2007-02-01 gal 8.5
2007-02-01 whi 5
2007-04-01 pan 6
2007-03-30 whi 9
2007-02-01 pan 7
2007-01-01 gal 7
i want to make below tab...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
COUNT Posted by Phil at 5/20/2007 1:00:02 PM Hi,
I am trying to do a number of counts my tabel looks something like
Column 1
N
M
S
M
In my first count I would say
N=1
M=2
S=1
Code is like : SELECT count(left(inspectioncode, 1)),
left(inspectioncode,1).........
But what I would also like to do is if neither M or S sho...more >>
OPENDATASOURCE does not Support XML in Distributed Queries Posted by Scott at 5/20/2007 12:34:00 PM All,
I am trying to copy record rows into a linked server via the following SQL
syntax where XMLCol is an xml column type (note this is running in SQL
Express SP2):
INSERT INTO OPENDATASOURCE('SQLNCLI','Data
Source=MACHINENAME\SQLEXPRESS;Integrated
Security=SSPI').[MyDatabase].dbo.My...more >>
problem with built-in string function in SQL Server 2005 Posted by NT at 5/20/2007 9:37:00 AM I tried to break the group name into 3 groups
ex: 70090A-041_4cycle-03-24
cell: 70090A-041 (* take all char, end before "_")
Test: 4cycle (* take all char start after "_", end before "-")
The statement below worked in Access but problem with built-in function in
SQL Server 2005. Any a...more >>
Is there an easy way to use sql server dates with oracle format ? Posted by Jim K Access Guy at 5/20/2007 7:55:00 AM I use a lot of dynamic openquery selects to an oracle database using linked
server in my stored procedures. The sql server 'convert' command is handy
for converting dates to various formats (i.e. mm dd yy, mm-dd-yy, etc - for
example
set @MyFormattedDate = convert(varchar(10),getdate(),101)
...more >>
Problem with uniqueidentifier! Posted by Jeff at 5/20/2007 7:22:51 AM Hey
This problem occur in Visual Studio 2005 and that Express Edition of Sql
Server 2005 which get installed when installing Visual Studio 2005.
I have stored procedure which doesn't return any rows. The select in this SP
have a column of datatype uniqueidentifier. When I remove this colum...more >>
Column description Posted by Mark Goldin at 5/20/2007 6:41:06 AM I am trying to find where column description is stored so I can query it.
Can someone help to locate that information?
Thanks
...more >>
updating a temp table with a value in an inner join Posted by jonefer at 5/20/2007 12:40:01 AM Lets suffice it to say that CC# has successfully been constructed and is now
populated with data
I would just like to update one of the columns:
(what's wrong with this statement?)
UPDATE CC#
SET CC#.[General Course 1 Name] = a.Course
WHERE EXISTS (SELECT Course FROM ciatracking.vwPr...more >>
AdoMd.Net 9.0 and AS2000 Posted by Elad at 5/20/2007 12:02:40 AM Hi,
I'm trying to connect to AS2000 using AdoMd.Net 9.0 and I get the following
error:
{"Retrieving the COM class factory for component with CLSID
{B9776FC2-70D8-4664-A0DF-998114524D67} failed due to the following error:
80040154."}
Trying to connect using AdoMd.Net 8.0 (same code, sa...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |