The following works, but in GRID mode you won't see it and in TEXT mode they won't line up under the Cities column.

Create TABLE #tempCityState (State Varchar(5), City Varchar(50))

Insert Into...

Do you report to this new director or do you report to someone else? If someone else, you should be talking to that person not us. If you...

Quick question, A, B, C are in the parent table; app passes in A, B, D do you still want to insert A, B and ignore D since A and...

Yes, this is what I was going to suggest as well.

Are these native backups? What edition of SQL Server are you running? Are you using, if available, compressed backups? Where are you backing up your databases, local,...

Megha P (3/22/2013)

---

Hello ,

you can also try below

;WITH CTE AS

(

SELECT docid,pages FROM #x

UNION ALL

SELECT C.docid,C.pages-1

FROM #x X INNER JOIN CTE C

ON X.docid = C.docid

AND C.pages-1...

This should help you get started. Please note how I created a table and populated that table with sample data. This is what you need to provide in...

This works also:

DECLARE @test1 TABLE (Field1 varchar(1), Field2 int);

INSERT INTO @test1

SELECT 'A',1 UNION

SELECT 'B',2 UNION

SELECT 'C',3 ;

DECLARE @Test2 TABLE (Field1 varchar(1), Field2 int);

INSERT INTO @Test2

SELECT 'B',2 UNION

SELECT 'C',3 ;

select...

What edition of SQL Server 2008 are you using?

You could build a tally table in your database an use it directly, or you could use the following as a start for building a dynamic tally table when needed...

Check out sys.index_columns.

Try this bcp command. I moved the name of the database to the -d switch:

bcp "exec dbo.Rpt_JobTransactionsSp 'SRMQDIC','ROD','B','HNS','0','B',

null,null,null,null,'000','9999','1/1/2013','3/17/2013',null,null,null,null,null

,null,null,null,'T',null,null,'1','0','1033'" Queryout "c:\temp\query.txt" -T -d PHIL_App

-c -t^| -Sphlsqlsl01

Look at the EXCEPT operator. You need to be able to generate both results sets in order to compare them.

Indexes? Actual Execution Plan?

John Hanrahan (3/21/2013)

---

See no loop-I knew it was possible. Thanks Lynn. In the future I will post more info but I did write the loop in under 5...