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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. e106199

    using sql to make several calculations

    Hi all, i had another problem about the thread. In my last question i asked if its possible to use a second select in the first one because what i was trying to find was the count of all rows that satisfies a specific criteria. I got it working to some point but now i realized the group by date...
  2. e106199

    using sql to make several calculations

    Nevermind, i got it. i was trying a select in count, having count in select solved the problem. its like; select col1, (select count(*) where col2='abc') as abcrows .... -shane
  3. e106199

    using sql to make several calculations

    By the way, i cant use the statement in where clause because i have several of them. i wnat to find the count of abc rows, and def rows ... -shane
  4. e106199

    using sql to make several calculations

    One more thing guys, now i have a situation where i have to find the count of all rows which has a column like "abc". i tried using count but how can i write a like statement in count? it will be like: select count (col1 like 'abc') as abcrows i know the syntax is wrong. any ideas? thank...
  5. e106199

    using sql to make several calculations

    thanks so much, i think i got it working -shane
  6. e106199

    using sql to make several calculations

    about the select statement: the getdate() should be my date column, right? is it a mistake or does it have a role there? -shane
  7. e106199

    using sql to make several calculations

    in the stored procedure i ll create a temp table and set its columns from the select statement carlen stated, right? this is what i m asking. if i have a @tmp table with all coolumns declared, how can i set its rows from the select statement which calculates the sums and groups them. thank you...
  8. e106199

    using sql to make several calculations

    its not that i dont know anything about sql. but this is kinda new concept for me. ok i have a temp table with all columns declared. say the temp table has <month, c1,c2,c3,c4 > how do i set the rows with what i get from: select right(convert(char(11),getdate(),13),8)...
  9. e106199

    using sql to make several calculations

    jbenson001, this is what i m asking for. how can i create this stored procedure? basically it will take start date and end date as parameters and return me all the column totals grouped in months. thanks, -shane
  10. e106199

    using sql to make several calculations

    no there is no id column, is it necessary in such scenerio? actually this is not a table. its a view. thanks for the answers, sorry for being a pain but can this be a stored procedure so i can create a datatable from it and bind it to my grid. if so how? thank you -shane
  11. e106199

    using sql to make several calculations

    hi all, i had a request about creating a grid type report which will show the result of several calculation of my db fields in .NET section and a good suggestion was to use sql for this. So sql will make all calculations and i ll show the results in a grid. The problem is i dont have much...
  12. e106199

    report type grid???

    i dont feel myself confident with sql that much. is there an example or tutorial that will guide me? or can you please send a code sniplet thank you -shane
  13. e106199

    report type grid???

    and how would you solve grouping by month problem? -shane
  14. e106199

    report type grid???

    hi all i have such scenerio: i have my data in db and i will be creating a report. the first column of the report will keep the number of some item, second column will be the number of another item etc. so there is no tabular data, i have several calculations and the tricky part is i have to...
  15. e106199

    how can i create a custom grid type output?

    Hi all, I have a case where i have to show some data along with some custom columns derived from other data. Here is an example: in my database i have 5 columns but i dont want to show them the way they are. I want to show 5 of them and use the rest 2 to create 2 custom columns. the output...
  16. e106199

    showing formatted text in textbox

    No i dont want to use a third party tool that is adding at least 100K over the current page. i think i ll go with label. thanks, -shane
  17. e106199

    showing formatted text in textbox

    i gave the bold as an example. i have many html statements coming from the database. -shane
  18. e106199

    showing formatted text in textbox

    hi, i have html formatted text coming from my database and i want to show it as formatted in a textbox. assigning it to a label works fine but getting the db content in a textbox gets the html text, not the formatted text. Ex: <b> test </b> shows as it is and i want to show a bold "test" in...
  19. e106199

    What am i doing wrong?

    Hi all, i have a bunch of checkboxes (not checkbox list for some reason) and i collect all their data under a field. So if user selects cbA and cbC; A,C is sent to database. Now i want to load my form so user can make some changes. Everthing works fine but i m doomed with the checkboxes. Here...
  20. e106199

    Using transaction for update and insert

    Hi, i will be doing an update then an insert so i want to use the transaction to make sure if one fails the other wont do what its supposed to do. But there is a little problem, in my insert function i call the update function first. How can i run the same transaction while calling a function...

Part and Inventory Search

Back
Top