Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
627 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 63
Page Size: 10 · 25 · 50

Author filtered by: __TR__ [x]
Answer 18 Mar 2013   license: CPOL
Take a look at Inserting Rows by Using INSERT and SELECT Subqueries[^], which should help you get rid of the loop. Also as Abhinav suggested try to use a in-memory temporary table instead of tempTable.
SQLSQL-ServerSQL-ServerSQL2008
QA Spammer by __TR__
Forum Message 14 Mar 2013  
SUpeR 15#$%^$%^&~Watch Highlanders vs Hurricanes Rugby union live stream online HD TV[
Answer 14 Mar 2013   license: CPOL
TryUPDATE Table_NameSET quarter_startdate = DATEADD(YEAR, DATEDIFF(YEAR,quarter_startdate,GETDATE()), quarter_startdate)
SQL-ServerSQL2008
Answer 6 Mar 2013   license: CPOL
Take a look at these CP articles.CodeProject Frequently Asked Questions Series 1: The ASP.NET GridView[^]Editable GridView in ASP.NET 2.0[^]Insert, Update, Delete with Gridview ... Simple Way[^]GridView all in one[^]More resources here[^]
C#
Answer 6 Mar 2013   license: CPOL
You can use CONCATENATE[^] function to build the insert statement in excel. You can take the text "insert into emp values(" in one column in excel sheet and then concatenate the column values and build the insert statement.ReferHow to Concatenate Text in Microsoft Excel[^]
SQL
Answer 6 Mar 2013   license: CPOL
try the below approachDECLARE @FromDate DATETIMEDECLARE @ToDate DATETIMESET @FromDate = '12/30/2012'SET @ToDate = '03/07/2013'SELECT a.in_ts,a.jobCode,b.name...
SQL-Server
Answer 27 Feb 2013   license: CPOL
Here is a sample approachDECLARE @T TABLE (Browser VARCHAR(100), IP VARCHAR(100))INSERT INTO @TSELECT 'chrome23', '127.1.1.2' UNION ALLSELECT 'chrome24', '127.1.1.2' UNION ALLSELECT 'chrome25', '127.1.1.2' UNION ALLSELECT 'firefox3', '127.1.1.2' UNION ALLSELECT 'firefox18',...
SQL
Forum Message 24 Feb 2013  
Happy birthday Griff. :beer:
Answer 18 Feb 2013   license: CPOL
TrySELECT Date, Product,stage FROM liststage WHERE Date = (SELECT MAX(Date) FROM liststage)--ORSELECT TOP 1 Date, Product,stage FROM liststage ORDER BY Date DESC
SQL
Answer 18 Feb 2013   license: CPOL
Take a look at User Defined Function – Get Number of Days in Month[^]How to determine the number of days in a month in SQL Server?[^]
C#ASP.NET
Page 1 of 63
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web02 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid