LutzM

Forum Replies Created

Viewing 15 posts - 4,831 through 4,845 (of 5,502 total)

RE: PIVOT CLAUSE

In general, PIVOT can give you the requested result.
But when looking at your scenario it seems like you don't want to modify your pivot statement whenever you have a new...

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 3, 2009 at 11:46 am

#1074435
RE: Accounts Storage

To repeat my question from above:
Another question (probably the more important one) would be: what are you doing with the table in question? Is it used at all, and if...

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]

October 31, 2009 at 3:57 am

#1073487
RE: Accounts Storage

What does "25 lakh" mean? 25.000, 25.000.000 or something different?
If it's 25.000 within two month I wouldn't worry about it. It would take about 7 years until you hit 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]

October 31, 2009 at 3:31 am

#1073483
RE: Hierarchical Table Design Question

Gus, thank you for the link to Joe's article!
I don't use hierarchies that often so I used to do it the "old fashioned way"...
The article really does show an alternative!

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]

October 30, 2009 at 2:49 pm

#1073390
RE: Pivoting multiple record values in one column into separate columns

Here's an example on how to convert rows into columns.
-- remove intermediate table if existing
IF object_id('Tempdb..#intermed') IS NOT NULL
BEGIN DROP...

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]

October 30, 2009 at 1:00 pm

#1073335
RE: Hierarchical Table Design Question

Table structure:
Emp_ID, EmpName, Parent_ID, Offset
001, Bill, Null,0
002, Allen, 001,0
003, James, 002,0
004, Wendy,001,1
SQL logic:
How about splitting the effort?
Your part: providing query to do the standard hierarchy
Our part: we'll help 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]

October 30, 2009 at 12:29 pm

#1073322
RE: Hierarchical Table Design Question

Based on the given data there is no information that Wendy should be at level 3. Why not level 4 or 10?
You probably need an additional column indicating the level...

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]

October 30, 2009 at 11:51 am

#1073297
RE: Load Typed XML into sql server 2005

Since you have a typed xml file, you need to use the NAMESPACE declaration.
I would use T-SQL rather than SSIS though. Therefore I'll show you an T-SQL example:
;WITH XMLNAMESPACES (
...

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]

October 30, 2009 at 11:41 am

#1073290
RE: Pivoting multiple record values in one column into separate columns

What would your expected result set in general and especially in terms of handling dups (e.g. for 'AARON K' and 'ENGLISH'?
The issue itself sounds like a task for dynamic cross...

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]

October 30, 2009 at 11:07 am

#1073280
RE: Pivoting multiple record values in one column into separate columns

jcrawf02 (10/29/2009)
Thanks Seth, I tried to go down that road, but all the examples are using aggregation of some sort, which I wouldn't want to do, just pivot the straight...

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]

October 29, 2009 at 11:46 am

#1072691
RE: Would you be concerned??

j.a.c (10/28/2009)
(a retired lawyer)
Well, that most probably eliminates the "good guy approach" options....
Arguing with a lawyer wouldn't be anything I'd recommend. That pretty much reduces the options to either 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]

October 29, 2009 at 11:24 am

#1072677
RE: Would you be concerned??

Elliot brought up a couple issues where you or the cops or the city can't do anything about the stuff that person is doing.
But look at it from the other...

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]

October 28, 2009 at 5:59 pm

#1072173
RE: Would you be concerned??

I would try to contact that person and ask in a most gentle way something like
"Would you mind sharing your reason for having that camera up there? I have kids...

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]

October 28, 2009 at 3:20 pm

#1072112
RE: getdate() convert function

Garadin (10/28/2009)
I do seem to remember that there are slightly different variants of both of these methods that are supposed to overcome very specific problems though (using a higher precision...

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]

October 28, 2009 at 2:53 pm

#1072089
RE: getdate() convert function

ssismaddy (10/28/2009)
for me
select convert(datetime,convert(char,getdate(),100)) it worked perfect.I just don't want seconds and msecs.
In that case I'd use
SELECT dateadd(mi, datediff(mi, 0, getdate()), 0)
It's supposed to perform better than converting...

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]

October 28, 2009 at 1:40 pm

#1072038

Viewing 15 posts - 4,831 through 4,845 (of 5,502 total)