SQL Views - Variables


CREATE VIEW VW_X
AS

WITH MyVars (AnoInit, AnoEnd)
  AS (
SELECT
  2010 AS 'AnoInit',
  (SELECT TOP 1 AnoLetivo FROM TB_Anos) AS 'AnoEnd'
  )

SELECT
              AnoX,
              (SELECT AnoInit  FROM MyVars) as AnoInit,
             (SELECT AnoEnd  FROM MyVars) as AnoEnd
 FROM TABLE


GO

Comments

Post a Comment

Popular posts from this blog

Download file from input type file javascript

        <script>             function downloadFile() {                 if (!window.File || !window.FileReader || !window.FileList || !window.Blob) {                     alert('The File APIs are not fully supported in this browser.');                     return;                 }                 input = document.getElementById('fileinput');                 if (!input) {                     alert("Um, couldn't find the fileinput element.");                 }                 else if (!input.files) {           ...
Read more

POST an array of objects with $.ajax to C# WebMethod

//Create JS method invoking your C# WebMethod (example: getNames)     function getFstNames() {         var myObj = [             { 'fstName': 'name 1', 'lastName':'last name 1', 'age': 32 }           , { 'fstName': 'name 2', 'lastName':'last name 1', 'age': 33 }         ];         var postData = JSON.stringify({ lst: myObj });         console.log(postData);         $.ajax({             type: "POST",             url: "http://yourUrl.aspx/getNames",             data: postData,             contentType: "application/json; charset=utf-8",             dataType: "json",             success: function (response) {   ...
Read more