Hi, Below is the table structure Companyname Co_create_date Address City State Companyid I need the count of distinct company name in day wise...
Hi, I need to extract the date in day wise format like Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 .............. 31 2005 X X...
Any updates
Hi dineshasanka, Thanks for you answer. Regards Rajneesh
Hi Kenneth, Thanks for your update. Order does not matter. Regards Rajneesh
Hi Franklis, Before generating eCoupons i have to check the duplicacy with the existing one that already generated in the system and to get the 14...
Hi Keneth, Before generating eCoupons i have to check the duplicacy with the existing one that already generated in the system and to get the 14...
if i used the to extract the 14 characters from the newid then it will not be unique everytime and another thing is that i need to filter from...
Table A Userid, Group_type(A or B or C or D or E) ,Firstname, Lastname,email,addr1,addr2. Regards Rajneesh
I have a table containing some records group wise. A - 100 records B - 100 records C - 100 records D - 100 records E - 100 records I need to...
HI, I need to convert the rows into columns, i tried to do it by crosstab queries but the problem is the result i need on the basis of some...
Hi Guys, Thanks for your update. I cannot use GUID becuase the random numbers are fixed for 20 alpha numberic characters and first 6 characters are...
I have created one asp file for generating random number with the format XXXXXX-XXXX-XXXXXX-XXXX (where first six character are fixed). Problem : I...
Separate names with a comma.
