Oh ok. If there's no way to express those rules in table, I will write SQL in my Stored Procedure

Thanks your Sir

Based on your input, I've this

DECLARE @i int

DECLARE @idx int

DECLARE @numrows int

-- enumerate the table

SET @i = 1

SET @numrows = (SELECT COUNT(*) FROM dbo.CRM)

IF @numrows > 0

...

YIPPIEEEEEEEEE. TQ SIR 😀

For

select *

from CV

left join DeclarationResponse dr on dr.CVID = cv.CVID and dr.DeclarationQuestionID in (9, 2)

This is the result

I only need to display record if DeclarationResponseID is not null. So, the...

I knew my table design is silly.

To built column name and data, see below:-

1- Answer-Staff (9) is a DeclarationQuestionID=9 and Column is Answer

2- Response-Staff (9) is a DeclarationQuestionID=9 and...

tq to all.

Oh sorry...sir

Here my SQL Server Agent,

I've a question based on below image,

1. What's Log on as Local System account?

2. What's Log on as This account - Network Service?

3. What's the...

Why you cannot see sir?

In my services, this is my SQL Server (MSSQLSERVER)

1.

2.

3.

4.

I've a question based on below image,

1. What's Log on as Local System account?

1. What's Log on as...

Sorry sir. 😀

The conclusion is

1. Shrink log files -- index is not rebuild

2. Shrink data files -- index is rebuild

tq sir

Ok sir. I will find the script.

1. What's the different between shrink data file and shrink log file?

2. Which one (shrink data / shrink log) will enforce the database...

Oh. Got it sir.

Let's say, I want to shrink 10 database. Did you have any script to make it this possible?

Sir,

I want to shrink log file. Did you have the command?

Mark-101232 (4/13/2012)

---

I think there's a discrepancy in your results, one of the 8890 should be 2500?

with cte as (

select p.myID, p.programID, p.stSVT, r.subjectCd, r.merit, h.noOfMinSubject,

...