Ooops sorry for the same post, I didn't see...

stan-617410 (5/13/2011)

---

Two tables: Users, UserStatus

Users fields: UserID, Username,Deleted (bit)

UserStatus: UserID, Username,Status (active,inactive)

I need to update the "Deleted" field when a user's status is Inactive.

Update users

Set deleted = '1'

Where...

I'm late here .... Jeff, I can see the brilliant stuff in this great article! -

Come and be a twitter guy (@JeffModen), I would like to see the SQL...

I don't know your data type in your table, and one of the options can be:

SELECT CAST(month_value AS NVARCHAR) + '/' + CAST(year_value AS NVARCHAR) AS YOUR_FIELD FROM TRANSACTION

Good news very professional staff it worth to attend ... I will check my possibility from other continent to come from EU to USA!

Hey Jeff, I'm late here, but really this is very nice article, thanks for sharing!

Wish you more success my friend,

Dugi

So you don't need to use cursor!

🙂

One alternative is:

INSERT INTO #TAB1

SELECT T2.SNO, T3.DEPTID, T3.DEPTNAME

FROM #TAB2 T2 INNER JOIN #TAB3 T3 ON T2.DEPTID = T3.DEPTID

I know that is later but I post the link for the other users at least:

http://www.microsoft.com/en-us/sqlazure/videos.aspx

ChungaLlunga!

:hehe:

I don't now the structure of the tables and in what conditions are Foreign keys with Primary keys, I think you should enable ON DELETE CASCADE during the relationship...

According to your server details (little details), I can say YES you can install the SQL Server 2008! Before to install you can use the upgrade adviser with SQL Server...

Why you are trying to SELECT all the records!?

While you are using the SQL Server 2005 you have possibility to do the partition table ...

Then the SSC is the...

This is the true story where all of us can learn that you cannot know everything, otherwise you will know nothing at all!

So doing SOS to the the people who...

robertm-772679 (12/23/2010)

---

Thanks for the quick reply Dugi. My problem is that there is no exe file to extract from the zip file. It's a shame. They sound like some...