Viewing 15 posts - 5,866 through 5,880 (of 13,877 total)
I would assume that it is because there is more than one match in tblDataActions for each Application number, and that is causing your result set after joining to contain...
March 3, 2017 at 8:13 am
Looks like it may be better to move that data to a staging table first (in its native format, as per the input file) and then use T-SQL to manipulate...
March 3, 2017 at 6:34 am
March 2, 2017 at 12:06 pm
Brain (and calculating)
and
Brute Force.
Phil Parkin can you tel how you came to...
March 2, 2017 at 11:48 am
One final attempt and I'll stop: how about 8,877,691?
March 2, 2017 at 11:36 am
Is the total number of rows 8,877,690, by any chance?
March 2, 2017 at 10:50 am
But there is no limitation for the length.
So:
3 is correct and belongs...
March 2, 2017 at 9:11 am
Try this
SELECT * INTO [DBO].[T_NEWTABLE]
FROM [WorkLSC].[dbo].[vw_OLDTABLE)
March 2, 2017 at 8:40 am
March 2, 2017 at 8:04 am
Is there an ORDER BY along with the TOP 1000?
March 2, 2017 at 8:01 am
March 2, 2017 at 7:57 am
I think we need a few more parameters ...
As the set of integers is unbounded, the answer is an infinite number.
But, if you are saying, how...
March 2, 2017 at 7:53 am
March 2, 2017 at 6:06 am
Apart from a few commas here and there, your two rows of results look the same. Try to imagine yourself looking at your post for the first time – it's...
March 1, 2017 at 1:26 pm
Try this and see what happens. Hopefully my edits make some sense:
public void Main()
{
String FilePath = Dts.Variables["User::FolderPath"].Value.ToString() + Dts.Variables["User::FileName"].Value.ToString();
Dts.Variables["User::FileExistsFlag"].Value = 0;
if...
March 1, 2017 at 12:39 pm
Viewing 15 posts - 5,866 through 5,880 (of 13,877 total)