How about something like this?

create function dbo.IntToBinary (

@IntVal int

)

returns table

return(

SELECT

cast((select '' + cast(case when @IntVal & POWER(2,v.number) = 0 then '0' else...

Ric Sierra (9/15/2009)

---

Lynn Pettis (9/15/2009)

---

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case...

Ric Sierra (9/15/2009)

---

Just... keep simple!

If you need to delete a large number of rows and the scenario don't need to keep the database log.

In this case I want to delete...

SQLBOT (9/15/2009)

---

I'm new to using the tally table, and I'm sitting here dumbfounded trying to come up with a way (using a tally table) to convert integers to their binary...

Tao Klerks (9/15/2009)

---

Hi Lynn,

Good article concept, this is a problem that I've had to deal with many times, and I suspect most DBAs do at one point or another.

A couple...

Matt Whitfield (9/15/2009)

---

Nice one Lynn 🙂

I've found that for deleting a sub-section of data from a much larger table (for example - can we delete history from transactions table that...

I have one last question, is one row of data in each table really representative of the problem we are trying to help you...

Then you have the OP that refuses to read the suggested article and won't post data in a readily usable format. First as a text file, then as an...

Nope, still requires more work on our part. Have you read the article you were...

It would help if you provided the DDL for the view (and the underlying tables), sample data for the underlying tables, and your expected results based on the sample data.

Well, you did provide us with data, but unfortunately it isn't in a readily consummable format and I really don't have time to put it into a usable format at...

Not asking for actual data. You should be able to create a data set that is representative of your actual data that also reflects the problem you are trying...

This part is confusing:

The problem I have which I may need help with is that, the system I have is based on the year ending on the first Saturday of...

Now all that is missing is the sample data and expected results.

Paul White (9/13/2009)

---

You're right Lynn - and I did mean to post an introduction...but life got in the way I'm afraid. Sorry.

Many of you might recognise Matt's name from...