I wonder if hes teaching you the pain of using whiles. 😀

Anyway back to the question at hand.

Firstly you've placed the @StartDate in single quotes you shouldnt

The...

I know the one you're talking about GSquared, Gail made a lot of very interesting points and I think Paul also added a few comments about inplace updates.

The only...

Can you post the code that you have tried.

As you are learning I would strongly recommend that stop using While loops/Cursors these are notoriously inefficient, in addition you will learn...

This looks like you want to the column in all rows on a table to 1 dependant on the value of a Paramater. correct?

I would suggest using Dynamic SQL to...

purushottam2 (2/6/2013)

---

I have used CROSS APLLY, it worked fine for me. udf is having 1000+ line of codes and sp is also too much so not able to paste here...

In your example if @Values=1 then every row in the table will be updated to @Value correct?

Update Table

Set Column1=@values

where @values=1

will do exactly the same as your example, but something in...

Thats a great take on the Date table creation and added to my snippets.

You may be looking for something more like this which creates 10 years of dates from the BaseDate.

There are two versions one using a While loop and one with a...

Phil Parkin (2/6/2013)

---

Jason-299789 (2/6/2013)

---

(reposted from other thread)

Your best bet is to use a TALLY table, a CTE, or at worst a Recursive CTE.

using an crude tally table

With Cte_n

AS

(

Select 1...

(reposted from other thread)

Your best bet is to use a TALLY table, a CTE, or at worst a Recursive CTE.

using an crude tally table

With Cte_n

AS

(

Select 1 a Union ALL...

Moved to oher post due to cross in Anthony's

No problem, I wasnt sure which row you wanted the time assigned to, you could change the assignment round on the Lookup to the CTE a second...

Its called doing it on the...

something like this should work

I dont know how it will perform, on a large data set, but something like this is probably what you are looking for and should give...

ChrisM@Work (2/5/2013)

---

No less than four levels of nested queries! Good Lord, no wonder it takes so long. Examining the code, none of it, even the few queries, look as if...