Maybe I should just worry about creating referential integrity and then see how access deals with it.

So what is the best way to enforce referential integrity? Should I add...

SQLRNNR (1/10/2012)

---

SQL Kiwi (1/10/2012)

---

Almost usable, perhaps, at a stretch. 2008 was a...

Now that is really good stuff. Thanks for that Ninja!. I'll let you know how my findings go.

The server seems good. It seems to be more of an applicaiton issue. We have an invoice program which is an add on to our ERP. It creates a pdf...

🙂 Ok ok....I'll read through it. I can see the benefit of it after running it and I'll dive into it when I have more free time today. I'd like...

Thanks for the suggestions everyone. I really like sp_whoisactive, that is some interesting code.

I'll probably still build my own query from the DMV's Gail suggested though as I can...

Cool. Thanks Gail. I always forget about those nifty dmv's. I'll give it a try.

Thanks!!!

That was it. Wizards for the win!

Great article Sebastian. One that I am highly interested in.

Can I ask what you prerequisites are there which make a database a good candidate for merge replication across different...

Eugene Elutin (7/27/2011)

---

Would you mind to add data-population script, so tables would have sample data to play with. Also, sample of how expected results should look like will help a...

Brandie Tarvin (7/27/2011)

---

Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking...

Kath Smith (7/27/2011)

---

I believe that the basic problem you are having is in your GROUP BY within the first query. You have the following fields being used in calculations...

Brandie/Celko, The DDL's are coming up. I didn't create the DDL, this is from a Microsoft Dynamics database called Navision. Its not pretty to say the least.

As far as...

Thanks LutzM.

Here is what I ended up with and it seems to be working. I really appreciate that quick response.

select

sih.[No_] AS 'Invoice Number'

,sih.[Document Date] AS 'Invoice Date'

,sih.[Sell-to...

Ok, so I got the ftp task to work and am able to move files from the ftp site to a shared directory inside the network. Then I want to...