LutzM

Forum Replies Created

Viewing 15 posts - 691 through 705 (of 5,502 total)

RE: Help with a Select statement

still not clear. Please provide the expected output in a readable format (not mangled by the code ~~mysti~~prettifier)

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]

January 10, 2012 at 3:22 pm

#1431463
RE: Few tricky Questions about SQL Server 2008 that I came across...

Why don't you tell us what you think and why you think the questions are tricky and/or what your answer would be?
I think it's fair enough to have a discussion...

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]

January 10, 2012 at 3:17 pm

#1431461
RE: Few tricky Questions about SQL Server 2008 that I came across...

On some questions the answer would be "E: none of the above / it depends" (or C, respectively)

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]

January 10, 2012 at 3:04 pm

#1431453
RE: Help with a Select statement

Very nice sample data but the expected result is anything but clear.
Can you post in a different way what you're looking for? (maybe even attaching a jpeg)
And if the 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]

January 10, 2012 at 2:59 pm

#1431449
RE: Is it possible to use where is Max like 2005?

Please take the time to read and follow the advice given in the first article referenced in my signature and provide some ready to use sample data.
Furthermore I'd like 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]

January 10, 2012 at 2:06 pm

#1431405
RE: Is it possible to use where is Max like 2005?

Something like this?
SELECT TOP 1 xyz FROM table1 ORDER BY xyz DESC

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]

January 10, 2012 at 1:42 pm

#1431395
RE: how to delete the sql agent error logs on a development database

xiaoxiaoli72 (1/10/2012)
Or call one of you: BI published on air max 90 Vancouver, STI, as well as B lackspot irreverant advertising and consumption of sneakers, you know a fair trading...

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]

January 10, 2012 at 11:30 am

#1431327
RE: Microsoft Gold Certified Partner Companies - Horror Stories

royce.bacon (1/10/2012)
Before calling this a bad design you need to consider the functionality the software is providing. If the software allows the users to define the field names and...

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]

January 10, 2012 at 11:24 am

#1431321
RE: Returning a column per date in a range

Bob Cullen-434885 (1/10/2012)
Nick -
I don't know if it matters, but Paul's solution doesn't quite do what you specified, as it doesn't return data for the last date in the report...

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]

January 10, 2012 at 10:24 am

#1431296
RE: Are the posted questions getting worse?

Ninja's_RGR'us (1/10/2012)
Hey guys, what ressource can you recommend for worldwide list of countries, provinces, zip code, etc. The more the better. We ship to over 100 countries so...

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]

January 10, 2012 at 9:34 am

#1431264
RE: Insert XML data with Namespace into SQL Table

Well, from 600 rows in 5hrs to 4366 rows in 4 sec is quite an improvement!!
Thank you for posting the result!
And again, I'm sorry for not detecting the .query issue...

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]

January 10, 2012 at 9:09 am

#1431241
RE: rows to columns

And here's the CrossTab solution I had in mind:
;
WITH cte AS
(
SELECT
ProductId,
Picture,
ROW_NUMBER() OVER(PARTITION BY ProductId ORDER BY Picture ) AS row
FROM @table2
)
SELECT
t1.ProductId,
t1.SKU,
t1.[Description],
MAX(CASE WHEN t2.row=1 THEN t2.Picture...

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]

January 10, 2012 at 9:02 am

#1431235
RE: rows to columns

Join the two tables and pivot the data using the CrossTab method as described in the related link in my signature should do the trick.

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]

January 9, 2012 at 4:54 pm

#1430865
RE: Are the posted questions getting worse?

@jack-2: referring to your current avatar:
you might need to put the guitar aside for a moment. Looks like it would make typing a little complicated 😀
Or do you expect 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]

January 9, 2012 at 2:43 pm

#1430820
RE: Need to audit update without cursor

To expand on Gus solution:
(please note I added employee_code to the internal table variable since I think it might be helpful to know what row the change refers 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]

January 9, 2012 at 1:51 pm

#1430788

Viewing 15 posts - 691 through 705 (of 5,502 total)