GilaMonster (7/25/2011)

---

SQLRNNR (7/25/2011)

---

GilaMonster (7/25/2011)

---

mtillman-921105 (7/25/2011)

---

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand...

rbond 51820 (7/25/2011)

---

We are converting the date to string because the end users tend to "freak" when they see the system datetime with hh:mm:ss rather than just the date only...

Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to me, Gus, and...

Dynamic SQL is when you populate a variable with a SQL query or another stored procedure. Read up on sp_executesql when you get a chance, so you understand what can...

😛

@=)

I have to agree with Gus & Ninja. Yes, you can do it, but there are so many things that can go wrong with that method (like accidentally deleting the...

Why are you converting your dates to strings?

I have always had problems with BETWEEN dropping records on me, so I never use it. I always go this route:

SH_ACCT.open_dt >= dateadd(mm,datediff(mm,0,dateadd(mm,-2,getdate())),0)...

Yes, because SANS are set up in different ways and also have different hardware. Some SANS have 1 disk controller, others have multiples. Also, it depends on how the LUNS...

I think your scenario highlights a very real problem with Full-Text.

The searches are based on words, and variations of words, that SQL "knows." Because you are using proper names,...

You could always use the RIGHT and LEFT functions.

Declare @MyVar char(6);

Set @MyVar = 'abcdef';

Select @MyVar = LEFT(RIGHT(@MyVar,5),4);

Select @MyVar;

UPDATE import_table

SET cost_code=@MyVar;

I agree with everything everyone said so far. I would just like to add that it may be easier for you to draw things out before you start physically designing...

DBA in Unit 7 (7/25/2011)

---

with the SQL 2008 instance: I added the domain group COM\DBA to the sysadmin server role on the SQL 2008 instance, and default database as MASTER;...

If the domains don't trust each other, I don't think any amount of SQL perms verification will help. Check with your domain admin to make sure that A) the domains...

You have to turn the whole statement into a dynamic SQL statement. You can't just assign variables to the various bits of it. Do you know how to do dynamic...

Have you compared execution plans between the regular SELECT and the SELECT...INTO queries?