Getting Started with Adobe After Effects - Part 6: Motion Blur
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Friends

My Badges

Request Friendship



Upload Image

My Sections

My Activities

Blogs22
Pages1
vmanfredi
1116 · 0% · 23

vmanfredi's Home

My name is vmanfredi.
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    That worked perfect...Thanks...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    where would i put the cast statement?...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    I just noteced the tran amount is a Float data type...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    Thanks When I ran it the results below came out for this group of tranactions . the sum of the tran_amount should come out to 0 ACCOUNT TRAN_NUM TRAN_SEQUENCE TRAN_AMOUNT REMAIN_BALANCE STATUS COMMENT SEV002 147773 0 36141....
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    here is the result Account Tran_Num Tran_Amount Remain_Bal Diff 3gg001 P071009 -40274.16 0 0 ALP002 P071009 -77556.10 0 0 RSR001 180986 ...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    Hi here is the data. I need to sum the tran amount and compare to the remain balance for the 0 tran_sequence record. Notice the account can change but tran num stays the same. print(Account tran_num tran_sequence Tran_Amo...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    Hi No matter what I do o cant get the code sample to format correct...
    Madhivanan JR
    3 · 40% · 12958
  • Dynamic PIVOT in SQL Server 2005

    vmanfredi Commented 2 Years ago through Blogs
    Hi I think I need to use pivot here I was wondering if you could help I need to compare a sum of multiple rows to the sum of a single row. Thanks for your help!!! I need to comapre the sum of tran_amount where the tran_seq is > 0 to the remainin...
    Madhivanan JR
    3 · 40% · 12958
  • Multipurpose Row_Number() Function

    vmanfredi Commented 2 Years ago through Blogs
    Hi again. You have been so helpful I want to thank you again. Everything I have tried to over come this issue has not worked so I want to try a diffrent approach. How would I write a trigger on a table that would fire on insert and create the correc...
    Madhivanan JR
    3 · 40% · 12958
  • Multipurpose Row_Number() Function

    vmanfredi Commented 2 Years ago through Blogs
    oh yes everything you gave me before works perfectly. This is a new wrinkle where Now there can be the same tran_num spread out over several diffrent accounts. So I need to find the max tran seq not only by tran num but now by account. See one account c...
    Madhivanan JR
    3 · 40% · 12958

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.