LutzM

Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 5,502 total)

RE: Back To Basics: Whats an update

The easiest way to verify it would be to add a AFTER UPDATE trigger to a test table and insert the results of the internal DELETED and INSERTED tables into...

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]

June 6, 2011 at 1:41 am

#1334214
RE: Referencing tables in another database

As long as you're referencing within the same instance (as you mentioned) Edit: [and the user has the permission to access this object], you could use the three-part name 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]

June 4, 2011 at 6:00 pm

#1334089
RE: Select duplicates on a table and update a certain column if it is duplicate.

It's a weird process to import duplicates on purpose and try to figure out there are duplicates afterwards... Why not add those rows to a separate table holding just 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]

June 4, 2011 at 2:35 am

#1334010
RE: Does Create Login automatically grant connect privilige

Duplicate post.
Already answered here.

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]

June 4, 2011 at 2:27 am

#1334009
RE: Query Help

Please re-read my previous post regarding some test data and help us help you.
It should return MAX(Balance) per Customer.FName and Customer.Address. So I would expect one row per customer. 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]

June 3, 2011 at 5:12 pm

#1333984
RE: Query Help

The syntax is correct. It returns data. So it IS working.
The fact you're expecting other results implies you're looking for a different query then. 😉
Since we don't know your data...

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]

June 3, 2011 at 1:16 pm

#1333892
RE: Query Help

Something like
SELECT MAX(Balance) AS BalanceMax, Customer.FName, Customer.Address
FROM Accounts INNER JOIN
Account_mm_Customer ON Accounts.AccountID = Account_mm_Customer.AccountID INNER JOIN
Customer ON Account_mm_Customer.CustomerID = Customer.CustomerID
GROUP BY Customer.FName, Customer.Address --, Balance

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]

June 3, 2011 at 12:51 pm

#1333879
RE: Fetching record set using stored procedure

Please explain what you'retrying to achieve (not in terms of SQL code but in terms of the related business case).
As per now to me the concept looks weird... There are...

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]

June 3, 2011 at 3:33 am

#1333556
RE: need to learn how to be a DBA

Learn_something_new_everyday (6/2/2011)
Also you could buy/rent hosted a VM from amazon and use 120 eval edition of SQL. Once the 120 days is up just add a new VM and start...

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]

June 3, 2011 at 3:22 am

#1333555
RE: need sequence in datetime

You might want to search this site for "calendar table" or you could have a look at the tally table article referenced in my signature (at the end there's an...

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]

June 3, 2011 at 3:10 am

#1333552
RE: need summarized info in the sql join queries

Either
SELECT model, COUNT(model) AS Qty_model
FROM PRODUCT
GROUP BY MODEL
HAVING COUNT(MODEL)>=3
AND TYPE = 'PC'
or
SELECT model, COUNT(model) AS Qty_model, TYPE
FROM PRODUCT
GROUP BY MODEL, TYPE
HAVING COUNT(MODEL)>=3
AND TYPE = 'PC'

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]

June 3, 2011 at 3:04 am

#1333551
RE: Are the posted questions getting worse?

SQLRNNR (6/2/2011)
LutzM (6/2/2011)
To quote from a thread I've been involved:
Also, I will start to participate on the site more often. It has always been useful and seems to be very...

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]

June 2, 2011 at 9:54 am

#1333204
RE: Are the posted questions getting worse?

To quote from a thread I've been involved:
Also, I will start to participate on the site more often. It has always been useful and seems to be very helpful 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]

June 2, 2011 at 9:40 am

#1333194
RE: updating several tables and deleting the original rows

The first thing would be to get a SQL Server Express edition (version similar to what you use at work) and install it at home or wherever you're planning 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]

June 2, 2011 at 8:48 am

#1333150
RE: Select distinct rows

peter.draper (6/2/2011)
I understand, in the real data it is date and time, so there should never be that situation 🙂
Peter
"Never" will only be enforced by a unique constraint.... 😉

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]

June 2, 2011 at 6:15 am

#1333042

Viewing 15 posts - 1,411 through 1,425 (of 5,502 total)