Recent content by AccountCR

We have an existing SQL Server login that has specific permissions. We would like to keep this login and have a new windows auth login (FRED) have the same permissions as the SQL login (legacy) without having to recreate the windows auth login with all the permissions of the SQL Server login...

10 seconds on our SQL 2005 machine and 49 secs on our SQL 2000 machine. Huge improvement.

Thanks gmmastros. That did it. I really appreciate all your help.

OK. Here is what I tried: Select a.State, a.SalesPerson, Sum(a.Cost) as TotalSales from dbo.JBMTest a inner join dbo.JBMTest b on a.SalesPerson = b.SalesPerson and Sum(a.Cost) <= Sum(b.Cost) group by a.SalesPerson, a.State having count(a.State) <= 5 order by a.state, Sum(a.cost) desc This...

I did look at it. Maybe I am just a little dense but I couldn't see how to incorporate his query to return a result set of the following for the table that we have. Tom 345.45 AL Joe 325.25 AL Moe 225.25 AL Jim 125.25 AL Sue 110.54 AL Guy...

eerlee, Thanks for your query. This works but it takes a long time to run, actually around 24 min on a hoss machine. I am running SQL Server 2000. Is there a faster query that can be run?

memdiscount, The query you provided gives me the sales reps with the highest sales item entered but doesn't give me the top 5 sales reps PER STATE. I should have been a little clearer about the data entered. Each item in the table represents an invoice for a rep for a state on a particular...

I have a database that has 5M rows of data in it. The table is setup as such: Invoice Table Date Salesperson State Cost We are trying to get a query that shows the 5 sales people with the most sales $ PER STATE. Thanks for the help.

Regarding post thread851-1006208, was TAPIT able to resolve the issue with GlobalCallId or was there more to it than just the GlobalCallId?

I have a report created in Crystal 8.0 that has hyperlinks set to a particular field in the database. If this field exceeds 86 characters then other fields start disappearing from the report. The formula I am using for the hyperlink is a follows: if ({TGD0.FK_L_0_0_2}='') or...

We have an application that uses PESetFieldMapping to remap fields that are no longer in the data to a blank field. We have been successful in using this up to a point. On one report, it always gives us an application error when the report starts to read records. Has anyone else ever...

Already tried that one. Good suggestion though. I am afraid that since we don't have NETBIOS installed that we may be out of luck. This needs to be done through a script so loading the DHCP console won't help for this one. Any other suggestions?

Concerning the DHCP database: Is there a command line that can be ran to return the machine name from the DHCP database?

On a Novell network, that doesn't have DNS, WINS or NDS, how would you go about getting the machine name of a remote computer given that you have the IP Address? (NBTStat doesn't seem to work.) Any help would be greatly appreciated. Thanks.

On a Novell network, that doesn't have DNS, WINS or NDS, how would you go about getting the machine name of a remote computer given that you have the IP Address? (NBTStat doesn't seem to work.) Any help would be greatly appreciated. Thanks.