Concluído

Write a SQL Server Stored Procedure

So I need someone to write a stored procedure that takes 2 date parameters as an input and then fills a table named date (structure is described on the details) The table is of course already created, all I want is that when I call the stored procedure, it truncates the table and then fills it with the date range given by the parameters. For example, say that you call the stored procedure like this: EXEC sp_FillDateDimension '01/01/2008', '12/31/2011' Then the stored procedure will fill the table with 1461 rows, one for each day of that time span. Please take a look at the attached excel file, that shows you an example of the rows that need to be generated. The fiscal year starts on 10/01/YYYY and ends on 09/31/YYYY On your bid, to make sure you understand and that you read the whole thing, please include what would be the first row if the starting date is 01/01/2000. Let me know if you have any questions, thanks!

## Deliverables

This is the table structure : CREATE TABLE [dbo].[Date]( [PK_Date] [datetime] NOT NULL, [Date_Name] [nvarchar](50) NULL, [Year] [datetime] NULL, [Year_Name] [nvarchar](50) NULL, [Quarter] [datetime] NULL, [Quarter_Name] [nvarchar](50) NULL, [Month] [datetime] NULL, [Month_Name] [nvarchar](50) NULL, [Day_Of_Year] [int] NULL, [Day_Of_Year_Name] [nvarchar](50) NULL, [Day_Of_Quarter] [int] NULL, [Day_Of_Quarter_Name] [nvarchar](50) NULL, [Day_Of_Month] [int] NULL, [Day_Of_Month_Name] [nvarchar](50) NULL, [Month_Of_Year] [int] NULL, [Month_Of_Year_Name] [nvarchar](50) NULL, [Month_Of_Quarter] [int] NULL, [Month_Of_Quarter_Name] [nvarchar](50) NULL, [Quarter_Of_Year] [int] NULL, [Quarter_Of_Year_Name] [nvarchar](50) NULL, [Fiscal_Year] [datetime] NULL, [Fiscal_Year_Name] [nvarchar](50) NULL, [Fiscal_Quarter] [datetime] NULL, [Fiscal_Quarter_Name] [nvarchar](50) NULL, [Fiscal_Month] [datetime] NULL, [Fiscal_Month_Name] [nvarchar](50) NULL, [Fiscal_Day] [datetime] NULL, [Fiscal_Day_Name] [nvarchar](50) NULL, [Fiscal_Day_Of_Year] [int] NULL, [Fiscal_Day_Of_Year_Name] [nvarchar](50) NULL, [Fiscal_Day_Of_Quarter] [int] NULL, [Fiscal_Day_Of_Quarter_Name] [nvarchar](50) NULL, [Fiscal_Day_Of_Month] [int] NULL, [Fiscal_Day_Of_Month_Name] [nvarchar](50) NULL, [Fiscal_Month_Of_Year] [int] NULL, [Fiscal_Month_Of_Year_Name] [nvarchar](50) NULL, [Fiscal_Month_Of_Quarter] [int] NULL, [Fiscal_Month_Of_Quarter_Name] [nvarchar](50) NULL, [Fiscal_Quarter_Of_Year] [int] NULL, [Fiscal_Quarter_Of_Year_Name] [nvarchar](50) NULL, CONSTRAINT [PK_Date] PRIMARY KEY CLUSTERED ( [PK_Date] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]

Habilidades: MySQL, SQL

Veja mais: write what i say, write all you want, write a bid, asc it, write a, stored, sql server c# 2008, mysql to sql, fiscal, excel with sql server, sql created, excel sql stored procedure, excel sql create, mysql constraint, mysql server example, write file excel, quarter excel, excel table mysql, stored procedure create sql, shows write

Acerca do Empregador:
( 43 comentários ) Zionsville, United States

ID do Projeto: #3730463

Concedido a:

mcconsulting

See private message.

$7 USD em 1 dia
(1 Comentário)
0.0

36 freelancers estão ofertando em média $20 para esse trabalho

sinharavi

See private message.

$25 USD em 1 dia
(44 Comentários)
5.4
customizedata

See private message.

$25.5 USD em 1 dia
(81 Comentários)
5.3
shadowdancerlv

See private message.

$25.5 USD em 1 dia
(11 Comentários)
5.0
cheapexcell

See private message.

$24.65 USD em 1 dia
(37 Comentários)
4.9
wizziewizard

See private message.

$25.5 USD em 1 dia
(13 Comentários)
4.9
habibjanjua

See private message.

$25.5 USD em 1 dia
(14 Comentários)
4.6
amcsummers

See private message.

$25.5 USD em 1 dia
(29 Comentários)
4.4
pradeepsingh37

See private message.

$25.5 USD em 1 dia
(12 Comentários)
4.4
wesolvevw

See private message.

$20.4 USD em 1 dia
(35 Comentários)
4.2
gladiali

See private message.

$15 USD em 1 dia
(11 Comentários)
3.6
sumon355

See private message.

$14 USD em 1 dia
(14 Comentários)
3.4
pakilahori81

See private message.

$25.5 USD em 1 dia
(8 Comentários)
3.1
josephj1989

See private message.

$21.25 USD em 1 dia
(8 Comentários)
2.8
thcristo

See private message.

$16 USD em 1 dia
(7 Comentários)
1.9
vw435307vw

See private message.

$10 USD em 1 dia
(3 Comentários)
1.6
scs24101983

See private message.

$12 USD em 1 dia
(2 Comentários)
1.6
Artoo22

See private message.

$20.4 USD em 1 dia
(1 Comentário)
0.0
wancer

See private message.

$25.5 USD em 1 dia
(0 Comentários)
0.0
Kuler

See private message.

$20 USD em 1 dia
(0 Comentários)
0.0
ExcelWT

See private message.

$25.5 USD em 1 dia
(0 Comentários)
0.0