Haha 😛

bmg002 (10/7/2016)

---

Geeze. Sorry about that. ...

I love it when I get a notification about a thread I posed in 4 years ago!

Miss SQL Server so much! :crying:

Brandie Tarvin (12/17/2014)

---

So I have it in my head to design a webpage that my team can pull up at month end and, at a glance, tell what jobs have...

Jim Youmans-439383 (2/4/2015)

---

I have been thinking about this for a while and would love to hear where you are at with it. My idea is to create a process...

J Livingston SQL (6/9/2014)

---

please clarify what results you are expecting for this example

account_number acex_id expense_group effective_date ...

For the first part I believe I have resolved it by removing account numbers that satisfy the below query:

select *

from nfg2562_d AS a

WHERE (expense_percent IS NOT NULL OR expense_amount...

... and this is why I prefer to use ANSI-92 syntax!

Where I work now we use Sybase ASE (I miss SQL Server so much boohoo!) and all the code is...

SELECT @@VERSION gives me back:

Adaptive Server Enterprise/15.5/EBF

I thought these function are not part of ASE?!

Sorry this is UK date so it's 5th October.

I'm actually trying to use this with an EXISTS operator. Basically the above is an extract from a transactions table and my...

The truth is I'm no longer using SQL server.

Using Sybase which doesn't have these functions in ASE.

Jeffrey Williams 3188 (3/6/2014)

---

Are you on 2008 or 2008 R2? If 2008 R2 you should be using the native compression - which on a 500GB database could get you...

Grant Fritchey (3/6/2014)

Interesting. I think I'd probably argue against that, or at least argue that there's pretty much an equal chance of it going wrong no matter what. However, it...

Grant Fritchey (3/6/2014)

---

Abu Dina (3/6/2014)

---

The IT director (we're a small company lol) suggested that no backup file should be bigger than 50GB in size and so I followed his instructions....

Gary Gwyn (3/6/2014)

---

Have you tried backing up to another attached disk on the server, then copying to USB? Or, attach the USB to your local machine or another server....