Viewing 15 posts - 31 through 45 (of 155 total)
I can't believe that I see this question for the second time. I feel obligated to quote the response I wrote some time ago, in another group:
December 13, 2004 at 12:18 pm
I think that your command encounters a time-out error. You should try to increase the CommandTimeout parameter.
Razvan
December 13, 2004 at 12:11 pm
If you need the IP of the server, here is another way (if you don't mind using undocumented stored procedures):
CREATE TABLE #ErrLog (errorlog varchar(8000), ContinuationRow int)
INSERT INTO #ErrLog EXEC...
December 13, 2004 at 12:00 pm
Let me get this straight: we are talking about the age of the person, which is stored in the CallHistory table as it was on the date the call was...
December 9, 2004 at 10:22 am
The query would be more understandable if you use this syntax:
select Name, Address, Age, PhoneNumber, max(CallDate)
from CallHistory CH
WHERE CH.Name IN (SELECT HC.Name from HostileCallers HC)
group by Name, Address, Age, PhoneNumber
order by...
December 8, 2004 at 12:52 am
Joe, you wrote:
"[...] there is no such thing as a TIME datatype"
Indeed, there is no such datatype in Microsoft SQL Server 2000. But this datatype IS defined by the SQL-92 standard...
December 3, 2004 at 6:26 am
Ron,
Do you have any database with a "-" in it's name ? If yes, you should use from [?].dbo.sysfiles instead of from ?.dbo.sysfiles
Razvan
December 3, 2004 at 6:01 am
Ajay, you are very stubborn. Listen to Yoda, he gave you a good solution: the UDF that takes a CSV string and returns a table of integers.
The only solution...
December 3, 2004 at 5:48 am
The NORECOVERY option of the RESTORE statement is usefull if you want to restore additional transaction log backups, after the current restore. You must specify the RECOVERY option (which is...
November 27, 2004 at 9:13 am
It's much easier to have all the columns in the table, right from the start, by modifying the SELECT INTO statement, like this:
SELECT @NewCollectionId AS collection_id, subject_id, user_id, dateenrolled, collectionsubjecttitle_id,...
November 27, 2004 at 7:23 am
Don, you wrote in the article:
"It doesn't matter where the BEGIN TRAN and COMMIT statements reside between the two procedures. [...] So where you place your BEGIN...COMMIT is pretty much...
November 25, 2004 at 12:57 am
Read the following article:
http://msdn.microsoft.com/library/en-us/dnsqlmag02/html/groupingtimeintervals.asp
It solves a similar problem and you may find some interesting ideas there.
Razvan
November 19, 2004 at 11:26 pm
In SQL Server, some views are updatable. Here are some of the rules (quoted from Books Online, topic "CREATE VIEW", paragraph "Updatable views"):
If a view does not have INSTEAD...
November 18, 2004 at 9:21 am
Maybe the table was altered after the view was created. Weird things can happen if you change the columns of a table (after the view was created), especially on views...
November 18, 2004 at 9:10 am
It's a known problem:
http://support.microsoft.com/?kbid=287515
Indeed, aggregate concatenation doesn't work with order by an expression.
The first workarouds that I've tried do not work:
- subqueries
- views
I have found only two working workarounds:
-...
October 20, 2004 at 12:48 am
Viewing 15 posts - 31 through 45 (of 155 total)