For something a little different, I thought I'd put The Thread back on topic for a bit as I go running back to the TITD (which I haven't visited in...

SQLTestUser (11/3/2011)

---

I have two tables

A and B

A has A.ID,A.Name, A.add, A.lastname

B has

B has B.ID,B.Name, B.add, B.lastname,B.otherfield

and i need to copy B into A with a query but i...

Not possible in SQL Server 2005 and depends on what edition of SQL Server 2008...

Well, my daughter Kirisa was just inducted into the National Honor Society ths evening!

Welcome to the fold.

When I started with MS SQL Server 6.5, I had 2 MOC classes to get me started. Everything else I learned on my own as our...

Kenneth Fisher-475792 (11/3/2011)

---

Lynn Pettis (11/3/2011)

---

Tarsha Shannon (11/2/2011)

---

Thanks for the replies everyone!

SSCrazy,

I actually need to enable autogrowth for both the data and log file for each database, the maxsize would...

Remember, TempDB is used by all the databases, not just for temporary tables and table variables, but also for queries that require sorting (ORDER BY, DISTINCT, GROUP BY). I...

Lowell (11/3/2011)

---

sure but you'll have to make sure you always wrap it in brackets when refering to it:

WHERE [Fixed/Float/Step (Interest Rate Type)] = 42

to avoid that, you want to go...

I have to agree with modifying the SSIS packeages to be dynamically configured for SOURCE and DESTINATION. If the only thing changing in the packages is that, nothing else,...

Make this change to your FROM clause, see if that gives you what you are looking for.

FROM Calendar LEFT JOIN

TimeTracking ON Calendar.CalendarDate = TimeTracking.Date1 AND TimeTracking.UserName = 'someguy'

This is the...

allan.madriaga (11/3/2011)

---

Hi Jared. The sum of NULLs actually do appear if I take out the following where clause:

WHERE ... AND (TimeTracking.UserName = 'someguy')

But when I insert that where clause...

Tarsha Shannon (11/2/2011)

---

Thanks for the replies everyone!

SSCrazy,

I actually need to enable autogrowth for both the data and log file for each database, the maxsize would be 150MB for data...

Not sure if you got the jist of what others said so I will give another answer.

In your WHERE clause, you have the following:

AND (TimeTracking.UserName = 'someguy')

The WHERE clause...

IIRC, the Import/Export Wizard only move data. It will contruct the basic table but does not create any of the indexes, foreign keys, etc.

If using BCP or SSIS, be sure to set an apprpriate batch size (number of rows per batch). You don't want the import to run as a single batch.