1 Resources for

go select case

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Exploring the various uses of SQL's CASE keyword: SQL's CASE keyword is useful in a variety of situations beyond merely selecting custom columns. Discover how you can use CASE to deliver grouped and ordered result sets that you might have thought were impossible. The CASE keyword may be one of the most underused keywords in SQL....; Tags: SQL, Arthur Fuller, IS NULL, SQL Server Newsletter, TechRepublic Inc., Price, CASE, GO SELECT CASE, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-07-21

Additional Resources

Change Case for Excel (exe): Quickly and easily convert text between upper, lower, and proper case with this Microsoft Excel add-on tool. Simply select the text and then select the desired case from the menu bar. In just a matter of seconds Change Case will convert the text to the case you selected. Version 2...; Tags: Text, Microsoft Excel, Microsoft Office, Office Suites, Software; Software downloads 2007-06-19
VB problem: select case texttotal.textcase 40label1.caption="sssxx"case 50label1.caption="sddxx"case elselabel1.caption="ssbhx"end select in this vb prog. in the first time i ictivate the code, it skip the first line (case 40 ). it means suppose texttotal.text was 40, prog. should type in label1 as "sssxx". but at the first time...; Tags: label1.caption, Microsoft Visual Basic, programming, silvamsn@...; Q&A 2006-08-16
Excel change case in multiple cells to uppercase, (exe): Easily change the case of excel cells with the click of a button. Select the multiple excel cells that you wish to change the formatting for, and voila. The main features are select a group of cells from your excel spreadsheet to change the case for. Click on a button...; Tags: Microsoft Excel, Feature, Cell, File Splitter; Software downloads 2008-05-21
Very Simple Excel Empty Row Deletion: Ok, So, this doesn't fall under "Discussions" or "Questions" category, since It's simply a solution. A user at our workplace was having trouble with certain Crystal Reports generate excel sheets. There were about 1000 rows which were randomly empty. This is how I took care of it :- First, before...; Tags: ashij, cell, click ok, Make Sure; Discussion threads 2007-09-19

