can you show us the sql you are currently using?

Update dbo.WipJobAllMat

Set dbo.WipJobAllMat.Bin = dbo.InvWarehouse.DefaultBin

FROM dbo.InvWarehouse

INNER JOIN dbo.WipMaster ON dbo.WipJobAllMat.Job = dbo.WipMaster.Job

Where dbo.InvWarehouse.StockCode = dbo.WipJobAllMat.StockCode

and dbo.WipJobAllMat.Job = dbo.WipMaster.Job

and dbo.WipMaster.Complete <> 'Y'

and dbo.WipMaster.JobClassification = '90'or dbo.WipMaster.JobClassification = '96'

i provided an example when using the convert function; take a look at books on line...

most people suggest using a datestamp like 200709261727 instead of the format you were suggesting;

for...

longtime known issue.

logins on a server are stored in the master database. access to the login is stored in the actual database (select permissions only, db_datareader for example) are inside...

if you don't explicitly say tablename.columnname, the engine does it's best to resolve the columns automatically, since there IS a state column in one of the two tables involved int...

watching this topic, to see if it's possible.

personally I always make CSV or HTML files and change their extension to .XLS, so I never automate Excel, and I've always just...

ok think the business rule thru completely;

if a technician does his three tests in one day, he's qualified for a 10% raise(note you said raise and not a bonus, which...

yeah hire me too and i'll be a testing maniac! getting my pay to go up 10% per day of testing would be awesome.

zim (9/25/2007)

Posted - 09/25/2007 : 04:13:20 Show Profile Email Poster Edit Topic Reply with Quote

i want to write a database trigger to increment the salary...

make sure you use a field that is datetime. it can contain both the date and the time together; if you stored it as a varchar, change it to solve...

gotta watch for any scripts that use sp_MSFOREACHDB and also that selects from master.dbo.sysdatabases as well. any script susing that wouldn't explicitly say the db name, but might be using...

yes there is an easy efficient way;

look at this post:

http://www.sqlservercentral.com/Forums/Topic398428-338-1.aspx

there, someone wanted to replace extended ascii with the html encode; ie '‘Special Digital Data Service Obligation’ got some characters stripped...

thank you Pam!

I didn't know they did that in 2005. much easier to restore I assume, since it's part of the backup.

In the original posters case, since the backup came...

this will work for any binary file it was here on SCC from 07*02/2007 post if you want to google the whole thread.

INSERT INTO myTable(Document) SELECT *...

am i wrong? i thought full text catalogs were not part of the database, but a separate file stored on the server, so you needed to back those up separetely,...