It is pretty cool & nice.. though you need SQL R2 tools as mentioned...

I'm running SQL Server 2008. Shouldn't I be able to see the objects in...

Hey Steve,

You're right about not being able to connect through the main logon box and only by clicking on "New Query" and then logging in through the login box that...

Yeah..same here... works...

After having used SQL backup by RedGate for so long, I have forgotten the syntax for a simple backup. I usually just script it out from the GUI! 😀 How...

I've always used the system stored procedure sp_dbcmptlevel for finding out or altering the compatibility levels of our databases. I've used sp_helpdb but wasn't sure it provided the compatibility level...

Yes it is. Sorry, was out for the holidays....

Totally agree. This is an extremely good site with great explanations. When I was...

In your first scripts SELECT statement, I dont see any logic or filters in the WHERE condition where you're telling it to exclude the old data and select new data....

yep getting zeroes for 9, 10 and 13

I get all zeroes.

CHARINDEX(CHAR(9), ItemNo, 0)

Btw.. do I change the 9?

Download SQL Server Express from here and the AdventureWorks database from here and then google SQL Zoo. Also, go to the nearest bookstore and pickup a book on SQL Server....

Microsoft SQL Server Integration Services is mainly used for ETL type tasks. This is typical of an ETL task. Its a very quick and easy package that can be built...

Or if those are the student id's that you need, just put more filters in there using the AND keyword.

So it would be something like..

WHERE StudentId IN(1,2,3,4)

...

Supriya.S (11/24/2009)

---

Slick84 (11/24/2009)

---

Hello,

I'm trying to trim the trailing spaces in my column data using below t-sql.

MAX(LTRIM(RTRIM(column_Name)))

Addt'l info, I use the max keyword to successfully group my data. Could the max...