adnan jan
Last Activity: Jan 23 '12, 04:29 PM
Joined: Jan 8 '12
Location:
-
Any help will be highly appreciated... -
avoid using Date() function from javascript as it works on the regional settings of the local machine which may result different output on different machines.Leave a comment:
-
LINQ TO XML get node based on multiple conditions
How can i get the node FieldName based on xID && dID through LINQ TO XML.
Note: dID may or may not exist.
...Code:<Configuration> <Contract xID="2"> <Document dID="227"> <FieldName name="AAAA"/> <FieldName name="BBBB"/> </Document> -
PLZ COMMENT IF I CAN IMPROVE ON IT
SELECT Temp1.User_id
FROM
(SELECT ur1.user_id FROM users_roles ur1 WHERE ur1.role_id = 82) AS Temp1 INNER JOIN
(SELECT ur2.user_id FROM users_roles ur2 WHERE ur2.role_id = 88) AS Temp2 ON
Temp1.user_id = Temp2.user_idLeave a comment:
-
thank you for an advice,,,i tried but it doesn't work,,,my required role ids are 82180, 82078, 22306Leave a comment:
-
Ms sql
how to get users having role (id 82 "AND" 88) it should not be "IN"
-1 88 NULL NULL
5771 82 NULL NULL
22306 82 NULL NULL
22306 88 NULL NULL
81973 82 NULL NULL
82072 82 NULL NULL
82078 82 NULL NULL
82078 88 NULL NULL
82177 88 NULL NULL
82180 82 NULL NULL
82180 88 NULL NULL
82186 82 NULL NULL
No activity results to display
Leave a comment: