SQL is behaving as you told it as it is grouping correctly. What you will need to do is remove the date field from the data set so that...

Object reference not set to an instance of an object could mean a million and 1 things.

We can't tell you what is actually wrong just by that error.

I would suggest...

One way would be the need to compare each column individually like below.

SELECT

ID,

Name

FROM

EMP_TBL

WHERE

ID IN (1,2)

AND

Name IN ('foo1','foo2')

Plenty on the web for these if you use a well structured search.

https://www.google.co.uk/search?q=step+by+step+sql+backup+restore

https://www.google.co.uk/search?q=how+to+impliment+sql+clustering

If you could follow the second link in my signature on posting code and data for the best help I'm sure we can get to some working solution

We would need...

And thank you for the information, never seen that before so will add it to the list of gotcha's.

jghali (5/31/2012)

---

Hi all,

I'm having an issue to create a linked server connection to netsuite on the cloud.

They supplied me with an ODBC driver.

With the ODBC, I was able to connect...

The problem will most likely be down to 32 vs 64.

As you see the DSN in SysWOW64 that means the DSN is a 32bit DSN not a 64 bit DSN,...

The QRG has a table on page 2 titled how to license.

In that table is shows the following information

1. License all the cores in the hardware

2. A minimum of 4...

Not nessesarily, we used the exchange SMTP server as the relay, when we wanted to add a host to setup mail we had to add the servers IP in as...

Depending on the model number of the processor and how many of them you have in the server depends on the number of licenses you need.

You have to license 1...

As with anything surrounding licensing, it is best to speak to MS directly, please do not take what people say on the matter as litteral that is the way to...

DTS is another one to use

No, only points 1 and 3

Index and statistic maintenance should be done

Good practise, 2 of the points are BAD practise

Rebuild/Reorg indexes - Do this yes

Shrinking the files - Bad idea

sp_updatestats - This is partily done in the Rebuild/Reorg

Restarting the server -...