Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sunila7

  1. sunila7

    simple query help

    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...
  2. sunila7

    Picking out alternative names in duplicate rows

    Take a look at this Thread thread183-1418216 Sunil
  3. sunila7

    How to get windir, %temp%, etc

    %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
  4. sunila7

    Number of days in a month excluding weekends

    And another from me :-) Sunil
  5. sunila7

    Sendkeys to Webpage

    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
  6. sunila7

    Links to PDFs stored in DB

    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
  7. sunila7

    Question about select count(*) from "@table"

    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...
  8. sunila7

    Dynamic textbox error Collection was modified; enumeration operation

    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
  9. sunila7

    Dynamic textbox error Collection was modified; enumeration operation

    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...
  10. sunila7

    Dynamic textbox error Collection was modified; enumeration operation

    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...
  11. sunila7

    Is there a way to create a Text File from a SQL Table using SP?

    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
  12. sunila7

    Question about select count(*) from &quot;@table&quot;

    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
  13. sunila7

    Is there a way to create a Text File from a SQL Table using SP?

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

    returning a list of records

    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
  15. sunila7

    returning a list of records

    Take a look at this thread. thread183-1159740 Sunil
See more

Part and Inventory Search

Back
Top