Viewing 15 posts - 4,681 through 4,695 (of 8,731 total)
If you're using natural quarters, you might be able to use something like this:
WITH TableA([date],[ID])
AS
(
SELECT '2012-09-21','1' UNION ALL
SELECT '2012-09-28','1' UNION ALL
...
July 17, 2015 at 11:45 am
The problem is that you're comparing the same column and same row expecting it to have different values.
What you need is a self join. Something like this:
select GLAccum.Endbal, GLAccum.Base, GLAccum.Division,...
July 17, 2015 at 9:55 am
You're welcome.
Next time, avoid posting lengthy procedures and post only the ones relative to the errors. If you double click on the error, it will locate it for you. You...
July 17, 2015 at 9:31 am
Considering the ACCTPERIOD has a value of 16456874
Which would be the correct result?
164412 (first four digits minus one with a two digit suffix of 12)
16440012 (first four digits...
July 17, 2015 at 9:19 am
And what's the problem of the current query other than not being SARGable?
Try to avoid functions on columns in the WHERE clause. The condition can be changed like this:
SELECT *...
July 17, 2015 at 9:08 am
Based on your sample data, what are your expected results?
July 17, 2015 at 8:30 am
These articles might help you:
Generating Test Data: Part 1 - Generating Random Integers and Floats[/url]
Generating Test Data: Part 2 - Generating Sequential and Random Dates[/url]
July 17, 2015 at 7:13 am
The reason for getting errors on queries like
select * from table WHERE ISNUMERIC(LTRIM(RTRIM(Capacity))) = 1 AND Capacity < 0
Is that SQL is a declarative language, so even if you write...
July 17, 2015 at 6:33 am
Basically, you need to change the columns in the group by in this update
update [tempdb..##Performance_SUM_Detail_Data_table] set Produced = (select sum(Producd)
from X_Produced_By_Period where
B2BNR = bu AND B2PLT = PLT AND B2BBE...
July 16, 2015 at 1:24 pm
You say Disaster Recovery but you only mention High Availability solutions.
What do you really need?
July 16, 2015 at 12:35 pm
dba-wannabe (7/16/2015)
Should I/we add a column to hold a hash of the SSN; and use the hash for comparisons?
This.
July 16, 2015 at 11:48 am
If you can see the leading zeros in the file using notepad or something similar, that might be an excel problem. Be sure to define that column as string when...
July 16, 2015 at 11:36 am
This is either a permissions problem because the service account doesn't have permissions to access the path or the path might not exist. Remember that local paths refer to the...
July 16, 2015 at 10:22 am
That's because you're returning 2 values to assign a single scalar value.
Here's a refactored version of your query to avoid an additional hit on the table.
select DISTINCT
...
July 16, 2015 at 10:13 am
That's because the code stopped and never dropped the temp table.
Drop it before running the code again. Even better would be to have something like this before creating the table:
IF...
July 16, 2015 at 9:53 am
Viewing 15 posts - 4,681 through 4,695 (of 8,731 total)