Trying to import them...

yuvipoy (7/27/2015)

---

Thanks for your replay Steve.

As i said it is one of the condition to check.There are multiple possible ways are there for data not loaded in to database, i...

Some things to look for:

1.) Regularly scheduled SSRS reports where the query creates temp tables of some size.

2.) Power users with query ability that might be fond of large temp...

I see no relevance to the problem associated with the link you...

bgolembiesky 4883 (7/27/2015)

---

Thanks for your help, SG. I tried something simple like that and it didn't work. Here's what I tried and got no results:

SELECT ED.EMPLID, ED.CHECK_DT, ED.AL_DEDCD, ED.AL_AMOUNT AS...

How about just this?

SELECT ED.EMPLID, ED.CHECK_DT, ED.AL_DEDCD, ED.AL_AMOUNT AS HSA_DEDUCTION, EC.AL_AMOUNT AS EMPLYR_HSA_CONTRIB

FROM PS_AL_CHK_DED AS ED

LEFT OUTER JOIN PS_AL_CHK_MEMO AS EC

ON ED.EMPLID = EC.EMPLID

AND ED.CHECK_DT = EC.CHECK_DT

AND EC.MEMO_CD = 'HSP7'

WHERE...

Further analysis suggests the problem was here:

WHERE ft.fdata = '20150701'

and was solved by:

WHERE (ft.fdata = CONVERT(DATETIME, '2015-07-01 00:00:00', 102))

And it might have been sufficient to use:

WHERE ft.fdata = '2015-07-01'

Glad I could help. Sometimes, just being able to bounce your ideas off of someone else can get the juices flowing, so to speak, and you can solve...

Don't know much about clustering, but from the look of the error message, it appears to be doing some kind of discovery for every node. Does the uninstall perhaps...

luissantos (7/27/2015)

---

Hello Steve

First , thanks for all your precious advises, but running the query the result don´t return any records.

Maybe i´am not explain correctly what i need, because on...

One thing you don't need is all the additional CASE constructions. Also, your CASTs are to VARCHAR, without specifying the length, and that will cause you grief because...

Tac11 (7/27/2015)

---

Hi experts,

my prod server(only default instance) is configured TempDB 1024 MB data and Log 200MB. when I run 'sqlperf logspace' it shows most of time around 45% 'log space...

yuvipoy (7/24/2015)

---

Hi,

Good Morning All,

I am having a file with the customer information stored , it may be in xml, xls,txt,csv ..etc..

I want to create a SSIS package as follows

Conditions

If there...

sunnysoni88 (7/27/2015)

---

This is seriously too much work:-D

But this gives me idea if needed we can try something of this kind.

As this report needs less investment , may be will try...

sunnysoni88 (7/27/2015)

---

Need to change a Excel report to SSRS.

Excel report has around 15 tables all with different columns.

Is there a way , I can show all data in SSRS by...