Search Results - VBForums

Search:

Type: Posts; User: sapator

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    13
    Views
    218

    Re: help on count rows.

    I get 0 on every percentage line.Tech, ok forget the percentages for now and everything else, as this is getting very complex for me.
    I have shorted everything i guess and the only problem i have is...
  2. Replies
    13
    Views
    218

    Re: help on count rows.

    Tech this will bring zero percentages and also i am trying to have the >5 value on top but anyhow if this too much to ask i would probably cut this down inside VB.NET.
  3. Replies
    13
    Views
    218

    Re: help on count rows.

    IanRyder that is great except i get zeros on percentages.
    Tech looking at this now will post back...
  4. Re: perventage of specific film issues.

    DAMMIT!


    SELECT Cinema_DisplayName,
    Sum(Admissions) AS Admissions
    ,(select sum(Admissions+CoolAdmissions) * 100) / (Select sum(Admissions+CoolAdmissions) From ZZ_vwpProgressBoard...
  5. [RESOLVED] perventage of specific film issues.

    Hi, pulling my hair here. I want to get the percentage of a specific film but what i get is 100 in all rows.


    SELECT Cinema_DisplayName,
    Sum(Admissions) AS Admissions
    ,(select...
  6. Replies
    13
    Views
    218

    Re: help on count rows.

    Hi. I think you meant CROSS APPLY Totals T instead of CROSS APPLY Totals A ?
    Also this will put the not top 5 film result, randomly somewhere in the rows. How would i go and pull it to the last or...
  7. Replies
    13
    Views
    218

    Re: help on count rows.

    Hey.
    Ideally i would like to see. sum total , sum admissions, sum cooladmissions , percentage.
    By percentage i mean the portion, percentage that all the above sum has in the the total or the WHOLE...
  8. Replies
    13
    Views
    218

    Re: help on count rows.

    Hi. Thanks, can i sum this up? something like:


    SELECT sum(admissions) as admissions from(
    SELECT TOP (100) PERCENT --dbo.ZZ_vwpProgressBoard.Film_strTitleAlt,
    Sum(Admissions +...
  9. Replies
    13
    Views
    218

    help on count rows.

    Hi. SQL 2005.



    SELECT TOP 5 Film_strTitleAlt
    FROM ZZ_vwpProgressBoard
    GROUP BY Film_strTitleAlt
    ORDER BY Sum(Admissions+CoolAdmissions)desc
  10. Runnvarchar manually no variable improve speed

    Hi. I am having this query


    DECLARE @DateFrom as DateTime,
    @DateTo as DateTime



    SET @DateFrom =...
  11. Re: align image in table after text.

    Turns out i wouldn't be needing it but i remember to look for outlook issues next time.
    microsoft :(
  12. Replies
    7
    Views
    232

    Re: conver datetime to varchar give only "1"

    I know man, wasn't my query in the first place.A little to much SQL these days but i prefer it 10000 times than doing MVC.
    Will have a look at this the day after since it's a national holiday today.
  13. Replies
    7
    Views
    232

    Re: conver datetime to varchar give only "1"

    Hi. Yes and i think the issues here is that the original "SET @DateFrom = CONVERT(DATETIME,CONVERT(VARCHAR,DATEADD(hh,-6,getdate()),101))--CONVERT(DATETIME,CONVERT(VARCHAR,GETDATE()-1,101))" is...
  14. Replies
    7
    Views
    232

    Re: conver datetime to varchar give only "1"

    Oh dammit!
    Thanks.
    So another issue here.
    If i do this:

    DECLARE @DateFrom as DateTime,
    @DateTo as DateTime
    declare @datetimefromnv as DateTime
    declare @datetimetonv as DateTime
  15. Re: Very strange time difference in 2 sprocs run through another sproc.

    Thanks, cannot find the issue, however today we changed the sproc (eliminating a 1.900.000 rows table) so everything run fine.
    Problem is that this is used elsewhere with the big table so the...
  16. Replies
    7
    Views
    232

    conver datetime to varchar give only "1"

    DECLARE @DateFrom as DateTime,
    @DateTo as DateTime
    declare @datetimefromnv as varchar
    declare @datetimetonv as varchar


    SET @DateFrom =...
  17. Re: Very strange time difference in 2 sprocs run through another sproc.

    Execution of the create and fill table took even longer on the database that has NO issues. (problematic db 2 minutes, Non problematic DB 2:30 minutes).
  18. Re: Very strange time difference in 2 sprocs run through another sproc.

    Ok, asked there. Leaving this open to post a solution, if found.
  19. Re: Very strange time difference in 2 sprocs run through another sproc.

    I will give it some tries and if i can't find anything i will ask to that forum.
    Thanks, and the sage continues...
  20. Re: align image in table after text.

    What about this?
    .tg td:nth-child(2){border-right:none}
    .tg td:nth-child(3){border-left:none}
    Is it viable?
  21. Re: Very strange time difference in 2 sprocs run through another sproc.

    So basically with top 10 to 100 rows every sproc runs in almost the same time, if i lift it up to 1000 then i start see differences.
    I don't think that the problem is in the sproc. It's the same...
  22. Re: Very strange time difference in 2 sprocs run through another sproc.

    Hi no selecting top will run fast but it's a complex basterd and i need , at least until i can figure out and re-fix the complete query.
    although this runs fine and fast on every other similar...
  23. Re: Very strange time difference in 2 sprocs run through another sproc.

    Hi.
    Yes it goes to different machines


    exec(
    'EXEC ' + @Server + '.VA.dbo.' + @Procedure + ' ' + @Parameters + '
    INSERT INTO ' + @LocalTable + '
    SELECT * from ' + @Server + '.VA.dbo.' +...
  24. Re: Very strange time difference in 2 sprocs run through another sproc.

    The caching solution does not seems to work. The query runs slow even on the first try and on any other try.
    Could this be something else?
  25. Re: align image in table after text.

    Also i want not to show the vertical line between tezt and image:
    text image and not text | image .

    I hope border =0 will do that?
  26. Re: align image in table after text.

    I am not sure i can use that since this will be a simple html, imported in a string in VB and send to outlook.
    I was hoping for a simple solution but i think making a 3rd td is the only viable. :/
  27. Re: Very strange time difference in 2 sprocs run through another sproc.

    The problem is on 2 out of 8 DB's. My colleague run a server restart late at night and the problem was solve on one server today. He will do another restart tonight on the othe server to see what we...
  28. [RESOLVED] align image in table after text.

    Hi. I just need to have a <td>texttttt <image> </td> but i need the image to align in the same horizontal position in every td

    so i need that:

    Textextextext IMAGE

    textt IMAGE

    to be like
  29. Very strange time difference in 2 sprocs run through another sproc.

    SQL 2005.
    So what i have here is 2 exact same sprocs that will run on 2 different servers doing the same amount of time, give or take. When i use a sproc to run them. The first sproc will do 1...
  30. refreshing on crystal reports with a stored procedure.

    Hi.
    I am refreshing VS2008 reports. So what i want to do is create just a report(file), that will be integrated to another program.
    Mssql and no vb code.
    I create a new crystal report project, i...
  31. Replies
    24
    Views
    501

    Re: How does this make you feel

    Cool car, totally against the "legal" limit...Oh and carmageddon, what a lovely game, i was melting pedestrians screaming die dieeeeeeeee muhahaaaarrrrr( arrrgggg united - bridge of death)!!!!!
    If...
  32. Replies
    138
    Views
    7,291

    Re: Will Microsoft carry you over the Threshold?

    Yes, does anyone got a project from a client on Wmobile?
    I guess there is no need to create apps on something that is destined to fail.
  33. Replies
    138
    Views
    7,291

    Re: Will Microsoft carry you over the Threshold?

    As a first look (mind you i really did not bother for an extensive look) they are out of their minds. They don't really know what to do. They have tried to incorporate W7 back again but keep the W8...
  34. Replies
    17
    Views
    787

    Re: I want to learn C#

    Ah, i show that. Regardless I still prefer the good ol' VB way. Who though the double clicking on an textbox i wonder.
  35. Replies
    11
    Views
    313

    Re: [RESOLVED] SQL 2012 to SQL 2005

    I has serious issues with SQL2012 yesterday. I run a select and the whole management stuck and the minimize box was doing like a flashing light. I have 2008R2 and 2012 at home and i don't see any...
  36. Replies
    5
    Views
    250

    Re: A space issue in Outlook

    "A space issue in Outlook! " , that, sounded like a good Sierra adventure title. :)
  37. Thread: CSS Tutorial

    by sapator
    Replies
    7
    Views
    345

    Re: CSS Tutorial

    Ye not my cup of tea. I am at stick people drawing when it comes to design but i have to do some sites, so i just "borrow" stuff or free templates.
  38. Replies
    11
    Views
    313

    Re: [RESOLVED] SQL 2012 to SQL 2005

    What's wrong with 2005? There were major changes from 2000 to 2005 and is my favorite server along with 2008R2.
  39. Re: ASP.Net 4.5 is JQueryUI included by default

    I just realized that this should fit better in the html - Javascript thread. Now if i could just find a mod to report it to and possibly ask him to pass my complaints to funky...Hmmmm.....
  40. Re: ASP.Net 4.5 is JQueryUI included by default

    The pre writing is not like desktop apps, meaning you don't need to blob the page with useless JS that will generate on run and fill the assembled page with lines of code ( you can take a look at...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.