shahab (5/20/2008)

---

I am using following query to build a table. right now this query takes about 3 hours. which is way too long. I see that in the execution plan...

ideally, you should transform the doc before processing it and use XSLT's position() to generate the desired attribute.

i've become very dependent on this:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER function [dbo].[fListToVarchars]( @list varchar(max), @delim varchar(6) )

returns @returnTable table

( item varchar(255) not null, itemSequence smallint not null )

as begin

declare...

a.thomson2 (5/19/2008)

---

Hi All,

I have a Select Statment, which as far as my knowledge goes with SQL should work, the issue seems to be the SPC expression;

ISNULL(CONVERT(DECIMAL(5,2),(SUM(CONVERT(NUMERIC,CRC.Success))/(SUM(CONVERT(NUMERIC,CRC.Contact))))*100),0) As SPC

The fields used...

try something like this:

select O.optionId, O.optionName, O.optionDesc,

case when S.optionID is null then 'N' else 'Y' end as isChecked

from Options O left outer join SelectedOptions S

...

:Niraj,

there are two levels of authentication: one for the database and one for the /ReportServer virtual directory. i assumed your issue was the db connection but if you've embedded...

If you're using SQL Server Authentication to connect to the db, edit the dataset and on the general tab, click [Edit] and ensure 'Save my password' is checked.

If you're using...

Don't feel bad... the report designer is a weird beast and things that should be straight-forward seem to be counter-intuitive. You'd think that right-clicking a row handle would present...

by default certificates don't identify anyone. you'll have to configure IIS to accept client certificates and map them to local user accounts (or come up with your own authentication...

michael.rogers (5/15/2008)

---

[font="Courier New"]SELECT REGISTRATION_NO, ODO_READING_KM as NextReading, READING_DATE, TRANSACTION_MONTH

FROM COM_ODO_READINGS

WHERE TRANSACTION_MONTH BETWEEN DATEADD(MONTH, 1, CAST((CAST(@StatusDateYear as VARCHAR) + '-' + CAST(@StatusDateMonth as VARCHAR) + '-01 00:00:00.000') AS DATETIME)) AND...

assuming 'ticker' is a stock trading symbol, then a firm can certainly exist without a 'ticker'. tickers would be somewhat independent of firms since they can be reused (especially...

Michael Earl (5/14/2008)

---

Interesting that you think that is simpler. It makes a circular reference - meaning you cannot insert the Firm record without already having a Firm/Ticker record to...

select year(getdate()) * 100 + datepart(week,getdate()) as year_week

Personally, I'd keep it simple and add primaryTicker to the Firm table. Then a simple fkey relationship will meet your business rules and it should be dead simple for...

create a log table, and have the proc write the parameters it receives to the log. you're probably not getting what you expect.

also, if you only have 2 roles,...