Maximising Business ROI: Syndicate 386 chose the Select Component Factory and the Select Process Director Suite to redesign and develop their core administration systems. The business case for the redevelopment of the applications was two-fold, firstly to move to a more n-tier GUI based application frontend and the secondly to reduce the company's...; Tags: Environment, ROI, Roi/Tco, Mainframes, Finance, Managerial Accounting, Servers, Hardware; Case studies
Create an up-down box for your VB6 programs: Not sure why you need to use a scrollbar,since there is an existing up/down control in vb6, which works properly.This is neater than entering into textbox directlyThis method does save time and errors when entering numbers in a text box. One drawback is that the entry is in integer form.As...; Tags: Text1.Text, Fractional Values; Discussion threads 2005-12-06
Format Word 2007 documents using Change Case and Clear Formatting commands: Word 2007's Ribbon has two commands -- Change Case and Clear Formatting -- that make formatting easier. Change Case can change text case from upper to lower, lower to upper, and everything in between. For example, say you want a sentence you just typed in your Word document to be...; Tags: Microsoft Word, Microsoft Word 2007, Clear, Mary Ann Richardson; Blog posts 2007-09-11
Dealing with embedded sort orders in SQL: So what's the SQL?What's the SQL that properly invokes your UDF?Why a UDF?select * from TestSort order by CONVERT(int,SUBSTRING(CodeToSort,2,PATINDEX('%[^0-9]%',SUBSTRING(CodeToSort,2,200)+'|')-1))Your select does not give same resultYour select did not give the ssame result, so the UDF might still be the course to goWhat's the result to be same as?The article does...; Tags: aikimark@..., database, SELECT, software, SQL, SUBSTRING; Discussion threads 2005-09-27
Exploring the various uses of SQL's CASE keyword: Sql's Case KeywordVery usefulShowing Description in Group by clauseIn group by example, try the following querySELECT CASE WHEN price IS NULL THEN 'Unpriced' WHEN price < 10 THEN 'Bargain' ...; Tags: CASE, END, IS NULL, ramasubramanianm@..., software, SQL, sql server; Discussion threads 2005-08-30
CD Case Maker (exe): CD Case Maker is s software application that helps you make colorful graphics covers with text listings of music recorded with Roxio Easy C-D Creator 5.xx and perhaps others versions. The basic Roxio version does not allow this but CD Case Maker reads the files Roxio saves and makes covers...; Tags: CD, Roxio; Software downloads 2007-10-18
Exploring the various uses of CASE: While you've probably used the CASE keyword to create a column, it has many more uses. This week's SQL Server newsletter offers a variety of uses for CASE. Can you think of any other uses for the CASE keyword than the ones outlined in the tip? If you aren't subscribed...; Tags: Databases, Programming languages, CASE, Overloaded CASE; Discussion threads 2004-11-29
Select Business Solutions Case Study: Nielsen Media Research Monitor-Plus: Nielsen Media Research, Monitor-Plus, a publicly traded company, monitors advertising across 16 different media types (such as radio, TV and magazines). Nielsen's current business initiatives are to add new services and expand into new market segments. These require a major transition - from being a company that provides data, to...; Tags: Nielsen Media Research, Monitors & Displays, Advertising & Promotion, TVs, Tv & Home Theater, Hardware, Components, Marketing, Personal Technology, Home Entertainment; Case studies
Excel UDF Help - "Select Case": I'm trying to write a function to forecast a value based on historical data. The UDF has three arguments: range of cells must be within a single row or column, method (1-4), and an optional rate (-1; Tags: Cell, excel, fRangeLastCol, fRangeLastRow, Integer Dim fRangeLastCol, Integer Dim fRangeLastRow, Microsoft Excel, programming, rford2112@..., RngChk, Rob Public Function rForecast, Select Case, Value, Value at Risk; Discussion threads 2006-02-06
Ms Sql sever 2005: MS sql database table tmp contain following fields ModifiedON_A datetimeCreatedOn_A datetimeCreatedBy_A datetimeModifiedON_B datetimeCreatedOn_B datetimeCreatedBy_B datetimeif the ModifiedON_A date is null then the CreatedOn_A date needs to be checked to see if it meets the timeframe. If CreatedOn_A date is...; Tags: shuklasharadk@..., datetime, CreatedOn_A, ModifiedON_A; Discussion threads 2007-03-17
Can't open files in IE7: Hi,I have a asp program which works fine in IE6 and now it does not work in IE7.The problem is that IE7 does not like going to a folder and I just get an error stating that this web page cannot be display.Here is part of the code that makes...; Tags: cthang@..., Response.Write, Microsoft Internet Explorer 7, objRecordSet.Fields; Discussion threads 2007-04-05
Group Files Rename (zip): Group Files Rename is used to rename a group of files simultaneously. It is easy to use and fast to rename. There are 15 renaming methods, including replacement, insertion, deletion, truncate, change to upper case and lower case, add file date, and add serial number. With Group Files Rename, you...; Tags: Method, Group Files Rename, Recruitment & Selection, Human Resources, Workforce Management; Software downloads 2005-10-21
Problem in assembling mercury 810 motherboards: I use intel pentium-3 processor with mercury 810 intel chipset motherboard. I have a problem for connecting the POWER LED, HDD LED, RESET BUTTON and internal speakers on the motherboard. I don't have manual for MB.Plz. Help me for getting solution for fixing problemOR get online manual for mercury 810...; Tags: Corporate governance, Chipsets, chaitanya.daphal84@..., motherboard, mercury, board; Discussion threads 2007-10-25
Doing an "indirect" SQL SELECT: Does anyone know how I can do an "indirect" SQL SELECT statement? (one in which the column to return from a table is not named explicitly, but is contained in a variable?)For example, instead of this:SELECT trailer FROM .... WHERE ...I need to be able to do something like this:DECLARE...; Tags: ttobin100@..., SQL, SELECT @FieldName, DECLARE @FieldName nVarChar; Discussion threads 2007-10-08
Sql Select from Databases on Multiple MSSql Servers: Is there a way to include the server name in an sql select statement. (E.g select ([select columns] from server1.db1.dbo.table1 , server2.db2.dbo.table2 where [where statements])if not is there any other way to achieve thisLook up sp_addlinkedserverBeen a long time but yiou can then useselect * from Link.dbo.TableWhere link = server.database.Usually...; Tags: Programming languages, Databases, awcrichton@..., SQL, database; Discussion threads 2007-05-16

<< Previous
page 1 of 1
Next >>

Microsoft Outlook Basics: This ready-to-deliver presentation will help you introduce your team to Microsoft Outlook -- even if you don't consider yourself a public speaker. It ...; Buy Now

TechRepublic Power Checklist: Securing Windows XP: If you have just finished installing Windows XP and you think the work is done, you're wrong. Some of the most important steps to getting Windows XP u ...; Buy Now