chandraganabathy/sql

sql's Issues

issue

http://www.yoda.arachsys.com/csharp/parameters.html

MERGE dbo.SecurityMaster s
USING (SELECT distinct SecurityCode,SecurityType from FX where IsDirty = 0 ) f (SecurityCode,SecurityType) ON f.securitycode=s.code
WHEN NOT MATCHED THEN
INSERT (Code,Type,Version,CreatedDate)
VALUES (f.SecurityCode,f.SecurityType,'New',GETDATE());

void Main()
{
string toFind = "chandra";
string toSearch = "this is chandra";
Console.WriteLine(search(toFind, toSearch));
}

public bool search(string toFind,string toSearch)
{
for(int startIndex=0;startIndex<=toSearch.Length - toFind.Length;startIndex++)
{
int matchCount=0;
while(toFind[matchCount].CompareTo(toSearch[startIndex+matchCount])==0)
{
matchCount++;
if(toFind.Length==matchCount)
{
return true;
}
}
}
return false;
}