I have to ask, why the change in recovery model from FULL to SIMPLE and then back to FULL every week? This breaks the log chain meaning you can't...

marginalster (6/19/2012)

---

Here it is. Finally 😀

Thank you again for all the help.

declare @temp table

(

[id] [int] IDENTITY(1,1) NOT NULL,

[Dag] [datetime],

[Locatie] [NVARCHAR] (MAX),

[Temperatuur] [int]

)

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111112','Rotterdam','12');

insert @temp ([Dag], [Locatie], [Temperatuur])

VALUES('20111231','Rotterdam','12');

insert...

marginalster (6/20/2012)

---

Hi guys,

Thx for the replay. The email part works flawlessly. But the month selection is still not functioning.

id - months - avgtemp - %

1 - 11- 12- NULL

2...

That's fine, but I helped with the code so I am just curious what the...

Code looks very familiar. I'm just having a slight problem figuring out what the problem is, can you expand a little more on what is wrong?

dustinprevatt (6/20/2012)

---

Here is a rough example of what i have.

SELECT Distinct Column1, Column2, Column3, Column4, Column5,

...

Also, can you post the DDL for the table?

anand.narayanan 87953 (6/20/2012)

---

Hi,

i have been working with Sqlserver for the past few years.

Today, i have came across a strange scenario.

in our application, we are facing Arithmetic overflow error converting...

Please post answers here.

No reason to start another thread.

Let's keep everything in one place:

hbanerje (6/20/2012)

---

Sorry I forgot to paste the code in the previous email.

Select

COUNT (MS_DRG) as 'cntof MS_DRG',ms_drg, FYFP,

MS_DRG as '765',

MS_DRG as '766',

FYFP

from #TSI_patient_list_Csections

group by FYFP,ms_DRG

I...

kotharibij (6/20/2012)

---

Will I get any issues when restoring a user database

From SQL 2005 in SP2 Service Pack Standard Edition

To SQL 2005 in SP3 Service Pack...

dustinprevatt (6/20/2012)

---

I would like to write a query that only shows results when certain columns display the same result a certain amount of times.

I'm just not sure how to use...

derek.colley (6/20/2012)

---

Sorry but you need to give the table definitions and a wider description of what you're trying to do. We don't know from what you've posted what each...

dustinprevatt (6/20/2012)

---

It worked!

Could anyone go into detail about what this actually means ?

postdate>= dateadd(dd, datediff(dd, 0, getdate()), 0) and postdate < dateadd(dd, datediff(dd, 0, getdate()) + 1, 0)

I'm glad...

dustinprevatt (6/20/2012)

---

Is getdate the same as curdate?

If so how would i use the example in the link to show the beggining of the current day thru the end of the...