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...

Would it make any difference if the trigger was always ONLY supposed to fire for one record at a time. Basically, when a record is updated it fires the trigger to run through a set of calculations. Like I said - I inherited it and we're stuck with it for a few months...

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...

BART PE! I knew that but couldn't remember the name. I've been randomly googling for that for an hour. I actually got the files off no problem using the IBM native extras and just said to hell with it. I'm service packing my new install of Windows XP now...

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...

Excellent idea that I considered as I've been accused of being trigger happy for years. My real worry was getting the form to change based on that first field being changed by my new field. I couldn't get the onChange event to actually fire, but was looking into it further. The builders of the...

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...

It tells me I must connect to this (new) server via SQL Management Studio. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TheWkndr Braccae tuae aperiuntur...

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 do have 'reimport subreport when opening' turned on - but again I would have thought that it should be using the local copy for this. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TheWkndr Braccae tuae aperiuntur...

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...

Still learning after 5 yrs - I guess I was hoping for something a little more elegant than just a series of IF stmts. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ TheWkndr Braccae tuae aperiuntur...

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...