It's 12.30 here, not so early... 🙂

Gail is...

Duplicate post.

Replies here please.

http://www.sqlservercentral.com/Forums/Topic780470-19-1.aspx

You can open the package and save it to the destination server.

If you need to do it for several packages you can use one of the tools around that do...

Do it on the application side, you don't need to do it in SQL.

Some rows contain invalid dates. You could try to identify those rows with something like

SELECT * FROM Table WHERE ISDATE(StartDate) = 0

but it won't catch all invalid dates....

GilaMonster (8/31/2009)

---

There's already duplicate users in the system. We've got at least one case where two people have the same username. Something has to be don e about those and...

This is really a good point, Jeff.

And this is the main reason why I like temp tables: it's all mine and I can do whatever I want with it, sure...

This should do the trick:

ALTER PROCEDURE sp_FillLocation

(

@maxlength INT,

@length INT

)

AS

DECLARE...

This is not T-SQL code, I think it comes from Oracle and you're trying to port it in SQL Server.

You're not making any effort to do it by yourself and...

Why not? You just have to know they won't be there forever.

Anyway, creating tables in tempdb is the exact same thing as creating temp tables or global temp tables. I...

It's quite hard to answer your question, mainly because it's hard to understand.

If you want a quicker answer, please provide the create table statement for Locations, some sample data and...

RBarryYoung (8/21/2009)

---

Gianluca Sartori (8/21/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys...

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could cover for...

I use InnoSetup to create installation packages.

I think it can do all the stuff you need.

http://www.innosetup.com/isdl.php

You cant use IF / ELSE in DML queries.

You can use CASE / THEN / ELSE instead:

update test set REC_HHMMSSHS

= CASE

WHEN exists(select cast(cast(abs(round(cast( left(cast(REC_HHMMSSHS as char(8)) , 2) as int)-1...