Recent content by mrgulic

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...