LutzM

Forum Replies Created

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

RE: Stored Procedure

I truly hope you're not sending the password as plain text and compare it to another plain text value....
What concept do you use to store the password?
@Patrick_Fiedler:
Welcome, dear neighbor! (distance:...

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]

April 13, 2011 at 4:44 pm

#1311374
RE: Can I see which stored procedures are used in SSRS reports

WayneS (4/13/2011)
Jack Corbett (4/13/2011)
LutzM (4/13/2011)
I agree, the image data type is not the one someone would expect to find such valuable information. It's also strange that MS still uses 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]

April 13, 2011 at 3:47 pm

#1311363
RE: Can I see which stored procedures are used in SSRS reports

I posted a slightly different query as my answer to a quiz question (SQLServer Quiz 2011).
This query is modified to query SSRS 2008 and to return the actual parameter values...

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]

April 13, 2011 at 3:05 pm

#1311349
RE: Can I see which stored procedures are used in SSRS reports

You might want to have a look at
Jacob Sebastians blog (title: "How to find all stored procedures used by Report Server?") 😉

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]

April 13, 2011 at 2:47 pm

#1311339
RE: Are the posted questions getting worse?

Craig Farrell (4/13/2011)
Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of you, too?
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]

April 13, 2011 at 12:41 pm

#1311254
RE: Rank based Query- Help

You might want to have a look at Jeffs Running Total article[/url].
Based on the concept described in this article you could use a conditional increment instead of the running total...

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]

April 12, 2011 at 3:49 pm

#1310736
RE: Are the posted questions getting worse?

GilaMonster (4/12/2011)
jcrawf02 (4/12/2011)
Even when I know what's going on, I'm confused.
How do you think I feel? :hehe:
Just think about how it'll look like when we all change back to our...

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]

April 12, 2011 at 3:43 pm

#1310733
RE: Use of Union or concatenate

You could use
CROSS APPLY
(SELECT 'Added' AS Activity UNION ALL
SELECT 'Deleted') x
Together with
CONVERT(CHAR(19),CASE WHEN x.Activity THEN Added ELSE Deleted END,120) + ' ' + x.Activity

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]

April 12, 2011 at 3:38 pm

#1310729
RE: Are the posted questions getting worse?

I'm in!
@steve-2: how many active posters with GilaMonster avatars are needed before the cube icon in the SSC logo is replaced by a GilaMonster 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]

April 12, 2011 at 3:05 pm

#1310716
RE: How to Compare Two Rows and find out which columns got changed

I would use the UNPIVOT approach followed by a self join.
This would cover items 1 to 3.
I don't understand your last requirement (modified column names): How could this happen when...

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]

April 10, 2011 at 7:11 am

#1309606
RE: how to resolve a collation conflict between sql_latin1_general_cp850-bin and sql_latin1_general_cp850-bin2 in is operato

Either in your JOIN or your WHERE clause you reference two columns with a different collation.
You need to define one collation you'd like to use.
Something like
SELECT *
FROM ...

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]

April 10, 2011 at 5:23 am

#1309601
RE: How to Compare Two Rows and find out which columns got changed

Here's a SQL Server solution. AFAIK, CASE and CAST should work in SyBase 15.
SELECT
t1.part_id,
t1.adt_ts,
CASE
WHEN t1.pay_clct_am = t2.pay_clct_am
THEN 'unchanged'
ELSE 'old:' +...

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]

April 10, 2011 at 4:53 am

#1309600
RE: how to convert xml input to a single table in sp

Yes, it's possible. I think, XQuery together with CrossApply is the solution here.
You might want to have a look at Jacob Sebastians blog.

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]

April 9, 2011 at 3:18 am

#1309526
RE: How it can be done..

Please provide table def and sample data in a ready to use format as described in the first link in my signature. Furthermore, please include your expected result based on...

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]

April 8, 2011 at 11:16 am

#1309312
RE: import access db in sqlserver

Did you try a google search? (e.g. "import accdb Data Base file in sqlserver")

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]

April 8, 2011 at 11:11 am

#1309309

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