LutzM

Forum Replies Created

Viewing 15 posts - 3,511 through 3,525 (of 5,502 total)

RE: Help generating XML from relational data

Nice solution, Matt!!
Much cleaner code thant the FOR XML EXPLICIT stuff...

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]

May 16, 2010 at 2:36 am

#1167991
RE: Finding similar values in a column

Maybe you can use SOUNDEX or DIFFERENCE to find similar rows. But I guess you'd manually need to verify the results, since there is no logic know of that...

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]

May 15, 2010 at 4:57 pm

#1167962
RE: Stored Procedure

Ok, I'll give you something to start with:
The two separate statements
SELECT @SUCCESSCOUNT = COUNT(CALLOUTCOME)
FROM OBD_CALLACTIVITY
WHERE CAMPAIGNID = @CAMPAIGNID
SELECT @VOICEOUTCOMECOUNT = COUNT(CALLOUTCOME)
FROM OBD_CALLACTIVITY
WHERE CAMPAIGNID = @CAMPAIGNID
...

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]

May 15, 2010 at 12:10 pm

#1167947
RE: Export data into xml file using SSIS

Would you mind sharing a sample file that shows the problem you're stuck with?

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]

May 15, 2010 at 2:28 am

#1167888
RE: Need help to make this sql query

First thing to notie: normalize your table.
There is no need to put AccountName in your Accounts table.
In order to get the hierarchy tree you should try to follow the example...

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]

May 15, 2010 at 2:17 am

#1167887
RE: Need help to make this query

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]

May 15, 2010 at 2:12 am

#1167885
RE: How to obtain week by week plus YTD totals

Ok, the easy stuff first: OP = original poster = the person who started the related thread (in this case: you). That's not a dumb question at all!, since it...

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]

May 14, 2010 at 5:23 pm

#1167835
RE: Sample database design, development, test and deployment for an online student class.

If you create/modify tables but you don't know how to design a database I'd expect there is someone in your team doing the design job. Maybe you should ask that...

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]

May 14, 2010 at 4:55 pm

#1167829
RE: Help generating XML from relational data

First of all: THANK YOU for providing perfectly formatted test data! Awesome job! 😀
And here's what I came up with (as far as I can se it'll return your expected...

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]

May 14, 2010 at 4:40 pm

#1167823
RE: Bulk move notes from one customer record to another

Nice screen shots! Seems like you put quite some effort into it...
Unfortunately, that's not even close to what the article I mentioned describes as "ready to use data"... :crying:
Again, please...

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]

May 14, 2010 at 3:06 pm

#1167788
RE: write a store procedure to generate report using SSRS2005

You might want to have a look at the Tallytable article referenced in my signature. Part of it as a split string version that will outperform your loop in most...

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]

May 14, 2010 at 1:14 pm

#1167746
RE: Help generating XML from relational data

Would you please provide table definition and some sample data in a ready to use format as described in the first link in my signature?
By doing so you would give...

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]

May 14, 2010 at 1:12 pm

#1167742
RE: How to "where like in" or "where in like" possible?

Not that i know of.
But there are several alternatives:
select * from my table
where filed like '%papper%'
or filed like '%pen%'
or using a split function 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]

May 14, 2010 at 1:10 pm

#1167740
RE: How to obtain week by week plus YTD totals

Here's an alternative way to do it:
;WITH cte AS
(
SELECT reportqid,incidenttype,sortorder,CONVERT(CHAR(10),enddate,112) AS enddate
FROM
( SELECT *
FROM HHSDataTest
) p
UNPIVOT (sortorder FOR incidenttype IN
(
[NumFoodSvcInsPerformed],
[NumRoutineFoodSvcInsPerformed],
[NumFollowupFoodSvcInsPerformed] ,
[NumCompliantFoodSvcInsPerformed] ,
[NumTouristAccomInspections],
[NumSolidWasteInsPerformed],
[NumFacilitiesClosed]
)
) AS unpvt
),
transform AS
(
SELECT...

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]

May 14, 2010 at 12:52 pm

#1167735
RE: Sum pivot columns

MTY-1082557 (5/14/2010)
Thank you Lutz
It works !
I will take at look at your article.
thank you again
My pleasure 😀
As a side note: the article I referenced in my signature is not mine....

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]

May 14, 2010 at 9:19 am

#1167624

Viewing 15 posts - 3,511 through 3,525 (of 5,502 total)