Viewing 15 posts - 1 through 15 (of 7,428 total)
July 25, 2017 at 9:36 am
Change this:
AND A.[ACCT] NOT IN
(
SELECT
[ACCT]
FROM
[dbo].[TABLEB]
WHERE
[FSCD]...
July 25, 2017 at 9:34 am
Unfortunately don't have a DBA available right now as ours just retired and they have...
July 25, 2017 at 8:26 am
..the query which takes about 2 seconds to run normally clocks until the timeout...
July 25, 2017 at 6:44 am
July 24, 2017 at 3:11 pm
Not a clue. We can't see what you see. Could you solve this...
July 24, 2017 at 3:07 pm
Without more information, hard to say. Since it looks like you can't provide much...
July 24, 2017 at 2:20 pm
Luis Cazares (7/16/2015)
July 16, 2015 at 9:09 am
Luis Cazares (7/15/2015)
Chris Wooding (7/14/2015)
Antares686 (7/13/2015)
Kutang Pan (7/10/2015)
SELECT
SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN...
July 16, 2015 at 7:38 am
Kutang Pan (7/10/2015)
SELECT
SUM(CASE WHEN Type = 4 AND STATUS IN (1, 2, 3) THEN Value ELSE 0 END)
,SUM(CASE WHEN...
July 13, 2015 at 8:54 am
As stated we do need more information on your goal. However, typically the only reason I have seen to worry about making numeric data in mixed varchar sets int was...
July 13, 2015 at 8:10 am
My understanding is that you are correct in that the hop doesn't know the credentials to use for the connection thus Anonymous. SPN is one method. There are other methods...
May 14, 2015 at 2:31 pm
Maturity is a subjective concept. It has gone more than 3 versions then by standards and the fact it is often adopted shows it is mature. The question always has...
September 26, 2014 at 11:49 am
Sean Lange (10/15/2013)
Antares686 (10/15/2013)
Charles Kincaid (10/15/2013)
What I would actually like to see is COUNT() to mean to count the number of rows.
I would like to only have to type COUNT()...
October 15, 2013 at 5:37 pm
Viewing 15 posts - 1 through 15 (of 7,428 total)