SQL Noob (11/5/2008)

---

once in a while we have weird problems like this and most times it's in a database that has been around since SQL 7 and continually upgraded across...

in another thread on a similar issue, where his 2005 server was slower than his 2000 with the same query, someone finally identified that in their case, they had seen...

you might need to review your web app for errors....

the identity is incremented even if there is an error in your code.

here's an example: the third insert will fail....the value...

David i don't know how useful it is, since for me it doesn't seem to be accurate;

I've updated statistics on a table for example, but this report give me results...

a lot of the information you ar elooking for(like IP address) is not stored in any database, so it can't really be done in TSQL without using something like xp_cmdshell...

i think if this query:

SELECT DISTINCT Cust_Num FROM fs_Unit

returns a null in the distinct collection, you'll get no results;

you might need

SELECT DISTINCT Cust_Num FROM fs_Unit WHERE Cust_Num IS NOT NULL

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