I'm thinking there is another problem. How are you trying to run the package on your server?

I have to agree with the thoughts expressed while asleep. Yes, our actions and behaviour as individuals reflect on us as a group. It is human nature to...

Yes, you are correct....

rajendran.e (6/1/2009)

---

What are all the basic stuffs required for DBA.

I am aware of writing sql queries ,performance tuning,Backup,Restore,Creating database,Assigning Permission.

I don't have any idea about the cursor.Is this required for...

Looks like you came up with the same idea as i was putting together some test code myself.

Good work.

Does the following code give you any ideas on how to approach this problem?

declare @BitTest int,

@BitValue int;

set @BitTest = 2 + 4...

Yes you were, but I feel that you went a little more...

Jeff Moden (6/1/2009)

---

And, yeah... I'm glad your kid is OK and that some good folks pitched in. Just no more lectures about how good people are and how much...

Patrick Ige (6/1/2009)

---

Lynn..

I don't know what else to write.

I have a query that has 3 tables joined that result in a resultset.

I can't use this query because it won't work...

Patrick Ige (6/1/2009)

---

I have a query with 2 inner joins and an IN.

But unfortunately i can't use the query because the application needs a normal table i.e select a,b,c from...

Actually, not in this case. You really...

This could, perhaps, be turned into an editorial, but I felt compelled after this weekend to say something.

You may have read my post late last week looking for help, not...

jchesnut (6/1/2009)

---

Hi All,

I am trying to get the two rows on top to aligin (ltrim) and remove the leading spaces but the records but it still comes out as below....

Okay, now tell us what you are trying accomplish. I can't see a correlation between your data and the query from your original post. Possible that I am...

If you notice, GSquared took the time to format your code the way you should when posting questions.