Software Applications Programming Errors and solutions.

If you have a table which has values like a,b,c and you want to get count like start from a,b or c columns value then you can use query following way. Select Left( name, 1) AS NameCaps, Count(name) as Name From Table_my GROUP BY Left( name, 1)  

 ad agency advertise advertise on google advertisement advertising companies advertising company advertising ideas advertising on google advertising online advertising techniques affiliate marketing bidvertiser brand agency cost per click digital advertising GENERAL google ads google advertising google pay google pay per click google ppc how to advertise internet advertising internet marketing agency internet marketing online local advertising online advertising online advertising agency online marketing agency pay per click pay per click advertising pay per click management pay per click marketing payperclick ppc ppc advertising ppc agency ppc company ppc management ppc marke...

This a Common way to clear all control on form using c sharp dot net code. In you common class you can write following code in method and you can call that method in any form using class object. foreach (Control C in CTRL.Controls) { if (C.GetType() == typeof(MaskedTextBox)) { C.Text = ""; } else if (C.GetType() == typeof(TextBox)) { C.Text = ""; } else if (C.GetType() == typeof(ComboBox)) { ComboBox cbox = (ComboBox)C; cbox.SelectedIndex = -1; } else if (C.GetType() == typeof(CheckBox)) { CheckBox chkbox = (CheckBox)C; chkbox.Checked = false; } else if (C.GetType() == typeof(ListBox)) { ListBox lstbox = (ListBox)C; lstbox.Items.Clear(); } else if (C.GetType() == typeof(DateTime...

These are list of categories which can be helpful to select for your blog. Electronics & Technology Camera Accessories Cameras - Digicams Computer Peripherals Fax, EPABX, Office Equipment Inverters, UPS & Generators IPods, MP3 Players Laptops - Desktops Mobile - Cell Phones Mobile Accessories Music Systems - Home Theatre Office Supplies Security Equipment - Products Tools - Machinery - Industrial TV - DVD - Multimedia Video Games - Consoles Everything Else Home & Lifestyle Air Conditioners & Coolers Antiques - Handicrafts Baby - Infant Products Bags - Luggage Barter - Exchange Books - Magazines Clothing - Garments Coins - Stamps Collectibles Discounted - Sale Items Fashion Accessories Gifts - Stationary Health - Beauty Products Home - Kitchen Appliances Home - Office Furniture Home Decor - Furnishings Household Jewellery Music - Movies Musical Instruments Paintings Sport - Fitness Equipment Toys - Games Watches Wholesale - B...

If you want use regexp_replace function with sql query then you can use following way. select regexp_replace('abcd434574@#$% [5224]efgh','[^[:aln um:]@,%,]') from dual; Output: abcd434574@%5224efgh

Below is the example of update statement with self subquery in SQL. UPDATE TB1 A SET A.IND = 'N', A.ENDDT = (Select Max(C.enqDT) -1 from TB1 C where A.Bus_KEY = C.BusKEY and C.IND ='Y' group by C.BusKEY) Where A.IND = 'Y' and A.EFFDT < (Select max(enqDT) From TB1 B Where B.col1 = A.col1 and B.bus_KEY = A.busKEY and B.IND = 'Y');

EXE File Tips-Close exe file by using batch file If you want to close any executable or exe file by code or runtime then you need to execute batch file in your programe. In batch file you need to write code following way. @echo off taskkill /F /im notepad.exe Just copy code to notepad file and save in .bat extension. when you execute this batch file then notepad editor will be close if its open. Send Exe file by mail To send exe files through gmail via attachment there are two ways First is you need to to compress the file using RAR or ZIP and send it via attachment. another way is remove the extension of .EXE then sent after receiving the file add an extension .EXE

In SSRS reporting if you are creating reports using Data Views. In the database you are  designing report and  trying to group by State or any other column, but 1 state may be entered a few different ways. (Ex. TX, Texas, Tex. TX.) When you insert a Group Row how could you group all of the same states together in one called TX?  you can handle the grouping in TSQL with a CASE statement: SELECT CASE WHEN [State] = 'TX' THEN TX WHEN [State] = 'Tex.' THEN 'TX ?. END AS [State] Or SELECT CASE WHEN [State] LIKE 'T%X%' THEN 'TX' END AS [State] Hope that helps. SSRS can handle the grouping and sorting.