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!

Recent content by zeeshanmbutt

  1. zeeshanmbutt

    how to grab first 20 words from the database

    wilsonfuqi, Sorry I did not notice that you are looking for words not characters.
  2. zeeshanmbutt

    how to grab first 20 words from the database

    Cant you use the left function get the first 20 characters. --Step 1 create table #mytable (Name varchar (100)) --Step 2 insert #mytable select 'John' union all select 'Anthony Queen 123456 789 111 76 583 2892 7624523 494' union all select 'Nicole Kidman 782 74d jdiefvnmf dghdhd...
  3. zeeshanmbutt

    Can we create a network between XP & Vista??

    akalinowski, I am talkling about XP professional & Vista Business versions here. Can you please comment? Or may be provide me with usefull links. Thanks,
  4. zeeshanmbutt

    Can we create a network between XP & Vista??

    Hi All, I dont have networking experience. But I need to know if it possible to create a net work between XP & Vista. The questions that I have are as follows: A) Is it possible to create a network between XP & Vista?. If yes than 1) Is there any limitation between the network for things that...
  5. zeeshanmbutt

    Converting Int to decimal

    gmmastros , Great it works... But can you explain me how its working? a)What this part does: (why we r multiplying it by 1): (1.0 * b.Totalunits/a.TotalUnits) b) What & how the convert part works? Also, in the same table T1 let say I have the following decimal field let (with Precision 18 &...
  6. zeeshanmbutt

    Converting Int to decimal

    How can I get this: Units, CatUnits,PercentDiff 192237'2510116,7.7 242537,2947050,8.3 128112,2183856,5.9
  7. zeeshanmbutt

    Converting Int to decimal

    Hi all, I have a Table T1 which has the following 2 fields: Units (int type), CatUnits (int type) T1 may has following records Units, CatUnits 192237,2510116 242537,2947050 128112,2183856 Now I want to get the % Difference of Units Vs CatUnits, which I can achieve by the following formula...
  8. zeeshanmbutt

    Help with a possible self join

    No, it doesn't give what I am looking for. I want to create a self join on Table1 to return the following fields: ZoneName,CatID,SaleDate,Sum(TotalUnits),Sum(DollarSales),Sum(Profit) Where its same: (that is the join should be on the following): ZoneName CatID OutletID How can I achieve...
  9. zeeshanmbutt

    Help with a possible self join

    Hi All, I have a table called Table1 with the following fields and types. ZoneName(nvarchar),OutletID(nvarchar),CatID(nvarchar),SaleDate(datetime),TotalUnits(decimal),DollarSales(decimal),Profit(decimal). Using the above Table1 I want to get the Sum(TotalUnits),Sum(DollarSales),Sum(Profit)...
  10. zeeshanmbutt

    Quick help with a select query

    Thanks :D... You are great ;)
  11. zeeshanmbutt

    Quick help with a select query

    Thanks again. It looks good. What if I dont want to see at per product level, rather I want see the diff price per zone, and per date only. That is what if I need only the following in my reslut set. saledate,pricezonename,TotalCnt,CountWherePricesDiff Any help?
  12. zeeshanmbutt

    Quick help with a select query

    AlexCuse, Thanks again. BUT shouldn't we also join on 'pricezonename' as well? Can you confirm & provide the correct query. Thanks a million...
  13. zeeshanmbutt

    Quick help with a select query

    AlexCuse, Thanks for your feedback. BUT how come the count for 'CountWherePricesDiff' is greater than 'TotalCnt'. It cannot be greater than 'TotalCnt' Can you please check?. Thanks a million....
  14. zeeshanmbutt

    Quick help with a select query

    Quick help with a select query Hi All, I have a table called #Tempp with the following fields & types. saledate(datetime),pricezonename(nvarchar),storeid(nvarchar),productid(nvarchar),SHPrice(decimal),PSPrice(decimal) This #Tempp have the following type of records...
  15. zeeshanmbutt

    Quick help with a cursor !!!

    gmmastros, I dont think you will understand the SP without have the Database/tables. But here it is anyway. Look the last part (Step X) which is creating the table PriceWithStoreCount$ which a cursor will use or possibly your function. Help needed desperately. Thanks a million... --Exec...
See more

Part and Inventory Search

Back
Top