LutzM

Forum Replies Created

Viewing 15 posts - 3,616 through 3,630 (of 5,502 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (4/29/2010)
...
You guys have more patience than I. That series would have torqued me off pretty good.
I guess you might get a chance on another thread you're participating...

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]

April 30, 2010 at 9:42 am

#1160537
RE: Are the posted questions getting worse?

Lynn Pettis (4/29/2010)
By the way, did you see the latest post?
Yes, I've seen it but decided not to answer since I assumed that "bye" actually implied he's leaving 😀
So far...

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]

April 30, 2010 at 9:40 am

#1160534
RE: Pivot with Sub Pivot Problem

Please have a look at the CrossTab article as well as the DynamicCrossTab article referenced in my signature.
This will most definitely help you to solve this issue.

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]

April 30, 2010 at 5:02 am

#1160308
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/29/2010)
It has lost its tutu.
... but it can sing now!

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]

April 29, 2010 at 5:06 pm

#1160102
RE: Are the posted questions getting worse?

Lynn:
See, the hippo is doing just fine!

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]

April 29, 2010 at 4:32 pm

#1160097
RE: Are the posted questions getting worse?

@Lynn: May I take a break at the TITD? I'd even walk the hippo, if needed...
I need to take a break and relax before I cannot resit anymore to post...

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]

April 29, 2010 at 4:04 pm

#1160092
RE: OPENXML TSQL INSERT

Digs (4/29/2010)
...Please fix your code errors. ...
Pardon me??
In your initial post you defined a table [dbo].[DIM_OHLC_Xml] without the columns you want to insert into based on the query you...

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]

April 29, 2010 at 3:44 pm

#1160086
RE: Consider yourself a SQL Server Guru? - Solve this!

Like I said before, I'm not considering myself as a guru, but here's how I would do it:
CREATE TABLE #tbl
(
RowINT,
IDINT,
DatecreatedDATETIME,
EventINT,
Value INT
)
INSERT INTO #tbl
SELECT 1,1,'2010-04-01 06:16:16.623',0, NULL UNION ALL
SELECT 2,1,'2010-04-01 12:25:18.940',0,...

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]

April 29, 2010 at 3:32 pm

#1160080
RE: Consider yourself a SQL Server Guru? - Solve this!

I'm by far no SQL Server Guru, but that issue seems to be solvable.
The question is: What have YOU tried so far?
Also, if you want some of the heavy hitters...

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]

April 29, 2010 at 12:19 pm

#1159969
RE: Calculate Querry Result

What would the formula look like? Not having sample values, but a more general description.
Like (SUM(all values)+(values with < condition >) * < other values with different condition >)/MAX(value)*100

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]

April 29, 2010 at 9:45 am

#1159834
RE: Filtering data using float column

Still not sure what the problem is... your example works just fine:
DECLARE @tbl TABLE
(
DATE DATETIME,
amount DECIMAL(10,2),
interest FLOAT
)
INSERT INTO @tbl
SELECT '2009-04-10 00:00:00.000', 450.00, 00.23 UNION ALL
SELECT '2009-04-10 00:00:00.000', 451.00, -1.20 UNION...

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]

April 29, 2010 at 9:22 am

#1159800
RE: Help on counting working days between two variable dates

tommill (4/29/2010)
Thanks for this. It works! Thanks very much.
Tom
Glad I could help! 😀
But do you know HOW it works, not only THAT it works?
It's important to understand the code, not...

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]

April 29, 2010 at 9:19 am

#1159794
RE: Cast Float to Char with Natural Rounding

It's actually not a rounding issue. It's a form of presenting the result. This should be done at the frontend side, not within SQL Server.

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]

April 29, 2010 at 5:48 am

#1159575
RE: Help me to write a query

Did you notice? Based on the last login info the OP obviously lost interest or found an answer...

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]

April 29, 2010 at 3:40 am

#1159509
RE: OPENXML TSQL INSERT

Digs (4/28/2010)
I wish to hold a data dump
for 1000 symbols with 1000's of records
In one table row.
What columns you want to store the data in?
Please review your provided information...

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]

April 29, 2010 at 3:38 am

#1159508

Viewing 15 posts - 3,616 through 3,630 (of 5,502 total)