Viewing 15 posts - 2,386 through 2,400 (of 5,109 total)
Hi Aaron, an attribute won't work, as the xml is fed to an application, which expects the format to be a certain way (that above). Using attributes is not the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 19, 2017 at 8:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 4:28 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 3:13 pm
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 8:44 am
What actually surprised me is the amount of countries, once GDPR comes in, we're not allowed to share data with, unless the company itself can show that they are following...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 8:28 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 3:09 am
Not sure you can no.
Personally, I would create a role, add all the users to the role and then grant the relevant Execute permissions to that role ...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 18, 2017 at 2:02 am
ROW_NUMBER() OVER (PARTITION BY CustomerID ORDER BY OrderDate)It looks as though...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 15, 2017 at 3:13 am
Rank over () ( Partition by c.cust_id order by od.orderdate...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 15, 2017 at 1:38 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 14, 2017 at 8:13 am
Back at the desk now: https://www.caa.co.uk/WorkArea/DownloadAsset.aspx?id=4294975948
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 14, 2017 at 7:03 am
I'm on the phone, so I can't past links (SSC "feature") however I searched "Heathrow airport snow contingency plan", and the second link is the final review of that document...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 14, 2017 at 6:28 am
Yes, there's a lot of variables to consider. Although the Logical Processing page gives how queries work for the most part, it's not necessarily always how it works (and the...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 14, 2017 at 4:30 am
If you mean, what order is the Statement processed in, have a look at SELECT (Transact-SQL); specifically the section on Logical Processing Order.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 14, 2017 at 4:14 am
Have you tried running that SQL you provided? Can you provide some working DDL, Sample data, and SQL please?
Edit: just noticed that the table is called #SampleData in both...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
December 13, 2017 at 7:29 am
Viewing 15 posts - 2,386 through 2,400 (of 5,109 total)