Very cool!!!

living and learning !!!!

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

CREATE PROCEDURE SearchHistory_Dynamic (@Product int = NULL, @OrderID int = NULL, @TransactionType char(1) = NULL, @Qty int...

LIVING AND LEARNING!!!!!!! 😀

Hi,

SELECT NUMBER='51079-216-20' into #number

UNION ALL

SELECT NUMBER='3456-435623-45-34'

SELECT NUMBER=REPLACE(SUBSTRING(NUMBER,1,DATALENGTH(NUMBER)-2),'-','')

...

Hi,

Value = '12 'or '123', exist?

DECLARE @ID CHAR(8)

SET @ID='12'

SELECT ID= REPLICATE('0',8-LEN(@ID))+@ID

...

SELECT ID=ID,

NAME=NAME,

SALARY=SALARY,

SALARY2=(case when SALARY-1000=0 then null else SALARY-1000...

sorry.... Portuguese...

Somente um parenteses Luis...

--Here i need an IF condition to test

SELECT tam FROM sgt WHERE tam = 'Y' AND ref = @ref...

Jason-299789 (10/5/2012)

The Update with an INNER JOIN and WHERE is by far the most effiecent way of updating in these cases, as you will only ever hit the rows that...

update tblAverageMonthlyConsumption

SET REGION=(SELECT TOP 1 BB.REGION FROM tblgas01g4c40 BB WHERE tblAverageMonthlyConsumption.ID_NO=BB.ID_NO)

In this case:

distinct and no where clause (full scan?!?!??!?! almost... Very slow!!)

options: NOT EXISTS ... sometimes use: (SELECT TOP...

SELECT table1.column1,

'99',

left(table1.column2, 2),

max(table1.column3),

'Yes',

'Test'

FROM table1

WHERE NOT EXISTS ( SELECT 1

FROM TABLE2...