Database

FirstPrevNext

Re: sql statement in microsoft access to include IIF statement johnnysmith18-Jun-09 15:33 johnnysmith1 8-Jun-09 15:33  thank you it works Re: sql statement in microsoft access to include IIF statement Blue_Boy8-Jun-09 21:09 Blue_Boy 8-Jun-09 21:09  You are welcome. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Identity Column.... Isaac Gordon6-Jun-09 0:45 Isaac Gordon 6-Jun-09 0:45  Hi Experts How to alter Column To On Identity on Column i am try this but not working ALTER TABLE TEST ALTER COLUMN iD IDENTITY (200, 2) Re: Identity Column.... Aman Bhullar6-Jun-09 1:44 Aman Bhullar 6-Jun-09 1:44  Sharma Dinesh Kumar wrote: How to alter Column To On Identity on Column ALTER TABLE Foo ALTER COLUMN FooKey ADD CONSTRAINT IDENTITY(100,1) Regards Aman Bhullar www.arlivesupport.com[^] Re: Identity Column.... Isaac Gordon11-Jun-09 23:42 Isaac Gordon 11-Jun-09 23:42  This is not Working Give Me Error on CONSTRAINT Re: Identity Column.... nhughes21117-Jun-09 14:32 nhughes2111 7-Jun-09 14:32  Does anyone have any ideas? HOW TO EXPORT CRYSTAL REPORT WITH IMAGE kruti.support5-Jun-09 19:42 kruti.support 5-Jun-09 19:42  Hi friends I m getting replicated images when I export crystal report having images in Word,PDF,Rtf etc. Kindly suggest solution Re: HOW TO EXPORT CRYSTAL REPORT WITH IMAGE Mycroft Holmes6-Jun-09 4:23 Mycroft Holmes 6-Jun-09 4:23  And the relevance to a database is? Never underestimate the power of human stupidity RAH Help with SQL in MS Access xx77abs5-Jun-09 1:28 xx77abs 5-Jun-09 1:28  Hello ! I'm doing little project and I need database for it, but not whole server. So I choose Access ... But that's pain in the a** I have a relatively simply query in which I need to do LEFT JOIN: SELECT a.*, b.* FROM a LEFT JOIN b ON (a.pid = b.pretplatnik_id) AND (a.iid = b.izdanje_id); a and b are booth some other queries. I needed to do this because I can't do query inside a query in access And there's problem. It all works, except it shows only data from query a and nothing from query b. Everything from b is NULL. Interesting thing is that if I change part "LEFT JOIN" to "INNER JOIN" it returns booth results from query a and b. So does anyone have an idea why LEFT JOIN isn't working ? Thanks for your time and help Re: Help with SQL in MS Access Blue_Boy5-Jun-09 1:38 Blue_Boy 5-Jun-09 1:38  try to use LEFT OUTER JOIN I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Re: Help with SQL in MS Access xx77abs5-Jun-09 2:40 xx77abs 5-Jun-09 2:40  Thanks for help But it's not working Same result as just using "LEFT JOIN" Re: Help with SQL in MS Access Blue_Boy5-Jun-09 3:51 Blue_Boy 5-Jun-09 3:51  Well,if you don't mind then post here some tables data, and result which you want to get and we will try to give you hand on query. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Re: Help with SQL in MS Access xx77abs5-Jun-09 9:02 xx77abs 5-Jun-09 9:02  Thanks, but I've solved it In b query I've had GROUP BY statement, and it was something like SELECT blabla FROM bla GROUP BY pid, iid; Now I've changed it to SELECT blabla FROM bla GROUP BY iid, pid; and everything works ... Although I don't think there's any difference, but ok ... if there is, please explain it to me Re: Help with SQL in MS Access Blue_Boy5-Jun-09 9:14 Blue_Boy 5-Jun-09 9:14  It's possible to use DISTINCT instead of GROUP BY but when you had solution then let it as it is. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Re: Help with SQL in MS Access xx77abs6-Jun-09 2:46 xx77abs 6-Jun-09 2:46  Yes, but can I use distinct with two fields ? And I also did use SUM with GROUP, I think that I can't use sum with distinct ... Re: Help with SQL in MS Access Blue_Boy6-Jun-09 3:15 Blue_Boy 6-Jun-09 3:15  When you have case to use agregate functions then better use GROUP BY but still you can use DISTINC and with subquery you can get SUM or any else agregate function. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. Re: Help with SQL in MS Access xx77abs7-Jun-09 3:42 xx77abs 7-Jun-09 3:42  Ok, thanks. It's good to know sp_helpsubscriberinfo returns empty table on MS SQL 2008 Roland Bär4-Jun-09 23:43 Roland Bär 4-Jun-09 23:43  In my Application I use the stored procedure sp_helpsubscriberinfo. On a Microsoft SQL Server 2000 this works as it should. But on a SQL Server 2008 it returns me an empty table. This happens also through the SQL Server Management Studio, so it is no error in my Application. Has anything chaged in accessing/using this stored procedure? [Update] The return code of sp_helpsubscriberinfo is 0, means no error. The stored procedure sp_helpmergesubscription returns a non-empty table with the same user account. [/Update] Thanks for your help! Roland Hi! I'm a signature virus. Copy me into your sig file and help me spread! Follow your Euro notes in their tracks Is something wrong in this? RajpootRohan4-Jun-09 23:20 RajpootRohan 4-Jun-09 23:20  Hi to all, IIf(IsDBNull(reader.Item("Amount")), 0, Convert.ToDouble(reader("Amount"))) Can anyone tell me what is the problem in this line if any? Please its urgent. Waiting for your earliest response. cheers, sneha Re: Is something wrong in this? J4amieC5-Jun-09 0:22 J4amieC 5-Jun-09 0:22  Problem.... hmmm... do you get any error? What makes you think there's a problem? Only thing I can see is that you're not assigning the result to any variable... could that be it? Re: Is something wrong in this? Rob Philpott5-Jun-09 2:02 Rob Philpott 5-Jun-09 2:02  A description of the problem you're getting would help. Also the VB forum would be more appropriate. What SQL type is Amount? I'm not that well up in VB but in C# you'd get a compiler error due to the difference in type of the last two parameters in your iif. Regards, Rob Philpott. Re: Is something wrong in this? J4amieC5-Jun-09 2:55 J4amieC 5-Jun-09 2:55  Rob Philpott wrote: you'd get a compiler error due to the difference in type of the last two parameters in your iif I thought of that, but something tells me VB will be alot more foregiving. It will no doubt choose the right datatype depending on the phase of the moon raised to the power of the current millisecond, but only on tuesdays. Re: Is something wrong in this? musefan8-Jun-09 2:36 musefan 8-Jun-09 2:36  It also works of Thursday providing that it is the last Thursday in the month or the first if the number of days in the month is equal to that of the previous month... it's a lot more complex than you initially thought I'm afraid Life goes very fast. Tomorrow, today is already yesterday. How to encrypt SQL Server 2005 Database? A k ch4-Jun-09 21:49 A k ch 4-Jun-09 21:49  Hi frd's Our client needs that his data base should be encrypted. Here i want to encrypt data base in such manner that it should work normally from .net web application but when some one tries to open it in SQL server IDE it should not show raw data. Even password protection is also OK for me for .MDF and .LDF files. Help me please... Thanks & Regards, Anil Chelasani Re: How to encrypt SQL Server 2005 Database? Mycroft Holmes6-Jun-09 4:27 Mycroft Holmes 6-Jun-09 4:27  Here is some help[^] Never underestimate the power of human stupidity RAH

Last Visit: 31-Dec-99 18:00     Last Update: 19-Jun-24 16:35 Refresh ᐊ Prev1...838839840841842843844845846847 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.