LutzM

Forum Replies Created

Viewing 15 posts - 676 through 690 (of 5,502 total)

RE: Create data for missing date

Here's my first approach. The result is a list of dates per hotel in the given date range with already known values.
While coding this solution I came across a question...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 14, 2012 at 4:28 am

#1433673
RE: Returning a column per date in a range

SQL Kiwi (1/13/2012)
LutzM (1/13/2012)
The main reason some of us go beyond a "it works in the context" solution is because there are people out there who -unlike your great attitude-...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 14, 2012 at 2:42 am

#1433665
RE: about the site itself

The way I read "reputation" on this site:
If there's an answer given a few minutes/hours ago where I think there's something wrong with it, I start to research. That sometimes...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 5:25 pm

#1433610
RE: Create data for missing date

I have more questions than answers:
Why aren't the data for Jan 14 declared as "missing" for both hotels?
Why does it start on a Sunday (Jan 1st) -assuming we're talking about...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 4:40 pm

#1433601
RE: tsql - xml question

brendan woulfe (1/13/2012)
Lutz - will doing that break the xml structure at all? I had a requirement to add the encoding header to an xml file and I did...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 3:53 pm

#1433585
RE: tsql - xml question

xRafo (1/13/2012)
Thanks,
that result can be export to a folder ? like "c:\config.xml"
it's possible?
There are several solutions:
a) SSMS (SQL Server Management Studio) , option "Results to File"
b) bcp (either started from...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 3:46 pm

#1433580
RE: tsql - xml question

To include the encoding, you'll need to change it to a varchar() data type. Otherwise SQL Server will internally use the encoding information but won't display it as part of...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 3:07 pm

#1433558
RE: Returning a column per date in a range

nick-1043370 (1/12/2012)
Wow, lots of discussion on the whys and wherefores here guys. Nice to have the big guns discussing the optimal solution to my question! 🙂
Got to say though, the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 13, 2012 at 9:28 am

#1433366
RE: SQL query performance issue.

I'm not sure if this would return the same result as your original query (or even run at all in the first place) since I have nothing to test against...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 12, 2012 at 3:50 pm

#1432936
RE: email excel file using sp_send_dbmail

Just change the file extension to .xls and tab as value for @query_result_separator

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 12, 2012 at 3:28 pm

#1432925
RE: Cloud Safety

I'm not sure if this question should also be on the list: What is the pay range for the DBAs and admins (in relation to the regoin the service is...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 12, 2012 at 12:06 pm

#1432827
RE: Question for the "experts"

DeanORenO (1/11/2012)
There is also this proclivity for answering questions with questions or turning the question on the asker, like most of the replies to my question will inevitably be.
If questions...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 11, 2012 at 5:16 pm

#1432223
RE: Few tricky Questions about SQL Server 2008 that I came across...

@craig-2: Answer A has an ORDER BY but invalid syntax.
The problem in general from my point of view:
There's a company looking for someone with decent SQL skills since they obviously...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 10, 2012 at 3:55 pm

#1431486
RE: Help with a Select statement

Why does the result set only show data for vendor_id = 15?
It looks like the second result set is either a repetition of previous columns or an aggregation. In...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 10, 2012 at 3:47 pm

#1431479
RE: Very Puzzling T-SQL question

GilaMonster (1/10/2012)
SQLKnowItAll (1/10/2012)
mdonald 98074 (1/10/2012)
You guys are right. I will go the route of counting my delimiters and adding 1. Thank you. Sometimes you look at something...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

January 10, 2012 at 3:27 pm

#1431466

Viewing 15 posts - 676 through 690 (of 5,502 total)