Viewing 15 posts - 2,941 through 2,955 (of 26,488 total)
That is the behavior of MERGE. If you want a more granular update you should use separate INSERT and UPDATE statements.
April 3, 2017 at 9:26 am
Here is the updated view:
create view [V_DATE_RANGE] as
select
convert(varchar(100), 'Year To Date') as [Period]
, dateadd(year, datediff(year, 0, getdate()), 0) BeginDate
, convert(datetime,...
March 31, 2017 at 2:58 pm
My fiscal year calculation is wrong. Give me a couple of minutes to fix it.
March 31, 2017 at 2:49 pm
Using my suggested changes, here is your view. Please check it out and verify it works.
create view [V_DATE_RANGE] as
select
convert(varchar(100), 'Year To Date') as...
March 31, 2017 at 1:54 pm
My biggest suggestions are these:
1) Eliminate the use of character conversions. There are examples out there that show how to do a variety of the date manipulations being done...
March 31, 2017 at 12:55 pm
March 31, 2017 at 8:19 am
March 30, 2017 at 3:50 pm
March 30, 2017 at 3:32 pm
Never even tried it until today. And one hand on the keyboard and one on the mouse isn't an issue.
Doing things in a columnar fashion is one of...
March 30, 2017 at 3:28 pm
March 30, 2017 at 1:02 pm
I made a few changes, such as using int for id instead of varchar(20), datetime for instead of varchar(20) for the dates.
does the following provide what you are trying...
March 30, 2017 at 12:58 pm
Even if you don't add an explicit unique value to the clustered index, SQL Server will add a uniquifier to the clustered index if the values of the clustered index...
March 30, 2017 at 12:24 pm
March 30, 2017 at 12:16 pm
Viewing 15 posts - 2,941 through 2,955 (of 26,488 total)