SET NOCOUNT ON DECLARE @tbl TABLE (GroupId INT,TaskId INT,Created SMALLDATETIME) INSERT @tbl VALUES(1,2,'04/30/03 10:00') INSERT @tbl VALUES(1,4,'04/30/03 10:15') INSERT @tbl VALUES(2,9,'04/30/03 09:00') INSERT @tbl VALUES(2,6,'04/30/03 09:05') SELECT A.GroupId, A.TaskId FROM @tbl A INNER JOIN @tbl B ON A.GroupId = B.GroupId INNER JOIN @tbl C ON A.Created = C.Created GROUP BY A.GroupId, A.Created, A.TaskId HAVING A.Created = MIN(B.Created) […]
2003-05-07
Hi David, I posted a quick response to your previous solution where we could use Distict counts of respondents, recall if a respondent responds more than once to a combination we count them only once. Your previous solution with the small amendment works quite well but does not solve the problem where we have 50 […]
2003-05-07
1 reads
We tried replication under SQL 6.5, and, as I recall, replication would not push DDL (i.e., table and stored procedure) changes from the source server to the destination server. I’m thinking that the same behavior exists in SQL 7.0 and 2000. (Someone please correct me if I’m wrong.) We tested log shipping in SQL 2000, […]
2003-05-07
No issues with transactions issued once all subscriptions are dropped. My point is still that you're doing a LOT more work than you need to just because a pub got out of sync. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-06
1 reads
Should'nt a.STORE_ID be part of the join between the tables
2003-05-05
Each DTS package has a version stored when its run. My guess would be no...you cannot run the same package versions on a single instance sql 2000.
2003-05-05
Our server was running under local system account. now we changed to domain account. now debugger is working fine. thanks ravi
2003-05-05
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-05
Thanks allen, but the directory is a share that I created. The directory on the server is e:\program files\Microsoft SQL Server\MSSQL I shared it as MSSQL so it is now \\machinename\mssql Notice the backup for the initialization actually worked..the file was created on the standby server from the production server so that is why I […]
2003-05-04
2 reads
HI I NEED YOUR HELP what i wont to do is OREDR BY With "@ORDERBY" ------------------------------------ DECLARE @search VARchar(3000) DECLARE @scop VARchar(20) DECLARE @orderby VARchar(20) DECLARE @sql nvarchar(1000) set @scop='\' set @orderby='Rank' set @search='DOC ' set @sql = 'SELECT TOP 50 * FROM OPENQUERY(NTindex, ''SELECT DocTitle,create,path,filename, rank,VPath,Contents,characterization FROM SCOPE (''''"'+@scop+'"'''') WHERE FREETEXT(Contents, '''''+@search+''''')'') WHERE (FILENAME […]
2003-05-03
1 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers