Another approach, not saying its the best, but it has some interesting features, and won't insert new values if they are already there:

CREATE TABLE dbo.TableA

(

Code ...

Ah, I see. Thank you. Actually I know very little, but what I do know seems to...

patrickmcginnis59 (1/27/2012)

---

I'd be curious to know that mechanism. For instance, rebuilding an index that gets used the least, it still either points to the clustered index if it exists, or...

Just the affected rows in the non-clustered index are maintained (updated) as part of the...

TST1 (1/27/2012)

---

Can someone please assist me with the following:

SELECT CAST(record as xml) as record

FROM sys.dm_os_ring_buffers

and I'm getting error

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date...

HowardW (1/27/2012)

---

I'm really glad they've added the FORMAT function in 2012. As much as there's an assumption that date format manipulation shouldn't happen in the database, it's nonetheless important for...

GilaMonster (1/27/2012)

---

And then you get those who swear that the code they posted is the exact code that they're running, which mostly works but returns data in the wrong order,...

?

DECLARE @test-2 TABLE

(

group_id integer NOT NULL,

id integer NOT NULL,

...

charles.southey (1/27/2012)

---

This is a good example of the hoops you sometimes have to go through to carry out some conceptually quite simple tasks in basic T-SQL. For a much simpler...

GilaMonster (1/27/2012)

---

Dim CPDHourUpdate As SqlDataSource = New SqlDataSource() CPDHourUpdate.ConnectionString = ConfigurationManager.ConnectionStrings("Application").ToString() CPDHourUpdate.UpdateCommand = "UPDATE UserDetails SET CPD_Hours = CPD_Hours + 2 WHERE UserId = @UserId" CPDHourUpdate.UpdateParameters.Add("UserId", Session("UserID").ToString()) Dim rowsAffected As...

Whenever I see "...it's urgent...", I think: "Not for me it isn't."

Awesome - I didn't even bother reading that one. I like the link Cadavre posted on the other one. ...

If you are referring to "please reply me of my question only .Thanks", I would...

mithubhudolia (1/27/2012)

---

I have to show data in reports (day wise and moth wise)

Like

In jan month ,we have 31 days so if data is available in 1'jan than show data else...