Recent content by sunila7

Can you use standard deviation to figure out the variance? SELECT ID, STDEV(Value) FROM (SELECT 1 ID , 100.12 Value UNION SELECT 1 , 100.24 UNION SELECT 1 , 100.35 UNION SELECT 2 , 300.12 UNION SELECT 2 , 100.14 UNION SELECT 2 , 300.35 UNION SELECT 3 , 10.12 UNION SELECT 3 , 10.24...

Take a look at this Thread thread183-1418216 Sunil

%windir% and %temp% are environment variables. This can be found in HKEY_LOCAL_MACHINE \SYSTEM \CurrentControlSet \Control \Session Manager \Environment location in registry.. Hope this helps. Sunil

And another from me :-) Sunil

I am not sure if you are looking for testing the site you are developing. But this library allows you to automate for web browsers. http://wtr.rubyforge.org/ Sunil

We used custom HTTP handlers for images in one of our applications so that someone cannot directly type the URL for an image and download it. We did something similar to the example shown here in this link http://www.uberasp.net/getarticle.aspx?id=13 Sunil

How about this? DECLARE @SQLString nvarchar(2000), @paramList nvarchar(1000), @RtnCount int DECLARE @thisTable varchar(50) SET @thisTable = 'Persons' SET @SQLString = N'SELECT @RtnCount = COUNT(t1.PersonsID) FROM ' + @thisTable + 't1 INNER JOIN Students ON...

A control inside the gridview will get a ASP.Net generated name while HTML is being rendered. If you want to access the controls inside you will have to use FindControl method of GridViewRow. Sunil

Yes you can add what ever controls you want in a grid view. Drop a GridView control on the page and look at the columns HTML tag inside it. You can have TemplatedFields which can contain any control you want. Here is a link. http://geekswithblogs.net/azamsharp/archive/2005/10/05/56183.aspx...

Why are you not a using a repeater control to do this? Try the code(not tested) below not sure if this code below will work. Response.Write("<tr><td width='250px' class='bodylist'>") Response.Write("<font color='darkblue' size='1'>" & DRClassics(0)) Response.Write("<td...

Yes I have used it before. Take a look at this link. http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/ Sunil

To return data that you want to use later when using dynamic SQL use sp_executesql Here are a few links. http://support.microsoft.com/kb/262499 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41413 Sunil

Take look at BCP command. Here is a link to it. http://msdn2.microsoft.com/en-us/library/ms162802.aspx Sunil

Can you give us some sample data and expected results? and if you have written a function then that code will also be useful. Sunil

Take a look at this thread. thread183-1159740 Sunil