just a thought......have you considered using a calendar table to define your "weeks"?

weeks can be a real PITA....every time I go near them, the powers that be have different...

as posted above

"We would need full DDL and DML for the existing records."

give us something to work with and you may be surprised at the quality of the answers

Ok...will try....does the following help?

--first, we can extract the column names from INFORMATION_SCHEMA.COLUMNS

SELECT

COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = N'Test1';

--We could then...

you dont need to know the number of columns in the table...the code will create a value for each column...be that 3 cols or 30

does this help.......create the tables if...

maria.pithia (2/12/2015)

---

Thank you so much for the ans.

but wont be it like as becasue we dont know the number of columns in our table.we only know the name of out...

just a thought....maybe something along these lines

--CREATE TABLE [TEST](

--[col1] [varchar](5) NULL,

--[col2] [varchar](5) NULL,

--[col3] [varchar](5) NULL,

--[col4] [varchar](5) NULL,

--[col5] [varchar](5) NULL,

--[col6] [varchar](5) NULL,

--[col7] [varchar](5) NULL,

--[col8] [varchar](5) NULL,

--[col9] [varchar](5) NULL,

--[col10] [varchar](5) NULL

--)

DECLARE...

is it as simple as setting the default value for all the other columns to 'Hello" (one off job)...then you wont have to worry...just insert values for first...

maria.pithia (2/12/2015)

---

Hey

I am having a table say Test.

Now i want to do is insert any two values in first 2 columns and rest columns should contain Hello values without considering...

GrassHopper (11/25/2014)

---

I'm open to undocumented features. Glad you mentioned the issues with the "<=" because I was trying to do something with that. I'll trash that idea and...

GrassHopper (11/24/2014)

---

I am using SQL Server 2008. Line Number controls the order. Here is some test data to use for my example:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--===== If the...

Ed Wagner (11/22/2014)

---

The spam has hit with a vengeance. I'm inclined to agree with a post a while back that it's an actual person, not an automated process. ...

ok...so pls provide flatfile structure and delimiters, the table definition of the destintation,...

rajkarra91 (11/12/2014)

---

140 members who are missing from table. While loading the data into the table, the members are missing. The cause of the missing members needs to be determind and...

HI Melanie...I also received the same and have forwarded...

jacksonandrew321 (11/1/2014)

---

Hi consider below script

I want data to be look like below...