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...

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...

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...

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...

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...

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...

duplicate post.

for future discussion please see

http://www.sqlservercentral.com/Forums/FindPost755525.aspx

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...

duplicate post.

Please continue discussion here .

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...

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...

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...

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...

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...

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...