Viewing 15 posts - 1,711 through 1,725 (of 3,232 total)
It installs off of the same disk provided you select it as an option and you first have IIS installed on your machine.
June 11, 2008 at 3:37 pm
What makes you think that the SoundExe value is derived from the CompanyName? What does the SoundExe values represent?
June 11, 2008 at 3:36 pm
Uh, unless I don't quite understand your question, this is just a simple update statement.
DECLARE @Commission_Soundex TABLE (
[SoundID] [int] IDENTITY (1,...
June 11, 2008 at 3:21 pm
Yes, please do. I'd be interested in reading that if you find it.
Thanks Lynn!
June 11, 2008 at 3:10 pm
Why use a temp table and incur the overhead??
create table a (clientid int, Unitbalance numeric(21,0),Dates datetime)
set nocount on
insert into a values (123, 999, '20080101')
insert into a values (456, 888,...
June 11, 2008 at 3:08 pm
Why not have the process that runs every 5 seconds (ouch) run by a sysadmin user and then simply grant read access to the table to the users that need...
June 11, 2008 at 3:01 pm
These guys have you on the right track here. You definately don't need a cursor or loop to do this. If you need additional help with this, please...
June 11, 2008 at 2:50 pm
Unless someone comes up with a fancy workaround, you should not be able to do this. Once you've restored or attached a SQL Server 2000 DB to a SQL...
June 11, 2008 at 2:41 pm
How much of the total size of your DB do you expect to be removing? It is worth seconding Noel's post. You've stated that you have 2 GB...
June 11, 2008 at 2:34 pm
Also, your WHERE clause of PO.PODescription LIKE '%00000%' will normally produce a table scan. It's a bit hard to say for sure though as you have not posted an...
June 11, 2008 at 2:23 pm
So you're asking for help tuning a query containing joins and you post a sample query with only the SELECT clause? How in the world are we supposed to...
June 11, 2008 at 2:16 pm
Are there any 'ALTER TABLE' statements within the triggers?
June 11, 2008 at 1:50 pm
Here's another: http://www.eggheadcafe.com/forumarchives/SQLServerprogramming/Jan2006/post26057430.asp
June 11, 2008 at 12:59 pm
What is your trigger doing?
This may help http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=816590&SiteID=17&pageid=0
June 11, 2008 at 12:57 pm
Second that.
From your code, the main part is:
*****************
SELECT @PNo = min(PNo) FROM #PT
WHERE PDone...
June 11, 2008 at 11:04 am
Viewing 15 posts - 1,711 through 1,725 (of 3,232 total)