Search results for query: *

Does anyone know of software that will print to file for a virtual printer? I have a virtual printer set up on my PC, but I dont know how to allow another user to print to it and save the print image as a file.

I have an Excel Workbook that gets printed with client name, dob, etc. I just added a second worksheet to the workbook, but how do I write to cells on the second worksheet. Dim xlApp As New Excel.Application Dim xlWB As Excel.Workbook = Nothing Dim Path As...

I have an ASA 5510 which I have really no problems with, it is a great firewall. I also have an appliance for email security, a spam filter. The spam filter is supposed to be able to update a set of small databases every so often. The problem is that some of the thumbprint databases stop in the...

Yeah I can see that i'll have to create one for each table. I've already written 3 of them in the Test db. I think I got it now.

Ok, not really, but I need a trigger to insert or update certain table whenever a few other tables are inserted or updated. For example, myTable should pull certain fields whenever table A,B,C,D are updated. Table A,B,C,D, all share a PK of VisitID. The problem, as I see it, is I don't know...

Yes I just double checked in the ASDM.

No his ip is different.. C:\>ipconfig /all Windows IP Configuration Host Name . . . . . . . . . . . . : ZHP3000K Primary Dns Suffix . . . . . . . : .com Node Type . . . . . . . . . . . . : Hybrid IP Routing Enabled. . . . . . . . : No WINS...

I have a Cisco ASA 5510 for VPN connectivity. At any given time there are 2-4 users connected, although there are over a hundred accounts set up. I have one new user who is external to the company who can connect to the VPN, but cannot ping anything or access anything. I have had his Admin check...

A few days ago I noticed that the EPO service was not running, so I restarted the service. Since then all our clients can only update from McafeeFTP, which is our fallback repository. How can I fix this?

Why does it work if I use the TVF in a select statement by itself ?

Here is the TVF: ALTER FUNCTION [dbo].[Taround] ( -- Add the parameters for the function here @VisitID varchar(20), @QueryID1 varchar(10), @QueryID2 varchar(10), @ReportName varchar(50) ) RETURNS TABLE AS RETURN ( -- Add the SELECT statement with parameter references here SELECT...

Ok I know this thread is a week old or so, but I just got around to this again. I rewrote the function to be a TVF, but I get this error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression...

The function returns a datediff from when a medical report was dictated to when it is returned to the system. What is a TVF? I get an Invalid Object name for the function, do I need a select before the function name?

This needs to loop through a bunch of report rows and run the function dbo.Turnaround(VisitID)to calculate a time. In the code below, the function has a few more parameters, but I can rewrite the function to only take the VisitID, I was using it for other reports. The Cursor is really ugly and...

I'm just throwing this out there, but does anyone out there know Meditech DR. It is a MS SQL database. If so I have some questions that I need help with.

SQLsister -Yeah I've noticed, so is Boris's solution the best way?

wow that works great thank you.

Here is the query I am working with: Select distinct ADV.VisitID,ADV.AccountNumber,(select distinct InsuranceName from AdmInsuranceOrder where InsuranceOrderID='1'and VisitID=ADV.VisitID) as PrimaryInsurance, (select InsuranceName as SecondaryInsurance from AdmInsuranceOrder where...

No I just want to include the concatenated field in my result

Forgot to add it is SQL 2005