4,145 reputation
11236
bio website onlybluefeet.com
location Arizona
age 38
visits member for 2 years, 2 months
seen 5 hours ago

developer, techie, nerd.....

I like questions...

My feet are blue from running or I am part smurf. I haven't figured it out yet.

contact:

@onlybluefeet


1d
answered Optimize rows to columns conversion
Jul
21
comment Long running simple query SQL Server 2008 R2
Is there a reason why you aren't using an ORDER BY along with your TOP?
Jul
16
comment How to simulate a table join on itself?
@ypercube done, thanks for that.
Jul
16
revised How to simulate a table join on itself?
added 1216 characters in body
Jul
16
comment How to simulate a table join on itself?
@hmm It is also called a Cartesian result and instead of using CROSS JOIN you could use a comma between the 2 tables to get the list all products/dates. I prefer to state CROSS JOIN so it is clear what you are doing.
Jul
16
revised How to simulate a table join on itself?
added 138 characters in body
Jul
16
answered How to simulate a table join on itself?
Jul
5
answered change display of rows into single row in SQL server 2008 using dynamic PIVOTS
Jul
5
revised change display of rows into single row in SQL server 2008 using dynamic PIVOTS
added 770 characters in body; edited tags
Jul
5
comment change display of rows into single row in SQL server 2008
@user41979 Please don't edit this answer to ask another question, also don't edit your existing question. If you have additional questions, then ask a new question with the details needed for an answer.
Jul
5
reviewed Reject suggested edit on change display of rows into single row in SQL server 2008
Jul
3
comment change display of rows into single row in SQL server 2008
@user41979 Should be fixed there was a comma missing in the final select list. I'll update the SQL fiddle demo when the site is back up.
Jul
3
revised change display of rows into single row in SQL server 2008
added 1 character in body
Jul
2
revised change display of rows into single row in SQL server 2008
added 100 characters in body
Jul
2
answered change display of rows into single row in SQL server 2008
Jul
1
comment change display of rows into single row in SQL server 2008
Have you tried writing this query as a static version to get the logic correct? Without seeing your data and the final desired result, I'd only be guessing but I don't see why you are unpivoting the columns Beds and HotelSeqId. Can you edit your post with some sample data and then the final result, or even better create a sql fiddle?
Jul
1
revised change display of rows into single row in SQL server 2008
added 125 characters in body
Jun
30
comment Is select * still a big no-no on SQL Server 2012?
Why would you think that select * would be better in SQL Server 2012?
Jun
22
reviewed Close Can I get some comments on my database design?
May
25
awarded  Yearling