Search results for query: *

Personally, I would suggest using a single sp to perform a teak. Doing it this way allows you to treat the task as a single transaction even though there may be multiple inserts, updates, etc taking place. If insert fails within the sp, you can then rollback the transaction to maintain data...

...or you could also do: update prodTable set myField = '0' + myfield This assumes that myField is set to varChar.

There are two way to go about this (at least that I can think of). 1. Use active-x scripting in the ETL process to insert a '0' at the beginning of the data. 2. Load the data to a staging table then from there do something like insert into prodTable select '0' + cast(tmpField as...

Great info!!!

mrdenny, Thanks for the explanation and a star for you. I've always been a bit confused by this as well. What is a good percentage to set for the fill factor?

Can you print the exact error message? I remember I had something similar happen.

try changing: cmd.Parameters.Append cmd.CreateParameter("InvDate", adDBDate, adParamInput, , "6/1/2005 8:53:27 AM") to cmd.Parameters.Append cmd.CreateParameter("InvDate", adDBDate, adParamInput, 25, "6/1/2005 8:53:27 AM") It may be because the length is not specified.

Sounds like it's more of an asp question rather than SQL Server. You could try something like: where <<whateverfieldyouwanttofilteron>> = request.querystring("id").value or pass the URL parameter as a stored procedure parameter.

Jay and SQLBill, Thanks for your help. What's in BOL now makes sense:)

Thanks. Luckily, this is a development environment I built so time is not an issue. I'll restore the db using it with 'with norecovery'. Now that I think about, I didn't specify an option, so it used with recovery. Aside from that, once the restore completes, I should be able to restore...

Hi everyone, I'm hoping someone can help me out here. I'm starting a process of practicing my restoration of backups using query analyzer. I've been able to perform the restoration of the backup, but restoring the transaction logs is not working. My scenario assumes that the backup is being...

Depending on the size of the file, you could use active x in your ETL process. However, you'll take a performance hit in importing your data. In the DTS designer, there's a date time wizard you can use in your transformation.

So what you're saying is that if you're using either group by or distinct to get distinct rows, use 'distinct' as a best practice. From a performance standpoint, SQL server doesn't care. Correct?

anyone?

Thanks vongrunt... That's what I meant to say.

I'm hoping someone can answer this for me. Which is worse to use: group by or distinct? I took a peek at the execution plans for both and they are identical. In this example, group by and distinct serve the same purpose, to remove dupes from a dataset. Does SQL Server know this and just...

In this example, you could. But if you needed to add more fields from PROFILES.dbo.ps_job, you'd get dupes on the emplid.

or more specifically: select a.emplid, a.action_dt from PROFILES.dbo.ps_job a join PROFILES.dbo.ps_job b on a.emplid = b.emplid and b.action_dt = (select max(t.action_dt) from profiles t where a.emplid = t.emplid) where a.Action in ('PRO','XPR')...

Try this: select a.emplid, a.action_dt from profiles a join profiles b on a.emplid = b.emplid and b.action_dt = (select max(t.action_dt) from profiles t where a.emplid = t.emplid) You could also write this using a derived table rather than the...

Hi everyone, I'm hoping someone can help me out here. I have got a table that holds call tracking information. The table looks like this: note_id, note_desc, call_date, entry_date What I'd like to do is to be able to pull the notes for the last 5 business days from today. Any help would...