RE: Join temporary table with another table
Are you try to refer temp table created by stored procedure or another session? Check the sysobjects in TEMPDB to see whether this temp table exists.
2003-07-24
SQL Spackle
RE: Silly Question
Excellent solution. One small suggestion: CREATE PROCEDURE dbo.spRef_GetCertifications ( @activesOnly bit=0 ) AS SELECT ID, Name, IsActive, SubmittedOnGMT FROM Certification WHERE IsActive >= @activesOnly ORDER BY Name ASC This way you don't have to pass anything in when you want all. We use this to avoid even creating the parameter in the ADO calling object. […]
2003-07-23
RE: Replace statement
Is this what you want? update ITEM set CTLG_NO = replace(CTLG_NO,'55551111','41331111') test it first though
2003-07-23
RE: Update Table using field from another table
UPDATE TableA SET id = TableB.id FROM TableA INNER JOIN TableB ON TableA.xCode = TableB.xCode WHERE TableA.id IS NULL OR TableA.id = ''
2003-07-22
RE: Match firstname lastname
Maybe more of the business rules aswell, how do you determine if Joe Doe is really Joe Doe in the other database, both maybe married to a Sue.
2003-07-22
1 reads
RE: Email error message
If you have Outlook as the client on your server, it is probably installed in the 'Internet Only' E-mail service option. You may need to change this to 'Corporate or Workgroup' option.
2003-07-22
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers