Viewing 15 posts - 31 through 45 (of 325 total)
October 31, 2018 at 2:55 pm
The generic "rule of thumb" is that scalar functions are usually bad from a performance perspective and the recommendation is usually to opt for either writing the expression directly or...
October 31, 2018 at 2:47 pm
October 31, 2018 at 2:29 pm
Yes, by "small" scope I meant it's only guaranteed to be in effect for a single query. It might be a good idea not to confuse people by changing aliases...
October 31, 2018 at 2:10 pm
October 30, 2018 at 4:58 pm
Glad to help. If anyone has a better way I'd be interested to hear it too.
October 26, 2018 at 2:01 am
I think you can use a Table Valued Function in the database with the MO table, but it's been a while since I looked into it. It would probably have...
October 26, 2018 at 1:27 am
October 25, 2018 at 9:03 pm
October 25, 2018 at 12:22 pm
I totally agree on all counts, Andy. It's why such exercises like the...
October 25, 2018 at 12:15 pm
October 25, 2018 at 12:42 am
Having worked in a university previously, I can tell you that a lot of GUI programs are deliberately not things you're likely to find out in the "real world" simply...
October 25, 2018 at 12:33 am
You can specify the structure of JSON in the With clause, something like:
WITH
(
Id int N'id',
Stat1 int N'stat.stat1'
Stat2 int N'stat.stat2',
Stat3 int N'stat.stat3'
)
October 23, 2018 at 6:27 am
Select
X.N.value('PolicyNumber[1]','varchar(50)'),
X.N.value('AccountingDate[1]','varchar(50)'),
X.N.value('PolicyExpirationDate[1]','varchar(50)')
From @x.nodes('/ROOT/Policy') X(N)
Select
X.N.value('PolicyNumber[1]','varchar(50)'),
...
October 23, 2018 at 12:53 am
I suspect this will be a lot easier and substantially faster if you get rid of all the cursors and just query the XML directly. What are the table structure(s)...
October 22, 2018 at 11:13 am
Viewing 15 posts - 31 through 45 (of 325 total)