Viewing 15 posts - 3,586 through 3,600 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2017 at 6:23 am
Yes, you can. No need to use Batch files/Shell/.Net, you can use a Dataflow.
In very simple terms: Use the Flat File Connection to connect to your text file,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2017 at 6:13 am
You say auditing but what is it you're trying to achieve? Are you trying to check it's in a valid format, for example? This might be more easily achieved by...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2017 at 4:52 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2017 at 4:50 am
Spam is bad for you health. Containing 49% of your recommended Saturated fat!
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 5, 2017 at 3:40 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 8:29 am
That's in your Desired result, not your actual data. For example, is the below correct?create table DataTable
([Site] varchar(5),
[C_Date] date,
Series int,
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 8:25 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 8:16 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 8:02 am
Think we need some more logic here. Perhaps you could explain how you get from your sample data to your desired output. What is 'ReCalc', for example, and how it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 7:23 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 5:02 am
Based on the very limited data we have. One idea:CREATE TABLE #Sample
(terminal int,
[Date] date,
[time] time,
Amount decimal(8,2),
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 4:49 am
Couple of ways you could do this. Firstly, you could use APPLY and use a SELECT statement, and do something like this:DECLARE @Date date = '20170106';
SELECT...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 4, 2017 at 3:58 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 10:17 am
Then your data is completely unordered. You can't guarantee it, and you don't have a way of replicating it. As I said, data in SQL tables is unordered, and the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 9:38 am
Viewing 15 posts - 3,586 through 3,600 (of 5,109 total)