I have no...

What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!

swetha2813 (11/10/2011)

---

I have two columns in which column1 has interger and column2 has data like this 'Sat Oct 01 00:00:00 GMT-0400 (Eastern Daylight Time) 2011'. In the oracle they have...

Just a shot in the dark, but did you try this:

UPDATE TELEHEALTH SET

INVOICE_COST = CONSULT_MBS_COST.MBS_ITEM_FEE * 0.50,

ITEM_STATUS_CODE = CONSULT.ITEM_STATUS_CODE

FROM

...

Banana-823045 (11/8/2011)

---

It's the same article I linked to in my OP. As explained to Jeff, I got fixated on the wrong section.

Here's the link again: Erland's treatise.

More specifically this...

Just for another example, you could also read this article: http://www.sqlservercentral.com/articles/T-SQL/67899/

Banana-823045

Apparently I didn't read too carefully or understood Erland's section and got fixated on TRUSTWORTHY which I still think is wrong solution. But certificates does seems to be just what...

Also, once you decide how much sample data to post, be sure to post the expected results based on the sample data.

Lynn Pettis (11/5/2011)

---

You haven't posted everything requested. Read the article I referred you to, you know, the first one in my signature block. You should also read the second...

You haven't posted everything requested. Read the article I referred you to, you know, the first one in my signature block. You should also read the second one as...

How many indexes and what order are you dropping and rebuilding them (include if the index is nonclustered or clustered).

Brandie Tarvin (11/4/2011)

---

Lynn Pettis (11/3/2011)

---

I really wonder about some of the people that come here. Some of the questions are just so elemetary that I can't believe someone actually...

SQLTestUser (11/4/2011)

---

Sorry for the confusion,

yes i have to insert into table A and then ensure that similar ID's are concatenated into a single row of data as i displayed in...

BUT WAIT, THERE"S MORE!

Now that we have moved data from B to A, there is more that needs to be done that we didn't tell you.

Come on people, tell us...

Instead of giving us requirements piecemeal, how about making sure you tell use the whole story upfront.

First, please read the first article I reference below in my signature block. ...