LutzM

Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 5,502 total)

RE: RiskIdShortName IN (select * from dbo.fn_ParseString2(@P_RISKID,','))

I'm not sure if SSIS would allow it:
I would store the output from the string parser into a separate table (temp table or table variable), do a direct join 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]

November 16, 2009 at 12:28 pm

#1079865
RE: XML on Sql Server

You might want to search for "XML Workshop" on this site.
It will give you a series of artivles by Jacob Sebastian covering usage of XML in SQL server (both directions:...

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]

November 16, 2009 at 4:50 am

#1079598
RE: SQL Query

The bold font you mentioned didn't show up.
Please show us your expected result together with what you've tried 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]

November 16, 2009 at 12:21 am

#1079515
RE: Query help

Would you mind showing us what you've done so far and where you got stuck?

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]

November 16, 2009 at 12:19 am

#1079514
RE: Surrogate lookup in DWH incidentally fails using T-sql (esp. on large datasets)

This one actually does look like it can be included without a function.
Regarding the other ones: I still don't know.
If you need to do a different handling the CASE...

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]

November 15, 2009 at 12:49 pm

#1079482
RE: Surrogate lookup in DWH incidentally fails using T-sql (esp. on large datasets)

Would you mind sharing the code for the function etl.fn_Lookup_SK_OrganizationKey_Costcenter_Admunit as well?
Maybe it's possible to change it into a normal join...

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]

November 15, 2009 at 10:40 am

#1079474
RE: How do I extract numbers from a text field?

Now you know why I didn't want to show my function... :crying:
The varchar(max) discussion is an ongoing subject on various threads from time to time but I didn't think a...

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]

November 15, 2009 at 8:30 am

#1079464
RE: help me to build this query. I'm going crazy.

Your very welcome.
Did you notice how fast you got an answer once you provided ready to use sample data?
And no, I cannot say "I know SQL". I know just enough...

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]

November 15, 2009 at 7:10 am

#1079457
RE: help me to build this query. I'm going crazy.

The "trick" is to concatenate the two columns Price and Money and treat it as one column inside the PIVOT statement:
SELECT ProductName, [NewYork] , [Berlin], [Moscow], [Zurich]
FROM
(SELECT
ProductName,
SalesPointName,
CAST (Price...

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]

November 15, 2009 at 5:55 am

#1079454
RE: help me to build this query. I'm going crazy.

Obviously, I've been wrong in guessing your table structure then...
Before I give it a second try I kindly ask you to provide sample data in a ready 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]

November 15, 2009 at 4:55 am

#1079452
RE: Comparison Between LinQ and NHibernate

[SET VENTING ON]
A vendor I've been forced to deal with late in a project used NHibernate to connect to a database he designed (for us).
When facing major performance issues I've...

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]

November 15, 2009 at 4:50 am

#1079451
RE: Surrogate lookup in DWH incidentally fails using T-sql (esp. on large datasets)

I don't want to sound offending but there still might be something wrong with the sp.
The way you describe it it sounds like you're using a cursor which might be...

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]

November 15, 2009 at 4:29 am

#1079448
RE: access to sql server

It looks like you have duplicate values for [CompanyNumber_PK] in your table.
You can check for duplicates with the following code:
SELECT CompanyNumber_PK
FROM YourStagingTable
GROUP BY CompanyNumber_PK
HAVING COUNT(*) > 1
Second question: why do...

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]

November 15, 2009 at 4:17 am

#1079446
RE: help me to build this query. I'm going crazy.

Why didn't PIVOT work?
Example:
SELECT prod, [newyork] AS 'newyork',[berlin] AS 'berlin',[moscov] AS 'moscov',[zurich] AS 'zurich'
FROM
(SELECT prod,point,price
FROM SalesPricesTable) p
PIVOT
(
MAX (price)
FOR point IN
( [newyork],[berlin],[moscov],[zurich] )
) AS pvt
ORDER BY prod
Another way would be...

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]

November 14, 2009 at 3:58 pm

#1079419
RE: How do I extract numbers from a text field?

Jeff Moden (11/14/2009)
Your welcome K... if you really want to learn how the Tally table works to replace WHILE Loops like Lutz did above, click on the TALLY table link...

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]

November 14, 2009 at 3:42 pm

#1079417

Viewing 15 posts - 4,756 through 4,770 (of 5,502 total)