Recent content by JaybeeinTekTips

Ok, how would I perform the lookup? Does it matter if it's cross-tab?

Hi all, I have a spreadsheet with two sheets, where the first sheet has a column (Product Profit) that relies on a cell in sheet 1-1 for a value as follows: =((I2-G2*'Sheet 1-1 - Table 1'!C2)) On Sheet 1-1, Column B and C are Product and Cost respectively, sample data: Product Cost Aciclov...

S'ok, I've got the resolution now.

Hi all, I've got a Sproc I'd like to alter so that it will accept input parameters, at the moment it ignores the dates I pass in (exec uspfraudreport '04-mar-2008', '05-mar-2008') and returns rows. Here's the code I've got so far, I've left out the irrelevant stuff at the end; USE...

Hi all, I've got a script that I want to alter, so it retrieves servername and edition faithfully from each SQL Server. This retrieves servernames, but only gives me the edition of the local server. Anyone know how to adjust? Thanks, Jaybee. -- Show sql servers in a domain -- --...

Hi all, I created a DB (called Iris) and need to give an NT local group ownership of the DB. Now, at the moment my own personal-named login is listed the login for DBO in the Users list, and all my permissions boxes are ticked. So, I executed a sp_changedbowner 'OurDomain\OurNTLocalGroup'...

Hi all, we've got a Replication problem, and I'm very new to replication. Here's the message: MSG TEXT: EventID: 0x4000429C (17052) - Error: 14152, Severity: 10, State: 1 Replication-Replication Distribution Subsystem: agent OURSERVER- On the advice of another board I've checked for blocking...

Hi all, How do I find the physical name of a server registered in EM? Thanks, Jaybee

I'll use blue!! SET NOCOUNT ON ; Select DISTINCT (tblAccounts.accountID) , tblAccounts.accountFirstName , tblAccounts.accountLastName, tblServicesTree.serviceName, tblcommunicationsSent.SentTo FROM dbo.fn_getValidSubscriptions() as vs JOIN tblAccounts on tblAccounts.accountID = vs.accountID...

Hi all, I've got some code here that runs for about a minute without the red entries, but for 100 minutes (and more) with them - any ideas, people? Thanks, Jaybee. SET NOCOUNT ON ; Select DISTINCT (tblAccounts.accountID) , tblAccounts.accountFirstName , tblAccounts.accountLastName...

How do I expand an index in MS word? I have an index that needs to be expanded to accomodate a lot of extra content, it'll triple the size of the document. After I paste the content, how do I: 1) Create new index entries; 2) Link each paragraph with the corresponding entry? 3) Ensure each...

I thought the Group By should be placed at the end and I was right!! Thanks for your help! Jaybee

The most important thing is that I get back a list of Servicenames for AccountID's. Each AccountID has an average of 27 ServiceNames. This will be a lot of redundant data, but it's for reporting purposes. I'm going to dump it out to an .xls and relay it as requested, what happens to it after...

Hi all, I need a final tweak I need for this code, what I need now is for firstnames, surnames, servicenames and some other generic data to be returned (again, this data is ALL contained within the function and tables - I checked!) and grouped by distinct accountID. I'm sure it'll involve a...

Background - this is dependency service for DTC (Distributed Transaction Co-ordinator) in SQL Server. When I attempt to start, Service Manager reports, "Error 1075: the dependency service does not exist or has been marked for deletion". I checked RPC, the dependency service, it's running...