LutzM

Forum Replies Created

Viewing 15 posts - 4,681 through 4,695 (of 5,502 total)

RE: XSD to sqlserver2k5 database

Based on the information provided my answer is "maybe".
Adding some more info to your post the answer might turn into "it depends".
Assuming enough information provided for xsd structure and desired...

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]

December 10, 2009 at 1:13 pm

#1090841
RE: How to construct an xsd for a special case

You might want read the following article:
http://www.sqlservercentral.com/articles/Schemas%2fDTDs/3118/
Note: Based on context I assume it's homework or something similar.
Therefore, I didn't post the answer right away, since -back to the old days...

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]

December 10, 2009 at 1:04 pm

#1090833
RE: Urgent Help required

Please read and follow the first link in my signature on how to post sample data.
The way the question is described doesn't really help to answer easily.
Maybe Dynamic Cross Tab...

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]

December 9, 2009 at 3:05 pm

#1090259
RE: Query help - Pivot maybe?

The aggregation used within the PIVOT clause is either to eliminate NULL values (e.g. MAX clause) or to SUM or COUNT the actaul number of rows.
You'll still get all your...

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]

December 9, 2009 at 2:47 pm

#1090249
RE: Generate XML Tree Structure

The nodes structure you provided as expected result is incomplete. You have 4 unclosed nodes.
This is really hard to notice since you're using the same name ("item") to describe at...

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]

December 8, 2009 at 2:35 pm

#1089530
RE: Handling Inconvenient Requests

I usually try to figure out if the request is because that person can't do it by himself/herself and it's not part of the general job that person is responsible...

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]

December 6, 2009 at 8:36 am

#1088262
RE: DTS dropping chars at 255

Triple post.
Please start discussion here
Note: duplicating a thread after just 10 minutes, then yet another one after just two more minutes probably is even less a good way...

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]

December 5, 2009 at 2:32 am

#1088137
RE: DTS dropping chars at 255

duplicate post.
Please start discussion here
Note: duplicating a thread after just 10 minutes probably is not the best way to get an answer...

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]

December 5, 2009 at 2:30 am

#1088136
RE: Insert xml values into Var Table

MTY-1082557 (12/3/2009)
it works perfectly, I need to insert the data into a var. Becasue im creating a function
Thank you for all your advices 😀
First: Glad to hear that Ryans solution...

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]

December 4, 2009 at 1:32 am

#1087524
RE: sql problem

untested, but it should work:
;WITH cte AS
(
SELECT ID, CODE FROM MyTable GROUP BY ID, CODE
)
SELECT ID, COUNT(*) AS CNT
FROM CTE
GROUP BY ID
HAVING COUNT(*) > 1

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]

December 4, 2009 at 1:19 am

#1087521
RE: FOR XML , Table hirearchy Question

Please follow the first link in my signature on how to provide sample data.
I guess one of the reason that you don't have an answer yet are the missing table...

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]

December 3, 2009 at 3:23 pm

#1087409
RE: Insert xml values into Var Table

I tried to run your query but stopped it after 3 minutes or so.
So, yes, I can confirm that it takes forever...
Then I just tried the sample code Ryan Randall...

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]

December 3, 2009 at 3:13 pm

#1087403
RE: How to get True /False

parthi-1705 (12/2/2009)
Hi
Try this
...
It is not coming in MIN ,MAX
Since this is not in the Table i can able to enter so CAN should Return But Yours...

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]

December 3, 2009 at 2:17 am

#1086956
RE: How to get True /False

I mixed old and new variables. Sorry.
select case
when cast(@FromTIME as datetime) BETWEEN @a AND @b
or cast(@ToTime as datetime) BETWEEN @a AND @b
then 'already'
else 'can'
end
Side note:
I too accept...

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]

December 2, 2009 at 6:09 am

#1086415
RE: How to get True /False

You could declare two variables holding min and max time
declare @a datetime,
@b-2 datetime
select @a= min(FTIME),@b=max(TTIME) from @TEMP
select case
when cast(@FromTIME as datetime) BETWEEN @a AND @b-2
...

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]

December 2, 2009 at 5:22 am

#1086380

Viewing 15 posts - 4,681 through 4,695 (of 5,502 total)