Search results for query: *

I use the following to sort text containing strings and integers naturally Current .OrderBy(x => x.some_class_property_string, new OrdinalStringComparer(true))) I have been trying to create an alias (I hope I am using the correct terminology) so I can centralize and end up doing the...

Thanks Feherke, that did not occur to me.

I wrote the following to enable/disable elements, and it works fine. jQuery.fn.enable = function (enable) { var $this = $(this); if (enable) { $this.removeAttr("disabled"); } else { $this.attr("disabled", "disabled"); } }...

I would have posted to an Oracle forum except that out of the following I didn't see one that was the equivalent of or close to "Microsoft SQL Server: Programming Forum". Oracle: Oracle release - 9i and earlier Oracle: Oracle release 10g Oracle: Oracle release 11g Oracle certification and...

I had to make the following change from: ,DECODE(COALESCE(t1.REOPEN_FLG,T2.REOPEN_FLG), '1', 'true', '0', 'false') AS REOPEN_FLG to: ,COALESCE (DECODE(t1.REOPEN_FLG, '1', 'true', '0', 'false'), DECODE(t2.REOPEN_FLG, '1', 'true', '0', 'false')) AS REOPEN_FLG as I was getting the following...

One small issue.............I didn't include my condition statement.....and when i added that on i received null results. SELECT COALESCE (t1.TESTGROUP, t2.TESTGROUP) AS TESTGROUP, COALESCE (t1.APPROVER, t2.APPROVER) AS APPROVER, COALESCE (t1.LEVL, t2.LEVL) AS LEVL, COALESCE (t1.TYPEREPORT...

Thanks Frederico, I didn't know what dual was, thought is was one of your tables. Works great.

Thanks for your reply fredericofonseca but when I was finally able to get your query to work it output thousands of null records when none existed and the same when one did exist. select coalesce (t1.TESTGROUP, t.TESTGROUP) as TESTGROUP, coalesce (t1.APPROVER, t.APPROVER) as APPROVER from...

I tried your suggestion but i get an error. If Exists(Select 1 From Table) SELECT TESTGROUP, APPROVER, LEVL FROM [APPROVAL] Else SELECT '0' As TESTGROUP, NULL as APPROVER, NULL As LEVL ; Perhaps I have the syntax wrong, but I have never used If Exists, so I am in unknown territory. Here...

Thanks for your reply, but there where no results returned.

The following query SELECT column1, column2, column3 FROM [table1] UNION ALL SELECT '0',NULL,NULL FROM [table1] HAVING COUNT(*)=0 in MSSQL it will produce the following results (which i will display as comma separated values) when there are no records 0,NULL,NULL if there are records then...

Thanks, I found a solution when I found out that Textcopy was obsolete. Install Adobe IFilter (verify that it is installed) SELECT * FROM sys.fulltext_document_types Crate table. you can call the columns whatever you like. CREATE TABLE [dbo].[Blob]( [BlobFileId] [int] IDENTITY(1,1) NOT...

I have installed every single component for SQL Server 2008 R2 Developer Edition except for Reporting and Analysis Services and textcopy.exe is nowhere to be found. Everything I have read says it should be under C:\Program Files\Microsoft SQL Server\100\Tools\Bin\ or C:\Program...

The WHERE condition is NOT static. The statement used in SMS was for example purposes.

I have a GridView (populated by MSSQL) that displays information about order line items. Each Line Item is part of an Order and each Order belongs to a Project (3 tables). The GridView has several DropDownList's that filter the GridView results (based on user selection). I am currently...

If this is what you meant protected void ibtnSharePath_Click(object sender, ImageClickEventArgs e) { HyperLink h = new HyperLink(); h.Text = "test"; h.NavigateUrl = lblRoot.Text; } then no, it didnt work. The end URL I saw when debugging...

I don't know that this is the best way to occomplish my task but I wanted to share how I did it nonetheless. System.Diagnostics.Process.Start("explorer.exe", lblRoot.Text); This also work's, but it appears to open the explorer window behind IE, instead of out front...

My app retrieves all servers on the domain and populates a listbox with the server name. When server is clicked in the listbox, the shares on that server is listed in another listbox. When the share listbox is clicked, details about the share is displayed in labels, etc. What I am trying to do...

Of course after several days of searching for an answer, a few hours after posting something here and a small change in the seach string on google yeilds positive results. I needed the following added to my filter ("objectCategory=Person") So i changed this: searchADS.Filter =...

I have the following code that i use to search for users in the domain. When I enter a complte user name it finds it but when i use wildcards and gets even computer names that contain the string too. How to i filter for only only users? There has to be some flag that indicates a AD objct is a...