Viewing 15 posts - 7,411 through 7,425 (of 7,428 total)
Also look at the CRM packages requirements and if they are higher than the suggestions here, go with those. Sometimes they have stuff you don't expect going on in the...
February 5, 2002 at 5:09 am
OK, first can you give an idea of what the apps do. This will help me understand better what may help you. The reason I ask is the programmer before...
February 5, 2002 at 4:55 am
First I would suggest reevaluating the procedure itself as that sounds entirely too large and cumbersome to troubleshoot in it's current state (which I understand from your statement this may...
February 5, 2002 at 4:48 am
If you are trying to add in when the remsae, sub_remsae and vremsae are the same for a total then this will work for you. Hope this helps.
SELECT SUM([Total#]) AS...
February 5, 2002 at 4:25 am
I have done this in the past and has worked for me.
WHERE
(CASE WHEN conditiontomeet=met THEN ControlNum ELSE 0 END) = (CASE WHEN conditiontomeet=met THEN '555' ELSE 0 END) AND...
February 4, 2002 at 3:58 pm
1. Char(7)
2. tinyint Because it is a smaller storage size and joining on int and such is easier for SQL to do that character data.
3. smallint Same as 2
Basically I...
February 4, 2002 at 3:35 pm
Are you sure the error is being thrown exactly where the MsgBox is coming up. If you are using On Error Resume Next it could be occurring lines before....
February 4, 2002 at 3:24 pm
That is correct as I said. Columns of char datatype will automatically add to the end of the data the number of space to completely fill the lenght, thus enter...
February 4, 2002 at 3:11 pm
Actually, SQL does know the difference between 1 and 2 spaces in a varchar, except they must occurr together before a non-space character (' A')or between 2 non-space characters...
February 4, 2002 at 3:03 pm
No, it will not effect performance. Qualifing a name tells SQL to override and accept the entered value.
February 4, 2002 at 2:50 pm
Also keep in mind when you need to know about the state of a constraint you can run the following:
SELECT OBJECTPROPERTY(OBJECT_ID('urTriggerHere'),'ExecIsTriggerDisabled')
1 = TRUE (Is disabled)
2 = FALSE (Is not disabled)
...
February 4, 2002 at 4:41 am
In a nutshell straight from SQL Books Online:
Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped using DROP TABLE:
A local temporary table created in...
February 4, 2002 at 4:21 am
Microsoft uses INT as the cast of a number that has no special characters and for some reason they decide if it starts int then the results of math should...
February 1, 2002 at 5:48 am
Also keep in mind the way Microsoft uses query execution plans. They remain in memory until that have not been used recently and enough other changes have occurred (which it...
February 1, 2002 at 5:41 am
If you are concerned for when it is displayed then look at CONVERT in SQL Books Online and you will find some helpfull items that will help you return a...
February 1, 2002 at 5:22 am
Viewing 15 posts - 7,411 through 7,425 (of 7,428 total)