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

you should script the deletes and truncates manually;

when people say they want to delete the data, they are really saying just certain data...they typically don't want to dete teh data...

using SQL2000's QA to connect to botha SQL2000 and SQL 2005, i get the same results that your SQL 2000 did; no null row; i changed SET ANSI_NULLS on and...

ok i got a vb project to work based on your parameters...here's my question;

in your example, the file had 5 columns. typically, BULK INSERT would expect 5 columns for all...

how about this?

SELECT

RegionDesc,

MATotal,

PartsTotal,

DemandTotal,

Total,

(CASE WHEN ISNULL(Total,0.00) = 0 then 0

     ELSE  ISNULL(MATotal,0.00)    +

           ISNULL(PartsTotal,0.00) +

           ISNULL(DemandTotal,0.00)   / Total END) * 100 As Percentage

FROM SOMETABLE