ankurk2 (11/23/2011)

---

Anyone got it working with multiple values of parameter? I get this error:

"Error during processing of the ConnectString expression of datasource ‘xxx’."

conn string: ="Data Source=206.17.24.23;Initial Catalog="+Parameters!CountryName.Value

For single...

Dear Stephen,

How does this improve the query speed when the previous 3 hour sql and current 15 seconds sql actually querying diffrent tables and views?

Wondering why your team waited...

dots67 (10/16/2007)

---

>there are a lot of full scans going on

Then why are you surprised that CPU is so high?

There is no silver bullet or settings like

SET CPU_UTILISATION LOW

SET SQL_SERVER FAST

🙂

You...

yes you can , but all teh sqls in data set shluld be stored procs. then u can pass username and password as a parameters to the report.

Hi,

not sure where u want to load teh list of sql servers in a list box, if its supports .net language u can ue sql serevr smo and there are...

thx Debby, You saved lot of time for me. even i was fighting with rs and MSDN for this 🙂

Hi Edvassie/Crazy Man,

Thanks for the replies, as i am from a developmet background dont have much knowledge in Implementation aspect of the SQL Server, So googling for all teh methodologies...

Hi,

if you are creating a stock report like Opening Balance in the first row and daily transactions below and at the end Closing Stock, you can create a functioon which...

This is an old questin which used to give problem in the SQL server 2000 Query Analyzer, looks like in 2005 editor this error is handled, 😉

Hi ,

I am not sure if your problem is solved or not as i dindt have teh patience to read all the replies ;), the Problem description just caught...

the stress should be on performance and related topics than readability. for readability use comments in code. something like

SELECT fld1,fld2 FROM Orders where PaymentType = 1 -- VISA

Regards

Jeswanth

Hi,

i feel instead of bringing one more join to sql its better to declare some variables inside the stored procedure and use it instead of bringing the enum concept forcibly...

Any one tried QlikView ? http://www.qliktech.com/Home.asp?id=4

jeswanth .

forgot to one more detail.

The execution plans are diffrent when i use where empid = 1 and

inner join.  Is there any way i can use teh same execution plan for the...

Hi

Thanks Eddie. your feed back was really help full.

Thanks

Jeswanth Jaishanker