Viewing 15 posts - 5,041 through 5,055 (of 9,643 total)
I'd start by reading this entry in BOL.
Then I'd read this article on the FormatNumber Function which provides more options. The article is ofr VB, but all...
May 21, 2009 at 9:29 am
As I said earlier, if you have McAfee Enterprise you need you McAfee administrator to make the changes or else they will be overwritten by policy.
You can change it on...
May 21, 2009 at 9:15 am
GilaMonster (5/21/2009)
Oh yay. 🙁Another email accusing me of personal attacks and damaging someone's public image by 'misleading' people about his statements.
Sometimes I wonder why I bother.....
That's always fun. I...
May 21, 2009 at 9:11 am
Alvin Ramard (5/21/2009)
Jan Van der Eecken (5/21/2009)
Help, he is back!Jan, just walk away. Walk away. NO, stop. Walk away. JAN! Stop!
:w00t:
Just like Monty Python and the...
May 21, 2009 at 7:25 am
You could use a CASE statement:
SELECT
CASE
WHEN ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) 2 AND
ROW_NUMBER() OVER (ORDER BY P.DAYSTOMANUFACTURE) < 5 THEN 100
ELSE 75
END AS ROW,
P.PRODUCTID
FROM
PRODUCTION.PRODUCT P
I'd...
May 20, 2009 at 3:41 pm
In my opinion you do not need the 3rd party backups as long as your SQL Backups are getting off the server and are originally on different drives than the...
May 20, 2009 at 3:32 pm
Does the reporting services service account have rights to the location?
May 20, 2009 at 3:29 pm
You would need to check the parameters for null values in the procedure and adjust your where clause accordingly. You can do this with IF statements and write...
May 20, 2009 at 3:27 pm
What's the structure of dbo.ac_Orders? What does ac_Orders_ac_Shipments_FK1 point to? It doesn't look like this particular error is in your trigger. It looks like it is in...
May 20, 2009 at 3:11 pm
Roy Ernest (5/20/2009)
Ask around and you will find that I am THE SANE one here.... 😛Loosing sanity can come any minute.... Got two kids... 😛
The insane person is always the...
May 20, 2009 at 2:45 pm
Odds are you have a value that is not an integer or is out of the range of integer values.
May 20, 2009 at 2:41 pm
Bruce W Cassidy (5/20/2009)
jcrawf02 (5/20/2009)
Fire the 1st guy and find max(salary) . . . 😛[font="Verdana"]Pay everyone the same. :-P[/font]
Or like one of my former employers decided, don't pay anyone.
May 20, 2009 at 2:40 pm
Lynn Pettis (5/20/2009)
Lynn Pettis (5/20/2009)
Would someone who knows SSRS please go help this person?Thanks Luke!
I have to admit being disappointed you didn't say something like:
"Use the force well you did,...
May 20, 2009 at 12:04 pm
Could be an error with the data type, a primary key or unique constraint, or a foreign key. Can you provide data types and values?
You may...
May 20, 2009 at 11:59 am
Are there any parameters following it that are filtered by it?
May 20, 2009 at 10:49 am
Viewing 15 posts - 5,041 through 5,055 (of 9,643 total)