Use...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Bill given that the OP state business is asking for this I suspect this is not a one time situation. They are looking for something to use repeatedly. The excellent...

Honestly, the function posted is fraught with issues. There is all kinds of casting/converting both explicitly and implicitly.

If we are going to demonstrate how to do somebody's homework we should...

Suresh Babu Palla (10/24/2013)

---

Thanks sean, I have given the stored proc to the business, but they are specifically looking for a function instead of stored proc. So Just wanted to...

sqlislife (10/24/2013)

---

Thanks for the reply and the article.

To answer your question, the query is simply trying to delete row by row based on a certain join condition. Its currently...

Well to "correct" this...

You might also try reading this article. http://www.sqlservercentral.com/articles/62867/%5B/url%5D

Many many many times a tally/numbers table can be used in place of looping.

sqlislife (10/24/2013)

---

Hey Luiz, thanks for your response.

You are right, the data is really something I just made up and created on the fly, you are right there is no...

dmartin 38210 (10/24/2013)

---

case when DATEPART(DW, SED.earlieststartdate) = 1 then 'Sunday' else

case when DATEPART(DW, SED.earlieststartdate) = 2 then 'Monday' else

case when DATEPART(DW, SED.earlieststartdate) = 3 then 'Tuesday' else

case...

I had put together my own version but saw Keith posted one too.

I created some ddl to work with which I will post. I converted Keith's to use the same...

You are welcome. Glad that worked for you.

I sure don't see anything that indicates the speed issue is from the query side of this. Generating a 95 page excel doc is going to take some time for...

Do be careful here. The fine code that Bhuvnesh posted will have issues if you have gaps in your identity column.

declare @updatedef table ( id int identity, tablename varchar(30),...

Please post ddl and consumable data in the future. The query itself is pretty trivial but setting up the problem from a spreadsheet is painful.

Here is one way to do...