In your example, you used "12.22". What would you expect 12.22 to look like?

Are you are looking to convert the decimal fraction (22/100) to a binary fraction? .22...

There are a few options available to you that can simplify this type of thing. However, I can't say which would be best for your situation without considerably more...

Try it with more rows! 😉

With your code, the first two selects CAN use an normal index, the second two cannot. Unfortunately, though with the only 300 or...

@mtassin

You would not want to use that solution because it would not be able to take advantage of an index on that date column, resulting in a table scan.

@PW

Actually, the ORDER BY can apply to either the alias or the real column name. Now, with the example above, you will have to work around the GROUP BY...

Sorry, but I am confused. Your results don't match your query. Format 106 is "dd mon yyyy". Also, the order you mention as being correct does not...

Adam,

Based on the sample data and other queries that you sent my way, this would be my solution.

I started by creating a view for the table, TASKS. The view,...

I was thinking there might be a disconnect between your first query and the dataset you posted...hmmm.

So if I am seeing this correctly, the sample data is not...

You'll need to enable Advanced Options first:

EXEC sp_configure 'show advanced options', 1

RECONFIGURE

Then you can use Ole Automation Procedures.

As another programming note, based on indications you will be using this code again...

DECLARE @DateVal DATETIME

SET @DateVal = '2008-03-01'

;with mycte as

(

...

Since we are in the SS2K5 forum, I am going to assume you are using it and not SS2K.

IMO, the easiest way to build a recursive query is to use...

Based on the master table structure you posted, there is nothing of use in the "parent" table, Input1.

In that case, the methods presented by the other posters can be applied...

Which columns in the temp table are in which master table?

I am interested in the solution w/o using the temp table, if possible.

I know this isn't the question that was asked, but...

Is there a reason this couldn't be run from the two master tables, skipping the #Temp table?

Edit: This question was...

After seeing Matt's, we can just forget I posted! 😀

Great solution.