how about this idea:

turn each query into a view, then use sp_depends VIEWNAME, then drop the views when completed?

the issue you are running into is the account SQL server is running under is not an account that has access to the network. jobs (and xp_cmdshell, or anything that...

try this, it is slightly modified; if the dll cannot be created, an error will be raised....that would tell us that you need to register or re-register the RichText and...

Hi arun;

with 8 pages of RTF examples, using various methods, which function are you using?

if you are using something featuring sp_OaCreate, I'm sure the null gets returned if the richtextbox...

the trick is to simply join your original table with the subquery that identified the duplicates;

try this:

[font="Courier New"]

SELECT * FROM

[5K5_PatLevelData_September_2008-9_MST_20089_029]

INNER JOIN (

SELECT  [PatID(HospitalNumber)],

        Specialty_Service,

        POD,

        COUNT(*) AS [Number of Dups]

FROM [5K5_PatLevelData_September_2008-9_MST_20089_029]

GROUP BY

        [PatID(HospitalNumber)],

        Specialty_Service,

        POD

HAVING...

i typically import into a staging table first, and then into the actual data; that way i can use something like this:

insert into FinalDestination(column list ....)

select

ltrim(rtrim(somefield)),

coalesce(somedatetimefield2,getdate()),

coalesce(somemoneyfield,0.00)

from StagingTable

that lets...

I would suggest a different procedure to get totals for all groups:

create procedure spTotalPrestamosTipoUsuarioTotal @FechaIni varchar(10), @FechaFin varchar(10), @Tipo varchar(30)

as

begin

select

count(*) as TotalPrestamosTipoUsuario,

T.TipoUsuario

from dbo.Servicios S, dbo.Usuarios...

bulk insert can handle comma delimited, + quote delimited data automatically, but you must use a format file.

see this blog for an example:

http://lanestechblog.blogspot.com/2008/08/sql-server-bulk-insert-using-format.html

that way there is no need to clean...

i found this link with a simple search:http://www.alpesh.nakars.com/blog/unattended-sql-server-2005-installation/

i also second guessed that by unattended installation, you might have meant "install sql2005 with my application"

which you can get more info...

just checking the basics....are you using a full path in the query, for example

select * from ServerB.DbName.dbo.Employees where Ename='Bob'

could you please show a sample query, where a table exists in...

when you restore a database on a DIFFERENT server, you get something called "orphaned users" ; remember a database with a login "Bob" on my server is not the same...

less space? even the smallest servers today have at least half a terabyte or so of space if not more, and you are worrying about a miniscule amount of space,...

if you think you need a cursor in a trigger, you're always, and i mean ALWAYS, looking at the problem wrong.

one of the new feature sin SQL2005 is the COLUMNS_UPDATED...

if you decinde you need separate tables for notes, then

if you have three tables that need notes, I'd really recommend three notes tables, all with enforced FK's instead; it saves...

SELECT DISTINCT [Name],[Date Of Birth]

FROM [zzWembley WIC 2ND QTR 2008]

I get 2664 records with one record null

this implies that there are people who have the same name, but are...