Search results for query: *

In the thread184-1633357 I read about solutions but they don't seem to work for Excel 2010. The memo field is getting truncated. Do you know of any way to get Excel fully output the Memo field for Excel 2010? Thanks. PluralSight Learning Library

In the closed thread184-1624353 I found a reference to MS Forms 2 Textbox control. By specifying the ControlSource property of this control, I can display data (which are varbinary) just fine. My question is how to save the input data? Thanks. PluralSight Learning Library

In this thread184-1538957 I see a very interesting code posted by Mike Cagnon. However, it doesn't correctly determine the number of copies. Can someone please check it and tell, what has to be corrected? Thanks. PluralSight Learning Library

I am wondering if there is a way to figure out the maximum allowed size for the database using a query in SQL Server? As we know, the limit is 4GB for SQL Server 2005-2008 Express and 10GB for SQL Server 2008 R2 Express. I don't want to hard-code these limits, I want to be able to run a query to...

I see a similar topic discussed in this closed thread thread184-1586937 I do understand we can use a test file to find if the user has read-write access to the directory. I am wondering if there is another way to find this info (say, with Windows API functions)? PluralSight Learning Library

thread183-1268145 I thought I'll post a link to a great blog on this topic in case it helps someone [link ttp://blog.waldenl.com/2009/12/computing-md5-hash-of-varbinarymax-in.html]Computing MD5 for varbinary column using CLR function[/url] PluralSight Learning Library

Hi everybody, In reference to thread796-1250892 I need to find all possible formats for SaveAs dialog. I'm googling for 5 minutes already and nothing useful yet come up listing all possible formats. Found this http://www.rondebruin.nl/saveas.htm but only a handful of formats listed there...

I found this thread855-1169200 (which is closed). How can I get UserID without a trip to a database? Thanks. PluralSight Learning Library

Hi, When I right-click and select Beautify from the context-menu, I always have to select UPPER case instead of Mixed case. How can I make this setting persistent? Thanks in advance.

I see you published a new version of your article here http://www.sqlservercentral.com/articles/T-SQL/68467/ Congratulations!

I remember we had a discussion a while ago about CTE performance. Today's thread on MSDN http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/45c9f739-6aa2-4ffd-a9b3-69a8fb9b9be3 may help in understanding.

Re thread184-1538957 How can we use it with Report Listener? Thanks.

Hi everybody, I haven't worked with MySQL before, I worked with other databases (SQL Server, etc.). I have a task to remove all non-alphanumeric chars from the field. I've just installed MySQL tools, but I'm not yet sure how to connect to the server - need to check with my colleague here...

Hi everybody, I could not figure out this problem - I need to show parents with their children ordered by RightsOrder declare @Test table (pk_rights Int, fk_rights int null, RightsName varchar(max), RightsOrder smallint, Description varchar(max)) insert into @test select 1...

Hi, I have two tables - one has ConfigID CategoryID FeeDescription Amount Taxable Selected fields I have a subset for particular ConfigID and CategoryID in another table. I'm thinking what would be the easiest way to compare them both and update the main table based on the changes in the...

Hi, I'd like to be able to have a column in a grid bound to a logican field that would display "Yes or No". I also would like to be able to edit this field. If it would be only for display, it would not be a problem. Any ideas of how to make this field editable? Thanks.

Hello, I have a mover container class. It has 4 buttons (Move one, Move All, Remove One, Remove All) and also allows drag-drop. Move/Remove one calls this code * Move the highlighted entry in the source listbox to the destination listbox. This.parent.MoveOne(this.Parent.lstSource...

Hi, We have an application that sends appointments through MS Outlook using redemption to suppress the security warnings. Unfortunately, we seem to have a problem of items sitting in Outbox and not sent right away. We tried this code loFolder = loNameSpace.GetDefaultfolder(4) && Go to...

Hi everybody, I have a table called RouteDetail that has RouteDetailCategoryID field and nID Field. RouteDetailCategories table has an ID field and a cDescription field which is a table name. Currently there are 3 records only in the Categories table. My question is - how should I try to...

Hi everybody, I'm guessing I have an issue with Database RI model, because I'm working with the old application. Ok, here is the question. Is it possible conceptually this model Child1 FKField Parent PKField1 Child2 FKField2 Parent PKField2 --------------------------- In my case I have a...