Search results for query: *

I don't know why I can't find anything about this, but how would one go about using an 'if' statement in a view? Looking to show SN if FSN is blank. both are text fields. Not sure when I turned dumb here. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TheWkndr

CR9 (I know) I have a report that includes all spaces finally set up how they want it. I did a crosstab to summarize some points at the end. Today I've been asked to do another summary on the same page, but of only space is less than a certain size. Outside of creating a formula for each...

SQL2K database I am having some difficulty with an existing trigger. I performs quite a few calculations and needs data from other tables to do so, but it only updates the one table it is attached to. It's been fine for a few years but they recently asked me to pull in one more piece of data...

Thinkpad T42 running XPPro The wife dropped her machine right on the corner that has the HD in it. It will not boot not. If you run through to safe mode, it starts running through a big list of files until it hits system32\drivers\agp44.sys then halts. After about twenty secs - BSOD with the...

We're just getting going on CRM 3.0 and are looking for a way to periodically refresh our development environment with production - data and scripts/setup. Our vendor has thrown the redeployment tool at us as their solution. Completely starting from scratch every time you want a refresh doesn't...

I'm not an exchange / network guy at all, so please excuse this. I am trying to give guidance to our outsourced exchage admin group as they are only doing what we tell them to do and I need some ideas. We have a small group of people starting on MS CRM soon. These people book meetings with...

My company purchased an add-on package. There is a field in Accounts that uses javascript to hide some sections on the form based on this yes/no field. We actually require three choices, but two of the choices should yield the same form view as the yes option. Since we're not 100% sure that...

A database was recently moved to a new SQL2005 server. I had previously set up a view and a job to export it to my SQL2k server so I could use the data in several places. I am not even a SQL2k expert, so SQL2005 is pretty new to me. I need to set up a transfer of data somehow to my SQL2k server...

We have an odd setup with 6 citrix servers running a HEAT-based application. We have a copy of each report on each server instead of a mapped drive to one central location - we used to do that but found that HEAT doesn't release the file locks until you log out of the app and people we're having...

Am I reading the speed thread (1276307) correctly - creating a view and basing a report off of the view will improve performance? If yes - thanks Ken and Ido ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TheWkndr Braccae tuae aperiuntur...

As a relative newb who doesn't have any formal training in SQL programming (or programming in general), I have a question that may be more of an opinion piece for you guys - if I have a section of code, say an 'if...else' which runs maybe 30 lines for either scenario - is it better to build this...

Goal: the last (which is not necessarily the highest) value in a group of columns for a row as part of a stored proc. Columns: UniqueID, data01, data02, data03, data04, data05 The columns will be populated in order (there will never be a row without a value in 02 that has a value in 03). If...

My company is in the process of outsourcing some functions - half the DBA staff being one of them. I have a job that 'magically' enabled itself while I was on vacation and really messed some things up. Is there a log somewhere of who may have enabled this job...

We have a 6.50.31113 setup running on citrix - the prgrams are installed locally to each of our 7 servers and they all point to the same SQL database. One our servers BSODd, so an image of a working box was taken and applied to it. The HEAT functionality works fine on this reimaged machine...

We have a Linksys WRV54G router connected via cable to one desktop and two notebooks. One is a Dell D600 - my work laptop - and the other is an IBM T42 we purchased for my wife's home business. Both run Win XP Pro. The router is set up for to broadcast our SSID. We use G only on channel 11 and...

Have a laptop running 2kPro that had around 55G of data on a 60G hd (I'm a DBA). Was copying about 10G stuff off of it to a networked drive via wireless and at the same time listening to music. It told me to upgrade Winamp to fix a security flaw, and when I did it rebooted unexpectedly - while...

I am an 'advanced novice' in SQL and 'complete novice' in XML (but I have a good XML guy helping me on this) - no formal training but a lot of on-the-job learning. I'd like to know if what we want to do is even possible before we get too far down the path. We have multiple versions of the same...

I have never seen anywhere the option add any security to any reports exported to adobe pdf format. I am still researching the options from Adobe, but if anyone here has had any luck with that I' d love to know about it.

We are running HEAT (call center app) over a 5 server citrix farm. There about 30 crystal reports that run through the app that reside on a SAN volume mapped identically to each citrix server. When a report is opened, it shows in the Win2003 Computer Manager that the report file has one lock on...

I am not receiving much cooperation from my network guys, so my apologies if this is a dumb question or I ask it in a profoundly stupid manner. We are running HEAT (call center app) over a 5 server citrix farm. There about 30 crystal reports that run through the app that reside on a SAN volume...