test

[farzinmonsef]

SQL

USE [Factor] GO

WITH myCte AS ( SELECT [typeNo] [typeNo], [s_index] = ROW_NUMBER() OVER(PARTITION BY [typeNo] ORDER BY [typeNo]) --t_index = DENSE_RANK() OVER (ORDER BY [typeNo]) --,[Code] --,[Name] --,[Link1] --,[Link] --,[Value1] --,[Value2] --,[Value3] --,[Deleted1] --,[id_export1] --,[id_export] --,[counter1] --,[counter] --,[Deleted] --,[CompUser] --,[LongData1] --,[LongData2] FROM [dbo].[typesFactor] where (id_export <= '2013-12-25') AND (id_export >= DATEADD(day, -190, '2013-12-25'))

) select count(*) from myCte where [s_index] = 1

GO

[farzinmonsef]

1

[farzinmonsef]

Sample Letter to Client

Write a letter to your client CEO Mr. Sam Cruise Inviting him for an official visit to your India office to meet up with the team.

Dear Mr. Sam Cruise,

I hope this letter finds you in the best of health and spirits.

We are delighted to have you as our client and as a sign of our appreciation we would like to invite you to visit our India office.

We would be honored to have you as our guest and would love to show you around our office and introduce you to the team. We are sure that this would be a wonderful opportunity for both of us to get to know each other better and discuss the project that we are working on together.

We look forward to your visit and we promise that we will make sure that your stay with us is as pleasant and productive as possible.

Please let me know when you would be available to visit us and I will make all the necessary arrangements.

Warm regards, [Your name]

[farzinmonsef]

DB save

https://stackoverflow.com/questions/2445326/how-to-store-the-file-in-the-database https://softwareengineering.stackexchange.com/questions/340687/reading-and-saving-big-data-to-db