SELECT STUFF(
(SELECT ‘,’ + s.PerfIndDesc
FROM table s
ORDER BY s.id
FOR XML PATH( )),1 ,1, )
GO
Advertisements
;with a(
rcontrolid,logoname
)as (
select top 20 RControlId,LogoName  from RControl),
b(
RowNumber,rcontrolid ,logoname
)AS ( SELECT ROW_NUMBER () OVER (ORDER BY RControlId ASC ) AS RowNumber,* FROM a)
select * from b where RowNumber between 2 and 6
IFNOTEXISTS(SELECT*FROM sys.types st JOIN sys.schemas ss ON st.schema_id= ss.schema_id WHERE st.name =N’IdVal’ AND ss.name =N’dbo’)
CREATE TYPE [dbo].[IdVal] AS TABLE (
      [Id] [int] NOT NULL,
      [Val] [nvarchar] (100) NOT NULL
)
GO
/*
declare @Table dbo.IdVal
insert into @Table
      select 1,’val1′
            union
      select 2,’val2′
select * from @Table
exec somesp @TableInput=@Table
CREATE PROCEDURE somesp   
@IdVal IdVal READONLY
AS
……
 
*/

https://www.red-gate.com/products/sql-development/sql-search/

Date To EPOCH – Link

Posted: January 19, 2015 in REST
Tags:

Rest service returns the date in the form of epoch format in the json string. Below url can be used for conversion to validate the date …

http://www.esqsoft.com/javascript_examples/date-to-epoch.htm

http://www.gonzoblog.nl/2012/03/21/10-testing-tools-for-responsive-web-design/

Interesting ones …

Use http://responsivepx.com/ for all browsers

or

http://www.jamus.co.uk/demos/rwd-demonstrations/

or

use resize option with web developer plug-in for FF / Chrome

or resolution test chrome plug-in

https://chrome.google.com/webstore/detail/resolution-test/idhfcdbheobinplaamokffboaccidbal?hl=en-US

Angular JS – Links

Posted: November 6, 2014 in AngularJS
Tags: , ,
http://gruntjs.com/ – JS Bundling
 
Debug angular code –
  • ng-inspector – http://ng-inspector.org/ (Chrome plug-in to insepect angular scope)
  • Batarang is a GUI utility that is available as an extension for the Google Chrome browser
  • On chrome Console – angular.element(“mainTable”).scope() => (angular.element() is a jQuery function alias exposed by angular)