RE: What are DR2 files?
You may be getting this error message when the file you transfer contains a DRI in this case a non clustered index. Regards
2004-05-07
DAX
Master server as Target server?
Hi there,I'm using a master server to manage similar jobs on several SQL Servers, and this works fine. There is a nagging peculiarity which I find strange: these jobs for the targetserver should run on the masterserver as well. It seems I cannot designate the master as a target. Is this correct, or do I […]
2004-04-15
1 reads
RE: functions in select statements
If I was to do a select statement from the [Warrants] table below off of intMasterAcctID I would get two rows returned for intMasterAcctID=1 The function basically returns the intMasterAcctID, Warrants and Warrant PercentsSo:Select * from WarrantCodesByAcct(2) returns2,'PP',100select * from WarrantCodesByAcct(1) (with 2 qualifying records)1,'PP,FA','50,50'Basic table layout w/datawarrantsintID,intMasterAcctID,intWarrantCodeID,intWarrantPerc1 1,1,1,50 2,2,1,100 3,3,1,100 4,1,2,50WarrantCodes intID,vchrCode,vchrDescription 1,'PP','Personal Property' […]
2004-04-12
RE: SELECT INTO with stored procedure result set?
Thanks Jack,As it turns out I'll be moving to SQL 2000 very soon now, so this will become useful almost immediately. I'm running tests this week.
2004-03-30
RE: Question of the Day for 29 Mar 2004
That would probably be to difficult to administrate. I am thinking more in conceptual terms. By thinking of it in these terms questions could be tailored (made easier or harder). In the end all you really have is the consolation of the percentiles and maybe a new fact to add to your repertoire
2004-03-29
RE: Sum Aggregate
SELECT YearNumber, MonthNumber, SUM(Occurances) AS CountOfData FROM (select YEAR(DateField) AS YearNumber, MONTH(DateField) AS MonthNumber, Count(datacount) As Occurances FROM datatable GROUP BY SQLDate)Dates GROUP BY YearNumber, MonthNumber Order By YearNumber, MonthNumber This should give you what you are looking for.
2004-03-11
T-SQL Hierarchy Recursive Function
I have a table that lists the employee and their supervisorFor exampleemployee_id supervisor_id1234 56785678 78927892 9999 I need to load in a new SUPERVISORS table (fields supervisor_id, supervisee_id), all the supervisors and who they supervise, and who they supervise, supervise, etc..... So, 7892 supervises 1234 and 5678and 9999 supervises 7892,1234, and 5678.Is there a simple way […]
2004-02-26
2 reads
RE: Automating DTS (sql 2k)
Ray,They will provide us will all needed text files (may include CSV, fixed field, XML). The problem is not getting the files but handling all the different formats once we get them.Bill
2004-02-23
RE: Review of Lumigent Log Explorer v3
Having used Log Explorer for over 3 years, I've found some additional uses other than restoring data:Exporting the transaction log records to a SQL table and running queries to determine who and when data was modifiedThe Load Analysis feature particularly the information on page splits is interesting. I've been unable to find any other method […]
2004-02-13
RE: OLE DB provider EDAOLEDB.1
Sorry, I gueas I shouldn't hit enter. -- anyway the query is something like select column1,column2 from openquery(EDACONN,'select column1,column2 from table') We can run it, it returns 78000 records. We can run it about 3 - 4 times then we'll get an error ... OLE DB provider 'EDAOLEDB.1' reported an error. The provider ran out […]
2004-02-04
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers