Viewing 15 posts - 1 through 15 (of 81 total)
ankurk2 (11/23/2011)
"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...
November 23, 2011 at 9:18 pm
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...
July 14, 2010 at 11:46 pm
dots67 (10/16/2007)
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...
April 8, 2010 at 3:22 am
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.
April 7, 2010 at 8:53 am
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...
April 5, 2010 at 1:22 am
thx Debby, You saved lot of time for me. even i was fighting with rs and MSDN for this 🙂
December 29, 2009 at 12:41 am
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...
June 2, 2009 at 11:45 pm
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...
January 18, 2009 at 11:12 pm
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, 😉
December 3, 2008 at 9:32 pm
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...
July 25, 2008 at 7:44 am
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
August 28, 2007 at 8:24 am
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...
August 27, 2007 at 11:13 pm
Any one tried QlikView ? http://www.qliktech.com/Home.asp?id=4
jeswanth .
April 26, 2007 at 1:25 am
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...
June 27, 2006 at 10:00 am
Hi
Thanks Eddie. your feed back was really help full.
Thanks
Jeswanth Jaishanker
May 24, 2006 at 7:34 am
Viewing 15 posts - 1 through 15 (of 81 total)