LutzM

Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 5,502 total)

RE: Issues While Parsing XML file

A few thoughts:
1) you should think about using XQuery instead of OpenXML.
2) you need to qualify every name space you're using in your xml.
Please see the following example:
DECLARE @xml XML...

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]

July 24, 2009 at 1:03 pm

#1029994
RE: Reading xml string

Hi Sirish,
the first "issue": if you're posting xml data please use the [ code="xml" ] tag without spaces. This site has some difficulties to display xml structure properly if xml...

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]

July 22, 2009 at 3:23 pm

#1028695
RE: condensed rows

Based on your sample data the following code should give you the same result as your code does.
However, it will give you the max value for each of the three...

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]

July 21, 2009 at 3:23 pm

#1027957
RE: Please help me with this From Clause

To replace a string in SSMS you could use {STRG}+H. This will allow you to do search and replace.
You have to make sure that the new table will have columns...

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]

July 20, 2009 at 4:53 pm

#1027342
RE: 3 table Pivoting

sharminjose (7/20/2009)
...But having said that, is there any way that we can avoid hard coding 'Basic', Intermediate' and 'Advanced'. In future there may be more plans added and they may...

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]

July 20, 2009 at 4:17 pm

#1027334
RE: 3 table Pivoting

Hi,
below please find two version on how to get the pivot done:
The first one is using "cross tabs" and the second one the SQL PIVOT syntax.
Usually, the cross tab function...

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]

July 20, 2009 at 3:45 pm

#1027321
RE: Convert FROM SQL BOOLEAN TO ORACLE INT

duplicate post.
for future discussion please see
http://www.sqlservercentral.com/Forums/FindPost755525.aspx

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]

July 20, 2009 at 2:52 pm

#1027296
RE: Returning accumulated totals from multiple rows

Based on Jeff's SQL statement I'd like to extend it to include the start and end time you mentioned in your first post.
Please note the way I used dateadd/datediff on...

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]

July 18, 2009 at 7:33 am

#1026551
RE: SQL Server 2005 Surface Area Configuration not showing Database Engine component

duplicate post.
Please continue discussion here .

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]

July 18, 2009 at 3:38 am

#1026520
RE: can i qualify this sql to only rows that don't match?

Hi Lisa,
the following code might work. It's untested since I don't have anything to test against.
If you're looking for a tested solution, please provide test data as described in 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]

July 18, 2009 at 3:35 am

#1026519
RE: Set time to default value as zero

Based on arun's sample data there's another option (which is usually faster):
create table #temp
(
slno int,
date1 datetime
)
insert into #temp
select 1,getdate()
union all
select 2,DATEADD(dd,0,DATEDIFF(dd,0,getdate()))
For a performance comparison of the various date conversion functions...

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]

July 18, 2009 at 2:44 am

#1026517
RE: Datefunctions

Please provide table definition as well as sample data and expected result.
You also should include what you've tried so far and what you're struggling with.
For details on how 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]

July 17, 2009 at 12:44 pm

#1026385
RE: Fast Update(Please Help)

Did you ever consider getting a consultant to help you resolve your performance issues?
(afaik this already has been recommended in one of your numerous other threads regarding the auditdata issues...)
I...

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]

July 16, 2009 at 5:07 pm

#1025957
RE: export to excel

Yes, there is. But it's not like "just add an output=EXCEL parameter"...
An example can be found here [/url].
Another option using an DTS package can be found here...

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]

July 16, 2009 at 1:31 pm

#1025877
RE: Importing data from flat file to SQL Table

I didn't mention to get the column information from the flat file you've been talking about.
What I've been talking about is to export the relevant column definitions from the Cache...

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]

July 16, 2009 at 12:12 pm

#1025838

Viewing 15 posts - 5,086 through 5,100 (of 5,502 total)