No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi, I have stored "DateTime" format in the database, but i need only "date" at the time of retrive. How to do this? Please help. Thanks in advance. Satees
|
|
|
could anybody help to create autocomplete dropdown box with editable, whatever we typing in dropdown box it should show dropdown of the control, in my project i filled the dropdown box by store number from mysql database, For Eg., if i will type "43" it should show all stores starts …
|
|
|
SELECT Stores.strStoreName, (CASE WHEN T.intItemID=S.MinSub THEN Stores.strLogo ELSE NULL END) AS displayCategory, T.txtDescription FROM Items AS T INNER JOIN Stores ON T.intStoreID = Stores.intStoreID, ( SELECT intStoreID , Min(intItemID ) AS MinSub FROM Items GROUP BY intStoreID ) AS S WHERE T.intStoreID = S.intStoreID ORDER BY T.intStoreID, T.intItemID The SQL … |