I can give you a sample...

eseosaoregie (12/5/2011)

---

I was just wondering if there was another way of getting the same output with a different query. I have tried to look up multi aggregate pivots on google...

Also, why are you inserting 3 rows into a table and then selecting TOP 1 without an ORDER BY? Either insert only the 1 row that you need, or make...

Please include the actual DDL from your ClientVersion table, and the function you are calling.

Jared

rams.prsk (12/5/2011)

---

Hi All,

Iam having clientlist table which contains clients username and the clientversions details.

Here is the list of Clisntversions of my table:

2.2.0.12

2.2.0.13

2.2.0.16

2.2.0.18

2.3.0.1

2.3.0.2

From the list we can see the maximum version...

This is why I am in favor...

MidBar (12/5/2011)

---

Hi,

I wonder if One could tell me the benefit of using different date format in tsql or procedure coding.

Does database engine works different or efficiently, if we use YYYYMMDD...

I don't understand the Vista/Windows 7 thing... Are you running Vista or Windows 7?

Don't enter a named instance... Leave it as the default.

If you are a student, go ahead and...

oliver.morris (12/2/2011)

---

Already on this case. The new system is much better, but cleaning up 5 years of bad practice is going to take a bit of effort.

Many Thanks for your...

4x4krzy (12/2/2011)

---

Nope, not at all.

I took over as DBA a wile ago and the security was not quite what it should be. I've been fixing ever since.

Another weird thing that...

Whilst you are doing this pesky parsing, I would think about a redesign. Allow the user...

It seems that's the real problem. The user account is different from the login, but has the same sid....

lacwill25 (12/1/2011)

---

ok.

Trying to setup a SQL Server database for the first time.

At this point, it may be best to uninstall all versions of SQL Server from my laptop and restart.

Just...

ScottPletcher (12/1/2011)

---

INSERT INTO foundTable ( note_#, product_code )

SELECT n.note_#, p.product_code

FROM notesTable n

INNER JOIN productsTable p ON

n.notes LIKE '%' + p.product_code + '%'

...

brian 20008 (12/1/2011)

---

Agreed, it just seems to be with the overall execution.

The indivudual queries (prior and post the union statement) run quick. It's only when everything is run and...