kevinsd1 (7/12/2012)

---

Hi,

I am a newbie and I am trying to change the content of a field in a column which is the primary key and in relation with other tables....

Change the part in the code that says -- Rows with Children as shown below

-- Rows with Children

UPDATE C

SET status2 = I.status2

,Active_status = I.Active_status

FROM inserted...

You can use a PIVOT or CROSS-TAB as follows

SELECTClientNo,

SUM( CASE WHEN Code = 'AAL' THEN 1 ELSE 0 END ) AS AAL,

SUM( CASE WHEN Code = 'AAC' THEN 1...

pamozer (7/11/2012)

---

I'm Looking for the last transaction after the BLL before the next BLL if there is one. So if there is no transaction after the BLL it should be...

SGT_squeequal (7/11/2012)

---

Racking my brains on this one, does anyone know if it is possible to do a while loop with in a while loop?

what i want to do is...

You can declare a variable, say @today to hold the value for DATEPART(WEEKDAY, GETDATE()) and modify the code as below

DECLARE@today TINYINT

SET @today = DATEPART(WEEKDAY, GETDATE())

WITH CTE AS

(

SELECT

RE.DISPLAYTITLE,

CONVERT(DATE,PPS.Start_Date) AS DateStamp,

DATEDIFF(MINUTE,PPS.Start_Date,PPS.End_Date) AS...

naeemkhan72 (7/11/2012)

---

I dont want to create a table to hold and highlight the leap years, I'm assuming there must be a way to do it without the use of an...

rhythmk (7/11/2012)

---

Hello Kingston,

If I am not wrong then he wants all columns of...

Can you explain the logic for the second row in your expected output

113044,RAS,6/7/2012

113044,EDI,6/8/2012 -- should this not be NULL too, as there is no BLL after the BLL on...

A quick search on this site gave me the below link

I hope this will be helpfull

http://www.sqlservercentral.com/scripts/Miscellaneous/65769/

If you want Access Chapter 1 Big Name [ment] as your column name, the below query should give you the exact way to represent your column name in the table...

No. There is no need to add any code after the ROLLBACK TRANSACTION statement.

The ROLLBACK TRANSACTION rolls back all DML statements between your BEGIN TRANSACTION and GOTO ERROR_HANDLER statement.

CASE statements cannot be used in the manner you have used

I think this is what you are trying to achieve

SELECTPay.DetailId, clm.AssetId,

CASE WHEN Pay.DetailId IS NULL THEN ISNULL(clm.NoteIds,0) ELSE ISNULL(pay.NoteIds,0) END...

This should give you the desired result

SELECTStudentName,

MAX( CASE WHEN Question = 1 THEN Answer ELSE '' END ) Ans1,

MAX( CASE WHEN Question = 2 THEN Answer ELSE '' END )...

Can you tell how many rows are being returned by the SELECT query that...