Viewing 15 posts - 4,936 through 4,950 (of 13,877 total)
November 9, 2017 at 6:10 am
Thom's question was based on the fact that data in tables in SQL Server does not have any implicit ordering – the ordering of data in the file is not...
November 8, 2017 at 1:17 pm
November 8, 2017 at 7:24 am
November 7, 2017 at 6:35 am
November 6, 2017 at 12:14 pm
November 6, 2017 at 11:30 am
Try this (untested and may require refinement)private string tempestRef;
public override void PostExecute()
{
base.PostExecute();
}
public override void Input0_ProcessInputRow(Input0Buffer Row)
{
if (Row.TempestRef_IsNull)
{
Row.TempestRef =...
November 6, 2017 at 10:35 am
November 6, 2017 at 7:52 am
SQL_Surfer - Monday, November 6, 2017 7:20 AMWhen that happens, sql server close the connection and nobody can access to it ...
Which...
November 6, 2017 at 7:36 am
November 6, 2017 at 7:03 am
Interesting find...check this out:
References to sys.sysprocesses generating SQL71502 Warning (unresolved refrerence)
So...
November 6, 2017 at 6:59 am
I think you would need to use a Script Component Transformation to do this.
Here is an example of something similar. Have a read and then post back...
November 6, 2017 at 6:50 am
We can't answer this, because we do not have access to your data.
What I can suggest is that you trim down your query so that it contains only SELECT...
November 6, 2017 at 6:06 am
With >500 points, you're clearly not a newcomer here and should know by now that you need to provide sample DDL + INSERT statements for test data + desired results,...
November 5, 2017 at 12:39 pm
November 5, 2017 at 6:55 am
Viewing 15 posts - 4,936 through 4,950 (of 13,877 total)