Questions in topic: temporary-table - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: temporary-table

0

votes

0

answers

170

views

I want to do the comparision of temp table data with the linkedserver table data .Please help me how to write the query

Dec 27 '12 at 10:14 AM ThomasRushton ♦ 29.5k

table temporary-table openquery

0

votes

0

answers

710

views

how to insert into temp table from openquery linked server table

Dec 27 '12 at 09:41 AM buyme22 (suspended)

insert temporary-table openquery

2

votes

1

answers

220

views

Sproc returns data in SSMS, none to VB6 client

Dec 19 '12 at 06:44 PM RichRauch 100

sql-server-2008-r2 stored-procedures temporary-table vb table-variable

0

votes

2

answers

422

views

What is the use of #?

Jul 25 '12 at 01:31 PM basit 1 439

stored-procedures temporary-table

1

votes

3

answers

797

views

I need help creating a while loop that will update particular values and then save the results

May 03 '12 at 03:09 PM KenJ 12.4k

update temporary-table row while

0

votes

1

answers

1.1k

views

temporary tables, triggers, transactions, "database session"

Mar 08 '12 at 02:40 AM user-470 277

sql-server-2005 trigger transaction temporary-table

1

votes

4

answers

483

views

ITVFs, CTEs, and temp tables

Feb 23 '12 at 09:38 PM Grant Fritchey ♦♦ 62.6k

temporary-table cte inline-table-valued-function

0

votes

3

answers

785

views

getting a sum of data from two rows of the same table

Jan 15 '12 at 09:51 AM WilliamD 25.3k

temporary-table

0

votes

3

answers

878

views

select * from ##tablename

Nov 28 '11 at 02:45 AM Kev Riley ♦♦ 46.1k

temporary-table global-temporary-table

2

votes

2

answers

1k

views

Temp Table inserting records in random order

Aug 12 '11 at 09:30 AM Kalaivani 21

temporary-table

1

votes

3

answers

916

views

Query times using table variables, vs temp tables, when using MS CLR vs SMSS

Aug 08 '11 at 09:14 AM odge 11

temporary-table table-variable

1

votes

4

answers

1.1k

views

Cursor runs faster on Physical tables versus Temp Tables?

Jul 25 '11 at 11:40 AM Slick84 1.3k

table tempdb temporary-table temporary-tables

2

votes

1

answers

926

views

How do I use a stored procedure to create a temptable and parse or normalize data in it?

Jul 22 '11 at 10:50 AM SidC 23

sql-server-2005 stored-procedures temporary-table

1

votes

4

answers

1.5k

views

Temp Table v/s Permanent table for temporary process?

Jul 05 '11 at 02:29 AM Amardeep 1.3k

temporary-table

1

votes

2

answers

2.6k

views

Creating a Temporary Table and then populating with multiple columns

Jun 21 '11 at 07:52 AM sp_lock 8.1k

temporary-table temporary

30 questions

72answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1835
sql-server-2008-r2 × 394
stored-procedures × 340
update × 113
trigger × 98
insert × 91
table × 76
transaction × 51
tempdb × 42
temporary-table × 30
cte × 29
openquery × 26
vb × 19
table-variable × 18
temporary-tables × 16
row × 10
while × 4
global-temporary-table × 2
temporary × 2
inline-table-valued-function × 1

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.