Recent content by zeeshanmbutt

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

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

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

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

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

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

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

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

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

Thanks :D... You are great ;)

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?

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

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

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

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