neural networks

Saturday, October 20, 2012

most simple example to understand common table expression in sql

Just declaration of a temporary table with single column

declare @temp1 table
(
id int
)

insert statement to insert one row in temporary table @temp1

insert into @temp1 select 1

common table expression example to recursively increase the column Id. i think this is the most simple example of looping or recursion to print 1 to 10 with out printing each statement individually .... :)

Here is code of common table expression in sql

;with cte As
   (
     select id from @temp1
     union all
     select id+1 from cte where id<10 br="br">   )
   select * from cte

sql fiddle for this post can be find here sqlfiddle link

Thursday, October 11, 2012

Select all dates between first day of month and current date without loop

DECLARE @startDate DATETIME=CAST(MONTH(GETDATE()) AS VARCHAR) + '/' + '01/' +  + CAST(YEAR(GETDATE()) AS VARCHAR) -- mm/dd/yyyy
DECLARE @endDate DATETIME= GETDATE() -- mm/dd/yyyy
;WITH Calender AS (
    SELECT @startDate AS CalanderDate
    UNION ALL
    SELECT CalanderDate + 1 FROM Calender
    WHERE CalanderDate + 1 <= @endDate)
SELECT [Date] = CONVERT(VARCHAR(10),CalanderDate,25) FROM CalenderOPTION (MAXRECURSION 0)

DECLARE @startDate DATE=CAST(MONTH(GETDATE()) AS VARCHAR) + '/' + '01/' +  + CAST(YEAR(GETDATE()) AS VARCHAR)  -- mm/dd/yyyy
DECLARE @endDate DATE=GETDATE() -- mm/dd/yyyy
SELECT [Date] = DATEADD(Day,Number,@startDate) FROM  master..spt_values WHERE Type='P'
AND DATEADD(day,Number,@startDate) <= @endDate

declare @temp table (ddate datetime);
insert @tempselect DATEDIFF(d,0,GetDate()-Number)
from master..spt_valueswhere type='p' and number < DatePart(d,Getdate())
order by 1;

Thursday, October 4, 2012

simple example of pivot in sql

declare @temp table (

id int identity(1,1),

deptname nvarchar(500),

type nvarchar(1),

value int

)

insert into @temp

select 'payroll','a',20

union all

select 'payroll','b',20

union all

select 'payroll','b',10

union all

select 'sales','a',20

union all

select 'sales','b',20

union all

select 'sales','b',10

select * from @temp

select deptname,a,b,c from

(select SUM(value) as value,deptname,type from @temp group by type,deptname) p

pivot (SUM(value) FOR type IN (a,b,c)) AS pvt

Sunday, August 19, 2012

Get Checkbox values comma separated using jquery

<div id="c_b">
<div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="swimmingpool" id="swimmingpool" value="1"></div>
  <div class="peroperty_text">Swimming Pool</div>
  </div>
  <div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="fitnesscenter" id="fitnesscenter" value="2"></div>
  <div class="peroperty_text">fitness center</div>
  </div>
  <div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="restaurant" id="restaurant" value="3"></div>
  <div class="peroperty_text">restaurant</div>
  </div>
  <div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="childrenactivities" id="childrenactivities" value="4"></div>
  <div class="peroperty_text">children’s activities</div>
  </div>

<div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="complimentarybreakfast " id="complimentarybreakfast " value="5"></div>
  <div class="peroperty_text">complimentary breakfast </div>
  </div>

<div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="meetingfacilities" id="meetingfacilities" value="6"></div>
  <div class="peroperty_text">meeting facilities</div>
  </div>


  <div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="petsallowed " id="petsallowed " value="7"></div>
  <div class="peroperty_text">pets allowed </div>
  </div>

<div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="wheelchair" id="wheelchair" value="8"></div>
  <div class="peroperty_text">wheelchair accessible</div>
  </div>

  <div class="checktextrow">
  <div class="peroperty_checks"><input type="checkbox" name="kitchen" id="kitchen" value="9"></div>
  <div class="peroperty_text">kitchen/kitchenette</div>
  </div>
</div>

<textarea id="t"></textarea>

Here is jquery code for access all checkbox using jquery and set the checkboxes values in textarea.

function updateTextArea() {

var allVals = [];
$('#c_b :checked').each(function() {
allVals.push($(this).val());
});
$('#t').val(allVals)
}
$(function() {
$('#c_b input').click(updateTextArea);
updateTextArea();
});

complete working example can be check here

Tuesday, August 14, 2012

replace html of a div using jquery

replace html of a div using jquery
this is simple . just use .html() method of jquery to set new html for a div .

$("#divID").html("new text");

Tuesday, August 7, 2012

why only 24 hours ?

i m feelin these days that in a day we have "only " 24 hours ?

does method signature include return type in C sharp (c#)

does method signature include return type in C sharp (c#)

I would say BIG NO

I read a lot of blogs and finally i have decieded to test by self and i just make some simple code

protected int sum(int a, int b)
    {
        return a + b;
    }

    protected float sum(int a, int b)
    {
        return a + b;
    }

when i run this its throws error

already defines a member called 'sum' with the same parameter types

but if i change the parameter type then its runs OK

so final result is method signature not include return type. and a method can be not overloaded just by changing its return type .