LutzM

Forum Replies Created

Viewing 15 posts - 646 through 660 (of 5,502 total)

RE: Extract field containing XML file and load results into a datatable

There's no parser needed. As stated before, you can use the XQuery syntax to extract the data. Did you have a look at the blog I linked in my previous...

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]

February 3, 2012 at 11:52 am

#1442575
RE: Extract field containing XML file and load results into a datatable

Based on the very limited information all I can suggest is to look into XQuery syntax.
A few scenarios with coded solutions can be found at Jacob Sebastians blog.
If you're looking...

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]

February 3, 2012 at 11:26 am

#1442566
RE: Issue with Loading data from Excel sheet to SQL Server Table using SSIS package

It might be an issue of 64 vs. 32 bit (compiled using 32 bit, then transferred to a system with 32 bit).
A quick google search using the original error message...

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]

February 3, 2012 at 11:20 am

#1442561
RE: sql query

You might want to to try the CrossTab approach as described in the related link in my signature.
PS: Since it sounds like homework I think it's more helpful to provide...

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 30, 2012 at 5:05 pm

#1440301
RE: i wrote a split function for insert value in this table plz any one solve my problem

Please don't cross post.
There's already a discussion at this thread.
Thank 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]

January 30, 2012 at 2:16 pm

#1440256
RE: Easy way to search for a string any where within XML column?

And here's the query to search for a substring:
SELECT *
FROM @tbl t1
WHERE col.exist('//*/text()[contains(.,sql:variable("@id"))]') = 1
Depending on the size of the xml data this may take 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]

January 29, 2012 at 2:57 pm

#1439791
RE: GRAND TOTAL

Using PIVOT makes it rather complex to add the total dynamically.
You might want to use the DynamicCrossTab approach instead. For details please see the related link in my signature.

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 29, 2012 at 2:21 pm

#1439788
RE: Easy way to search for a string any where within XML column?

I'm not sure if I understood correctly, but it seems like you're looking for the "exist" method to query the xml data.
Here's a short sample:
DECLARE @tbl TABLE
(
id INT,
col...

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 29, 2012 at 1:38 pm

#1439783
RE: how write split function for this store procedure

er.sivaganesh (1/29/2012)
in a single store procedure iam just inserting values for 3 table in that among the 3 table the seond...

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 29, 2012 at 5:05 am

#1439720
RE: Performance Tuning

Star Trek (1/28/2012)
I do not have access to execution plans. This is what my manager sent me.
If the number of rows is really representative (a few hundred at max) then...

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 28, 2012 at 4:02 am

#1439663
RE: Performance Tuning

Can you post the actual execution plan?
Based on that row count there's just a limited information where the actual problem is.
Other than that I recommend to try the divide'n'conqueur approach:
Store...

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 27, 2012 at 4:02 pm

#1439643
RE: Simple PIVOT Example?

It's more an UNPIVOT issue than a PIVOT.
Here's a code snippet based on your sample data. Please note the way the sample data are provided 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]

January 24, 2012 at 11:52 am

#1437876
RE: Function to Return Current Date

SQLRNNR (1/23/2012)
LutzM (1/23/2012)
Why don't you use the DATEDIFF() function?
What's the goal you're trying to achieve?
That is funny - same question (goal), same time - different sources.
If I wouldn't be involved,...

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 23, 2012 at 4:48 pm

#1437423
RE: Function to Return Current Date

Why don't you use the DATEDIFF() function?
What's the goal you're trying to achieve?

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 23, 2012 at 4:39 pm

#1437420
RE: billy-yons and billy-yons of rows

Thomas Abraham (1/20/2012)
...
Funny you should mention that. I'm taking my wife to Greece this Summer for two weeks. (Trying to talk her into retiring there.) That's where I would have...

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

#1437417

Viewing 15 posts - 646 through 660 (of 5,502 total)