|
|
|
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 best way to group by day? Posted by bmurtha at 7/31/2004 11:10:03 PM Hello,
I'm writing a bunch of reports that are grouped by day.
I've been selecting convert(char(10), sh.timeread, 112)
and grouping by that. I also tried MONTH(sh.timeread), DAY
(sh.timeread) and grouping accordingly. My question is
what is the most efficent way in T-SQL to group by day...more >>
stored procedure to capture identity values Posted by Hassan at 7/31/2004 10:30:11 PM I need to write a sproc to capture which table is on the verge of having run
out of identity values depending on the data type.. Theres 2 issues here.
For eg: say if table has a col of identity property and a datatype of
smallint. So if we start wuth identity(1,1) and the value reaches around
...more >>
Multiple Step OLE DB Error Posted by Prabhat at 7/31/2004 9:56:31 PM Hi All,
My Application uses ADO 2.5 to connect to SQL Server 2000 with SP 4.
When I Retrive a Large Amount of Data for Report using a Query then My
Application Gives thew below ERROR:
Error Class: EOleException
Error Message: Multiple-step OLE DB operation generated errors. Check each
OL...more >>
(Revised)Database Design question, Header with two detail.. pls help Posted by tristant at 7/31/2004 9:07:33 PM Hi All,
There is some additional info I forget on this same topic I just posted.
I have a database design question, pls give me some help..
I want to define tables for salesman's sales target commission . The
commission could be given per EITHER sales amount of : Group of Products OR
Group...more >>
Accessing database through views rather than SPs? Posted by Brett at 7/31/2004 8:29:01 PM I'm referencing an article I printed out but unfortunately don't have the URL to:
"Unless I absolutely have to, I try to avoid having my application call stored procedures directly. A relational database manager *should* be able to hide the stored procedures behind a view allowing a nice standar...more >>
Help need to Avoid Lengthy Cursor Posted by Prabhat at 7/31/2004 8:17:14 PM Hi All,
I have A Problem with this Cursor. It takes a LONG Time. I Want to Avoid
that. Please help me to Build a SQL Script Instead of this:
SET NOCOUNT ON
BEGIN TRANSACTION MAIN_TRANS
DECLARE @TIMESMAILED int,
@PHONEN VARCHAR(15),
@DATEPAID DATETIME,
@AMOUNT FLOAT,
@SOURCEID...more >>
updating a text field with multiple varchars Posted by Guy Brom at 7/31/2004 7:16:26 PM Hi there,
I have a text column that needs to be filled with multiple varchar columns
scattered around other tables. Is there anyway to make this works?
UPDATE tblFullText
SET textcol = (SELECT varcharcol + ' ' FROM tblStrings)
The ' ' is necessary to make the textcol fulltext-searchable.
...more >>
Suggestion for a datagrid ? Posted by Shahriar at 7/31/2004 3:09:53 PM Does anyone have a recommendation on a grid control for foxpro outside of
the Datagrid control that is shipped with VFP 8.
Many thanks
Shahriar
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can't materialize view Posted by G. Dean Blake at 7/31/2004 3:01:16 PM I'm trying to materialize a view (pasted at end). After reading the books
on line I ran the following script to make sure these recommended defaults
were set....
USE MASTER
GO
ALTER DATABASE MyDatabase
SET ANSI_PADDING ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET ARITHABORT ON
SET CONC...more >>
cryptoAPI Posted by Andy Atherton at 7/31/2004 1:27:11 PM When using SQL 2000 personal desktop (i.e MSDE) on win 98 Machine with our
VB6 application we sometimes get this error
[Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function
'CryptAcquireContext' failed.
Error 0x8009001d: Provider DLL failed to initialize correctly.
On Win2000/20...more >>
Connect from sql query via IP adress - is i possible? Posted by Just D. at 7/31/2004 12:23:11 PM Does anybody really know is it possible? We don't want to create a linked
database, but we need to make some steps on the remote database, gather some
data and then send this data to our main server via IP connection, setting
the connection every time when the remote server wants to transfer the ...more >>
query newest entries in categories Posted by bbla32 NO[at]SPAM op.pl at 7/31/2004 10:39:01 AM I have a table named Documents with columns like: ID, CategoryOneID,
CategoryTwoID, IssueNr, IssueDate, etc. Each document is assigned to
two categories: CategoryOne and CategoryTwo, to which it is linked by
a relationship. A document for a certain pair of CategoryOne and
CategoryTwo may have se...more >>
String List to Array(Table) Posted by Graeme at 7/31/2004 10:14:54 AM Hello,
Hope you are all well i have a quick question for you.
I have a stored procedure i'd like to supply a list of numbers along with
and identifing character code i have read an article by Erland Sommarskog
(http://www.sommarskog.se/arrays-in-sql.html) detailing how to pass a
character l...more >>
timestamp Posted by Alexander Jagl at 7/31/2004 10:01:55 AM Hi!
I'm using SQL Server 2000 with an Access XP ADP.
When a user tries to store his changes sometimes he gets the message
'Another user has changed this record'. But the record was not changed
on another machine.
Now I found out that this problem can occur on SQL Server due to
rounding-di...more >>
solution to cycles or multiple cascade paths Posted by Kris at 7/31/2004 9:05:20 AM hello
please help because I can not find solution myself
I have a few tables and I defined on some foreign keys with ONDELETE CASCADE
problem is that I'm getting an error that "it may cause cycles or multiple
cascade paths"
I understand what it means, but that's what it is, there are a few ta...more >>
Convert VARCHAR to UNIQUEIDENTIFIER? Posted by Jon Pope at 7/31/2004 12:53:10 AM I've declared a sproc as follows:
CREATE PROCEDURE usp_CreateFolder
@FolderGuid UNIQUEIDENTIFIER,
@FolderName NVARCHAR(50),
@FolderDescription NVARCHAR(100) = NULL,
@ParentGuid UNIQUEIDENTIFIER = NULL,
@ParentId INT = NULL,
@NodeType TINYINT
I'm attempting to call this sproc as f...more >>
Partial Back UP Posted by malik at 7/31/2004 12:43:01 AM I have about 5GB back up on Tape.
after restoring about 92% there is as error. there are 5 databases on Back Up Tape.
how to retrieve Partial back, so that i can get First 4 databases, and leave the last database on which error occurs.
Any help is greatly appreciated.
thanx...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |