Viewing 15 posts - 1,396 through 1,410 (of 1,419 total)
Do you want concatenation or coalescence of the 3 columns? Can be 1 and only 1 value per row in these 3 columns? Could all 3 columns have values in...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
You posted 2 code blocks. It appears there is an issue with the second one. Where you define the cte:
VESValidEnrollList AS(
SELECT
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
So it's turtles all the way. At some point you must have a statement that access the cte's yes? Because if you define a cte and don't use it sql...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
It won't let me post code. Please add a select statement that references the common table expression.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
The spam filter will not let you post "select *star*" which is kind of annoying on a Sql site.
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Sorry, the 1,2,3,... syntax only works in sort by in Sql Server. Can't tell if the syntax parses because the tables aren't in my test instance. Please try:
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
These are the 5 'group by' columns in the select list:
EnrollmentID
,CoveragePeriod
,PSPolicyTransID
...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Oh ok I've looked into a little more. Sql does get calendar/clock time zone info from the OS (on Windows, not sure how it works on Linux). This is a...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Is this an MVC application? Was the sql was generated by the entity framework?
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Without wading into the specifics of your situation you could use the stuff() function in combination with for xml path.
In this code the cte is called num_expand and it creates...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Sorry, you asked if it's possible to install Sql Server with the Nepalese calendar. Sql will inherit the time zone info from the OS it's installed on. So if...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
What happens if you run this query?
select * from sys.time_zone_info order by 1
In Azure Sql the 77th row is:
Nepal Standard Time, +05:45, 0
What happens if you run this next query?
select...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
You're using SSMS and error says it's timing out. What is the timeout setting in your SSMS?
In SSMS menu go to Tools, Options, Query Execution, then General. The 3rd item...
Aus dem Paradies, das Cantor uns geschaffen, soll uns niemand vertreiben können
Viewing 15 posts - 1,396 through 1,410 (of 1,419 total)