kohav

/*****************************************************************************\

 Javascript "SOAP Client" library

 @version: 1.4 - 2005.12.10
 @author: Matteo Casati, Ihar Voitka - http://www.guru4.net/
 @description: (1) SOAPClientParameters.add() method returns 'this' pointer.
               (2) "_getElementsByTagName" method added for xpath queries.
               (3) "_getXmlHttpPrefix" refactored to "_getXmlHttpProgID" (full 
                   ActiveX ProgID).

kohav

function SOAPClientParameters()
{
	var _pl = new Array();
	this.add = function(name, value) 
	{
		_pl[name] = value; 
		return this; 
	}
	this.toXml = function()
	{

kohav

CREATE TABLE [dbo].[tTMP](
	[Id] [int] NOT NULL,
	[IdResp] [int] NULL,
	[IdBranch] [int] NULL,
	[IdPost] [int] NULL,
	[CountWorks] [int] NULL,
	[CountSub] [int] NULL,
 CONSTRAINT [PK_tTmp] PRIMARY KEY CLUSTERED 
(	[Id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]

kohav

/*using row_number()over*/
select Id_Otdel,
       firstName,
       row_number()over(partition by Id_Otdel order by firstName) rn
from d_Sotr 
where Id_Otdel in (11, 12, 21)

/*with reversal of result set*/
 select    max(case when Id_Otdel=11
                   then firstName else null end) as analysts,

kohav

учись - главное знать все из запросов
<SELECT statement> ::=    
    [ WITH { [ XMLNAMESPACES ,] [ <common_table_expression> [,...n] ] } ]  
    <query_expression>   
    [ ORDER BY { order_by_expression | column_position [ ASC | DESC ] }   
  [ ,...n ] ]   
    [ <FOR Clause>]   
    [ OPTION ( <query_hint> [ ,...n ] ) ]   
<query_expression> ::=   
    { <query_specification> | ( <query_expression> ) }   

kohav

<?php if ( have_posts() ) : query_posts('p=1');
  while (have_posts()) {
	the_post();
	the_content();
}endif; wp_reset_query(); ?>

kohav

1) http://svgporn.com
2) http://www.dummytextgenerator.com
3) http://www.behindthename.com
4) https://nick-name.ru/generate/
5) https://www.hipsterlogogenerator.com/  
6) http://compressjpeg.com/         
7) http://revaxarts-themes.com/documenter/
8) http://easings.net/
9) https://www.toptal.com/designers/subt...