Viewing 15 posts - 5,821 through 5,835 (of 13,874 total)
March 13, 2017 at 12:28 pm
Hi,
We have a requirement to import comma separated file into SQL SERVER, new file is...
March 13, 2017 at 7:17 am
I will ask them to update the column...
March 12, 2017 at 10:17 am
You are selecting all rows in the table, so there is nothing to 'seek' and a scan will always happen.
March 11, 2017 at 9:23 pm
Two days back we migrated one database from one server location to another server...
March 10, 2017 at 1:34 pm
March 10, 2017 at 12:11 pm
March 10, 2017 at 9:04 am
You are not looking at the correct window. The values in the Variables window do not change.
There is another window, called locals or local variables (I'm not in...
March 10, 2017 at 7:08 am
There is always only one record in the ReportingPeriod table. I removed the Parameter Mappings and...
March 10, 2017 at 6:48 am
If you don't tell us what you are expecting, how do you expect us to help?
March 10, 2017 at 6:31 am
So your SQL Statement now says this?
SELECT Top (1) CurrentReportMonth, CurrentReportYear from CVUReportingPeriod
? I added in the Top (1) as a safety measure. Any more than...
March 10, 2017 at 6:28 am
I tend to do this differently from John. Let's say I have a select statement that returns two results in one row.
Create the variables.
Create the ExecSQL task.
Important points:
Set...
March 10, 2017 at 5:53 am
It appears the var_period and var_fy variables are never set in the first Execute SQL...
March 9, 2017 at 6:02 pm
the logic is...
March 9, 2017 at 5:58 pm
I'm struggling with getting this to work
1. Created two variables named var_fy and...
March 9, 2017 at 1:39 pm
Viewing 15 posts - 5,821 through 5,835 (of 13,874 total)