"susiedba@hotmail.com" wrote:

> you should be using NOLOCK
>
> select * from myTable (nolock)
> select * from myTable WITH (nolock)
>
>
>
> Tony wrote:
> > I'm very new to reporting services and running into a problem. I am trying
> > to create a new dataset for a report. I have built the query with the
> > diagram pane interface. When I try to execute it, I'm getting a SQL
> > Execution Error. The query runs within Management Studio but takes close to
> > 6 minutes to run. I've even tried to increase the ODBC time-out parameter to
> > more than 8 minutes(480 seconds) and it still times out. Is there a number
> > of levels of views that reporting services can only use? I mean, the views
> > that I am using are as deep as 3 levels (Views(final views) derived from
> > views(second tier) which were derived from views(first tier) which are
> > derived from physical tables).
> >
> > If anybody is interested, here is my Query that I'm trying to run. Any help
> > would be greatly appreciated! Thanks in advanced!!
> >
> > SELECT
> > ods.AccountThreeYearMonthlyDonationSummary.AccountNumber,
> > ods.Account.CreatedOn,
> > ods.Contact.LastName,
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last12),
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last12Gift),
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last1324),
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last1324Gift),
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last2536),
> > sum(ods.AccountThreeYearMonthlyDonationSummary.Last2536Gift),
> > ods.Account_MailSolicitations.MailSolicitations,
> > ods.Account.NameLine,
> > ods.Contact.FirstName,
> > ods.Contact.Salutation,
> > ods.CustomerAddress.Line1,
> > ods.CustomerAddress.Line2,
> > ods.CustomerAddress.City,
> > ods.CustomerAddress.StateOrProvince,
> > ods.CustomerAddress.PostalCode,
> > ods.Account.Telephone1,
> > sum(ods.AccountITDDonationSummary.[LAST CASH GIFT]),
> > ods.AccountITDDonationSummary.[LAST CASH GIFT DATE],
> > sum(ods.AccountITDDonationSummary.[LG CASH GIFT]),
> > ods.AccountITDDonationSummary.[LG CASH GIFT DATE],
> > sum(ods.AccountITDDonationSummary.[ITD DONATIONS]),
> > sum(ods.AccountDonationFiveYearSummary.[Current]),
> > sum(ods.AccountDonationFiveYearSummary.LastYr),
> > sum(ods.AccountDonationFiveYearSummary.TwoYrsAgo),
> > sum(ods.AccountDonationFiveYearSummary.ThreeYrsAgo),
> > sum(ods.AccountDonationFiveYearSummary.FourYrsAgo),
> > ods.Account.InceptedOn, ods.Account.EMailAddress1
> > FROM
> > ods.Account
> > LEFT OUTER JOIN
> > ods.Account_MailSolicitations ON
> > ods.Account.MailSolicitationsId =
> > ods.Account_MailSolicitations.MailSolicitationsId
> > LEFT OUTER JOIN
> > ods.Company ON ods.Account.companyid =
> > ods.Company.CompanyId
> > LEFT OUTER JOIN
> > ods.Contact ON ods.Account.PrimaryContactId =
> > ods.Contact.ContactId
> > LEFT OUTER JOIN
> > ods.CustomerAddress ON ods.Account.AccountId =
> > ods.CustomerAddress.ParentId
> > RIGHT OUTER JOIN
> > ods.AccountThreeYearMonthlyDonationSummary ON
> > ods.Account.AccountId =
> > ods.AccountThreeYearMonthlyDonationSummary.AccountId
> > LEFT OUTER JOIN
> > ods.AccountITDDonationSummary ON
> > ods.AccountThreeYearMonthlyDonationSummary.AccountId =
> > ods.AccountITDDonationSummary.AccountId
> > LEFT OUTER JOIN
> > ods.AccountDonationFiveYearSummary ON
> > ods.AccountThreeYearMonthlyDonationSummary.AccountId =
> > ods.AccountDonationFiveYearSummary.AccountId
> >
> > WHERE
> > (ods.Company.CompanyCode = 'OB') AND
> > (ods.CustomerAddress.AddressNumber = 1)
> > GROUP BY
> > ods.AccountThreeYearMonthlyDonationSummary.AccountNumber,
> > ods.Account.CreatedOn,
> > ods.Contact.LastName,
> > ods.Account_MailSolicitations.MailSolicitations,
> > ods.Account.NameLine,
> > ods.Contact.FirstName,
> > ods.Contact.Salutation,
> > ods.CustomerAddress.Line1,
> > ods.CustomerAddress.Line2,
> > ods.CustomerAddress.City,
> > ods.CustomerAddress.StateOrProvince,
> > ods.CustomerAddress.PostalCode,
> > ods.Account.Telephone1,
> > ods.AccountITDDonationSummary.[LAST CASH GIFT DATE],
> > ods.AccountITDDonationSummary.[LG CASH GIFT DATE],
> > ods.Account.InceptedOn, ods.Account.EMailAddress1
>