tq 😀

Lynn Pettis (4/10/2014)

---

No, no problem with the parallelism. There is a problem with using a cursor. From a quick look at the code all of this could be...

Steve Jones - SSC Editor (3/19/2013)

---

Did you look at the link?

The second article talks about imports: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72493/

When you do the import, you'll need to then separate out the various parts...

tq sir.

Just have a look the SSIS. My...

tq mam

This is my Index so far

CREATE NONCLUSTERED INDEX [dbo.tbl_Penyata_IX1] ON [dbo].[tbl_Penyata]

(

[AktPst] ASC,

[edcode] ASC

)

INCLUDE ( [nogaji],

[TkhTransaksi],

[edAmount]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY =...

GilaMonster (1/15/2013)

---

Please post index definitions (they're not in your script) and execution plan (not the picture of it), as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Also, you can simplify that query as:

select

eln_payslip,

edamount

from dbo.tbl_Penyata

where nogaji='047911' and...

tq sir

thanks to all

Sir,

If large table,...

Dear Mr Dwain,

Your new T-SQL, look's ok. I will let you know, if something weird happen

tq so much

Jeff Moden (4/28/2012)

---

idyana (4/28/2012)

---

Kindest dwain.c,

Whatever people said about your solutions, I dont care. For me, you are the best. You have helped me. they do not help but criticize only

For...

Recall that I said it may cause some people who didn't get their first choice to miss getting assigned to a program entirely? I have an idea that I...

Kindest dwain.c,

Whatever people said about your solutions, I dont care. For me, you are the best. You have helped me. they do not help but criticize only

For me, you're my...

Ok sir. I'll be waiting for you