LutzM

Forum Replies Created

Viewing 15 posts - 4,531 through 4,545 (of 5,502 total)

RE: update qry

I actually doubt you've tried the solution Wayne proposed....
He suggested to add a string to a string.
What you describe is to add two numbers.
But when you try to use Waynes...

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, 2010 at 10:22 am

#1102587
RE: Update field after stiping brackets from data

I would try the two methods below and check which one runs faster.
If the length of your data will always be the same then you might not need to use...

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, 2010 at 10:15 am

#1102580
RE: Weekly transactions issue

'criteria' is actually the WHERE condition you'd like to use.
It would help a lot more if you could set up some ready to use sample data so we can show...

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, 2010 at 9:46 am

#1102549
RE: Weekly transactions issue

something along those lines?
select *
from calendar c
left outer join YourTable y on c.date = y.date
where y.column=criteria or y.column is null

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, 2010 at 6:43 am

#1102361
RE: Weekly transactions issue

You should think about using a calendar table as a left join together with your query.
The calendar table can also be helpful when dealing with business days, holidays and so...

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, 2010 at 5:47 am

#1102332
RE: Identity column limitation

I'd expect you'll see an error message of the following type:
Msg 220, Level 16, State 2, Line 2
Arithmetic overflow error for data type tinyint, value = 300.
But, as stated several...

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, 2010 at 5:32 am

#1102326
RE: How to increase performance with DATE compare

Would you be allowed to copy the data into an additionally created table having correct table structure?

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, 2010 at 4:11 am

#1102286
RE: Using Subqueries and Joins - Retrieving columns from multiple tables without using table variables/temp tables

Please provide table definition and sample data as described in the first link in my signature.
Reason: there are some people around here (like me) that prefer to provide tested code.
By...

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, 2010 at 4:09 am

#1102285
RE: Allowing users to define columns....

If there are addtl. fields required I would use a form where clients could request it and let the DBA deal with it.
The solution you have in mind could lead...

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, 2010 at 2:35 am

#1102246
RE: How to increase performance with DATE compare

The biggest problem is to have date values stored as integer.
You have to convert it via character into datetime format (e.g. the way you did). And that's slowing down performance.
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 12, 2010 at 2:30 am

#1102243
RE: Week genearation dynamically

It looks like you're using dynamic query.
The second part seems to work (I'm getting WKRed:2010/01/10-2010/01/16, WKRedOrd: 2010/01/16).
It looks like there are some data missing when you apply your dynamic table...

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, 2010 at 12:56 am

#1102206
RE: parse comma-delimited list into seperate columns

I would use an index on ID, idx on table [test] for it...
Running over a minute for 100k rows seems strange...
What test scenario do you use?

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, 2010 at 4:31 pm

#1102102
RE: parse comma-delimited list into seperate columns

CirquedeSQLeil (1/11/2010)
I have tested both scripts and compared results.
I would go with the script provided by Wayne. When the result sets are small, then both are similar. When...

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, 2010 at 4:21 pm

#1102098
RE: parse comma-delimited list into seperate columns

WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
Well, the CrossTab solution I used is based on one of Jeff's articles as well...
Let's see, which one is going to...

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, 2010 at 2:52 pm

#1102070
RE: parse comma-delimited list into seperate columns

Is there any predefined order the data have to show up in the columns?
Based on your sample data it looks like the following would help (as a second step to...

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, 2010 at 2:38 pm

#1102062

Viewing 15 posts - 4,531 through 4,545 (of 5,502 total)