Viewing 15 posts - 3,631 through 3,645 (of 13,855 total)
Total number of rows should be equal to number of rows in C.
Unless multiple occurrences of the same CreditCheckLevel are returned by the subquery, in which case there will be...
May 17, 2019 at 3:13 pm
This is a bizarre piece of code – can you explain what it is intended to do, please?
Why would CustomerId ever be equal to CreditCheckLevel? Even if it is, why...
May 17, 2019 at 2:36 pm
Would you know how to do that?
No I don't. Constraints and checks are there to prevent bad things happening. They do not change data.
Have you considered leaving the column as...
May 17, 2019 at 2:05 pm
I had a go at simplifying your first piece of code. As I don't have the underlying table structures, I may have made some slight mistakes, but see whether you...
May 17, 2019 at 2:02 pm
Neither defaults nor constraints will help here.
But an INSTEAD OF INSERT trigger could do the work. Have a look here for an example/walkthrough.
Incidentally, what is the datatype of the...
May 17, 2019 at 1:44 pm
The SQL Agent job steps idea could be expanded to something like this
May 16, 2019 at 10:47 pm
I tried Run in 64 bit runtime to False still same error.
What error is that, exactly?
May 16, 2019 at 10:25 pm
Can RANGE window function take user input as value for interval and ranges instead of unbounded preceding and current row?
What do you mean by "user input"? What client application...
May 16, 2019 at 10:21 pm
Please note that I hit 'Report' when I meant to hit 'Quote' and there seems to be no way of reversing that ... apologies.
This makes no sense to me -...
May 16, 2019 at 2:01 pm
On a side note, if you have any control over the structure, you would be better off storing the date as a DATE or DATETIME field. Then it can...
May 15, 2019 at 2:57 pm
I need to change the sql server collation of the installed sql 2016 how can I do ? can any one provide the steps to change ?
Presumably you've done...
May 14, 2019 at 7:05 pm
Rant understood!
The only possible non-GUI way I can think of for adding these variables to multiple packages is as follows:
May 14, 2019 at 2:41 pm
Config data should be held in parameters, not variables.
Assuming you are using the project deployment model, parameters can be added at the project level.
So you can do it all in...
May 14, 2019 at 2:07 pm
Are you saying that you have multiple packages to modify and each of them needs to have the same 10 variables added?
Can you provide some background on the requirement? There...
May 14, 2019 at 1:46 pm
Why not just
SELECT * INTO [Database].[Schema].[Table]
FROM #tmp_Table
WHERE 1 = 0
?
May 14, 2019 at 1:44 pm
Viewing 15 posts - 3,631 through 3,645 (of 13,855 total)