Just FYI, usually at the start folks like using just UNION, instead of UNION ALL. In your case either will give the same result since the rows returned from each UNIONed SELECT...

1. Do you understand (choose any / all): B,C,D,E, little a

2. Which of the above do you use? (Order by source, preference):

Usually into temp tables, then manipulate.

Text - Bulk Insert,...

Little "Import" Survey (let's here from alot of you, feel free to add or edit) :

Maybe we'll do another for "Exporting"

1. Do you understand (choose any / all):

A....

thriveni,

I'm thinking something like (Psuedo code)....

1. Create #Temp table, structured for dynamic insert of step 2

2. Dynamic SQL :Insert into #Temp Select ... From ... Union...

Yes i want to know the max value of the data type "int" when it is assigned an identity.

As Mr./Mrs. #### says... 2,147,483,647

BTW, what does SQL do for the next...

Glad we could help.

So you're all set for now?

P.S. Heading home for the day

Sorry I have to ask, How urgent is this for you? Can you wait 'til tomorrow for response from me?

Is the last post the entirety of what is involved? I...

Hope this helps (Hope it pastes ok too).

Declare @filename varchar(100), @beg_date varchar(30), @end_date varchar(30)

SELECT @filename = 'TheFilenameTB', @beg_date = '1/1/04', @end_date = '1/5/04'

Print 'SELECT  @SzTIF = SzTIF,...

Do you have the Linked Server entries in the "current" server?

i.e. Are you connected to Server A, trying to "link" to Server B? Then the Linked Server entry must be...

No "rule" is always...

With just using the 1 "compound" SELECT , we where giving the optimizer access to ALL aspects of all the tables (Columns, Indexes, Rowcounts etc..) but when...

Seems to handle my C&P from Q/A alright, just the tab indent does not look great

Test Post: [This line has space at end]

From Q/A w/o ending space:[This line has space at end]

Q/A test Post

 This Line has 1 tab indent at beginning

    This line...

Do you want 2 records with your 2 values from 1 SELECT

or 4 variables, @SzTIF, @ctTIF, @SzJPG, @ctJPG assigned from 1 SELECT?

OK, I'm just step by step "simplifing" (I hope) so we can drill down a little...

Now Try this, (with and without)...

If Object_ID('TempDB..#Temp') is Not NULL Drop Table #Temp

SELECT AL2.vch_shortname,...

Used to happen to me, even on old site. I've gotten in the habit of putting an extra space at the end of each line before I cut & paste from...