Viewing 15 posts - 1,081 through 1,095 (of 6,036 total)
yakko_Warner (10/26/2016)
I was trying to figure out...
October 26, 2016 at 7:43 pm
Table "a" is not mentioned in any filter or join condition.
Of course, every its row being applied to every record of the joined recordset of other 2 tables.
Is it how...
October 26, 2016 at 12:40 am
ocean3300 (10/25/2016)
Is there a way to write a single query to update all values? or any other ways to make it perform better?
1. Normalise your data.
Here I do normalisation on-fly,...
October 26, 2016 at 12:35 am
Sterling Ostin (10/24/2016)
October 25, 2016 at 4:34 pm
I guess this one is self-confessing:
alter table [Order]
add
DateTimeOrdered as dbo.JsonDateTime([Json], 'DateTimeOrdered', 'yyyy-MM-dd HH:mm:ss') persisted
go
create index IX_Order_DateTimeOrdered on [Order](DateTimeOrdered)
What to add?
Probably only this:
Extract all the other values from b..y...
October 24, 2016 at 7:27 pm
This should be enough:
---------------------[dbo].[Transaction]-----------------
ALTER TABLE [dbo].[Transaction] ADD CONSTRAINT [PK_Transaction] PRIMARY KEY CLUSTERED
(
[TransactionDate] ASC,
[ReferenceNumber] ASC
)
The rest of the parameters, as I can understand, are optional, and adding them to...
October 24, 2016 at 6:28 pm
Or, if you cannot rely on directionals being the last piece of Address strings, you may wish to use my original join, bit with an additional check that the Suffix...
October 24, 2016 at 4:18 pm
jeff.born (10/21/2016)
Yes there are, they are:N, S, E, W, NE, NW, SE, SW
Sergiy (10/21/2016)
Is there a fixed set of possible directionals?
In this case you can dynamically remove them from Address...
October 24, 2016 at 4:08 pm
Is there a fixed set of possible directionals?
October 21, 2016 at 12:34 pm
csj (10/21/2016)
October 21, 2016 at 4:54 am
SELECT DATEADD(dd, DATEDIFF(dd, 0, [date/time])/7*7), 0) WeekStart,
, sum(amount1), SUM(amount2)
FROM #Data
GROUP BY DATEPART(wk, DataDate);
No datefirst settings involved.
Converting of week start date to week number I leave to you, as...
October 21, 2016 at 4:34 am
Another question: what's gonna happen if I change a column data type from, say, varchar(50) to nvarchar(100)?
Or add a new column in between 2 existing ones?
October 21, 2016 at 4:16 am
Jay@Work (10/20/2016)
I'm just starting to think it...
October 20, 2016 at 7:56 pm
jeff.born (10/20/2016)
One question is the...
October 20, 2016 at 6:18 pm
Jay@Work (10/20/2016)
October 20, 2016 at 6:13 pm
Viewing 15 posts - 1,081 through 1,095 (of 6,036 total)