I'm lost as to why you would want to do that (especially at random), but what kind of result do you expect in terms of placing a date into anything...

Please don't think that I'm making you responsible for a data collection faillure - most of us are put into positions of having to make do with less than ideal...

For what's being asked for, how about the following:

DECLARE @DR TABLE (

Date_Taken DateTime,

Main_ID int,

Daily_RainFall int

)

INSERT INTO @DR VALUES('05/01/2005',194,142)

INSERT INTO @DR VALUES('06/01/2005',194,155)

INSERT INTO @DR VALUES('07/01/2005',194,132)

INSERT INTO @DR VALUES('08/01/2005',194,199)

INSERT INTO @DR VALUES('05/01/2005',196,333)

INSERT...

I took a look at your spreadsheet, and I see all kinds of columns for data that's easily computed. It also seems that every time someone has a...

This is actually fairly easy to do, and if we assume that the data is limited to a single school year, you won't necessarily need a calendar table. ...

While this appears to be solved, I was just wondering why use CONVERT or CAST? I would think that if you already have DateTime data types, why not...

Seems like a lot of effort for what's essentially a need to navigate a calendar, which suggests a solution that will work well provided the proper number of attendance characters...

Gwen,

I forgot to post the results from my query, which is attached in Excel format. I'm fairly sure this is what you were after...

Steve

(aka smunson)

:):):)

The pivot is an all at once kind of thing. It appears you're trying to do only one piece at a time, so take a look at the...

Can you post the T-SQL that provides this result?

Steve

(aka smunson)

:):):)

Gwen (6/4/2008)

---

Steve,

By using the aggregate function on the COMBINED_DATA field, I'm

getting multiple rows per property, rather than one row per...

Have you considered converting the integer to a fixed-length character string, using CAST or CONVERT, prior to encryption?

Steve

(aka smunson)

:):):)

If you can create a result set that for each item, also has the quantity or frequency of that item, and if you can use SQL 2005, you can then...

Now I see where you're at. It wasn't obvious to me from looking at your T-SQL that the potential for a heirarchical relationship beyond option and product beyond...

Try using LIKE, perhaps as follows:

SELECT DATA_VALUE

FROM MY_TABLE

WHERE DATA_VALUE LIKE '% %'

Note there is a single space between the two percent signs.

Steve

(aka smunson)

:):):)

want_to_know (6/3/2008)

---

HI

I have values like this:

10003 ...

How about using SQL Server 2005's UNPIVOT operator? See if something like the following might help:

SELECT [Date] AS DateKey, Customer AS CustomerKey,

Location AS LocationKey,...