LutzM

Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 5,502 total)

RE: To improve the performance of the query.

Wouldn't the WHERE clause be equal to
WHERE
fbt.cust_no != '0306A'
OR channel_cd in ('Correspond','Correspondent','Retail','Wholesale','IGNORE CHANNEL') ? :unsure:

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]

August 11, 2011 at 2:26 pm

#1367578
RE: numbers very close to a barrier provide anomolous results

Ninja's_RGR'us (8/10/2011)
...
Had forgotten the function and was focussing simply on your operation!
Another reason to post DDL! 😀
Seems like I wasn't clear enough the code I posted could be used 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]

August 10, 2011 at 2:59 pm

#1366950
RE: numbers very close to a barrier provide anomolous results

Ninja's_RGR'us (8/10/2011)
Why bother with right?
SELECT 1 000 000 + CONVERT(INT, ID) WHERE ID < 1 000 000
Because it would not return a character value with leading zeros?
The function Matt posted...

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]

August 10, 2011 at 2:47 pm

#1366935
RE: numbers very close to a barrier provide anomolous results

instead of using LEN, you could get the same result with (assuming the purpose is to add leading zeros)
SELECT RIGHT(10000000 + CAST(idnumber as INT),7)
where id < 1 000 000
Edit:...

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]

August 10, 2011 at 2:33 pm

#1366920
RE: numbers very close to a barrier provide anomolous results

Can you post the function?
Second question: is there any specific reason to use FLOAT instead of NUMERIC() or DECIMAL() (or even INT)?

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]

August 10, 2011 at 2:17 pm

#1366910
RE: Running different peice of code for different parameters in single stored proc

if you want to insert three "groups" of data you should use three insert statements, each one with its own group by clause.
There might be a way to build one...

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]

August 10, 2011 at 1:06 pm

#1366843
RE: Running different peice of code for different parameters in single stored proc

I'm not sure if I understand the concept. So let me ask: why do you have three parameter instead of just one?
Based on the description it should be easy 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]

August 10, 2011 at 12:36 pm

#1366819
RE: Script Need for find last date insert record

If you don't have a datetime column in the table in question holding this information and there is no kind of auditing (e.g. capture data modification in a separate 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]

August 10, 2011 at 12:15 pm

#1366804
RE: Hold the output of an SQL statement called by software & release after successful execution of another SQL statement

It's funny how a typo actually summarize the problem... (just look at the last line of the previous post) 😀
Without changing any code you won't get any change in...

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]

August 6, 2011 at 1:58 pm

#1364817
RE: Search & pattern matching within text/html values

One reason for not having a reply might be that we don't have enough information.
What type of "search criteria" are you looking for? Does the full-text search meet your requirements?...

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]

August 6, 2011 at 7:44 am

#1364775
RE: SQL Query

Thank you for providing ready to use sample data. Made it much easier than just based on the verbal description...:-D
It is assumed that the version number will be ascendign without...

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]

August 5, 2011 at 11:59 am

#1364564
RE: Multi language database

If during the original design phase someone had such a scenario already in mind (and therewith decided to use unicode data type (NVARCHAR() / NCHAR() ) for both, table structure...

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]

August 5, 2011 at 7:44 am

#1364353
RE: Are the posted questions getting worse?

I don't think there's any real chance to catch a "bad guy" with the methods "they" show at the airport nor the stuff they've come up with at airplanes (plastic...

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]

August 4, 2011 at 1:49 pm

#1363953
RE: sql for xml path

changesky (8/3/2011)
Thank you Lutz for providing a good solutioin with cte,unpivot and sunquey to build two nodes. According to your code, I finished the SP to generate to the whole...

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]

August 4, 2011 at 11:14 am

#1363838
RE: Updating data from one table in Database A to another table in Database B and schedule the update everyday

duplicate post. no replies please.
Original post: http://www.sqlservercentral.com/Forums/FindPost1154024.aspx

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]

August 4, 2011 at 1:10 am

#1363469

Viewing 15 posts - 1,126 through 1,140 (of 5,502 total)