Hi Augusto

This is usually straightforward - what does your source table look like? Can you post DDL with some sample data please?

samsql, could you help us by showing exactly how your output should look, in tabular format?

Fuzzy dedupe:

[font="Courier New"]-- Self fuzzy match

SELECT t.VendorID, r.VendorID AS Dupe, COUNT(*) AS TokenCount

FROM FuzzyInputFile r

INNER JOIN [Numbers] n ON n.number < LEN(r.VendorName)

INNER JOIN FuzzyInputFile t ON t.VendorID <> r.VendorID...

karthikeyan (10/1/2008)

---

Chris,

Thanks a lot for your prompt reply with example. It is working fine now.

Can you tell me why you used BIT instead of INT ? Becuase both of them...

[font="Courier New"]DROP TABLE #Temp

CREATE TABLE #Temp (SomeColumn INT)

DECLARE @HasRowsINT INT, @HasRowsBIT BIT

SELECT @HasRowsINT = COUNT(*) FROM (SELECT TOP 1 * FROM #Temp) d

SELECT @HasRowsBIT = COUNT(*) FROM (SELECT TOP 1...

Ian Scarlett (10/1/2008)

---

IF EXISTS (select * from Emp) print 'exists'.

This only needs to verify that a row exists in the table, and should only do a single I/O, regardless of...

Karthik, if I run your slight modification of my code as displayed in your post:

DECLARE @HasRows INT

SELECT @HasRows = COUNT(*) FROM (SELECT TOP 1 * FROM INVOICES_Monthly) d

SELECT @HasRows

Then the...

You don't have to COUNT() all of the rows...

DECLARE @HasRows BIT

SELECT @HasRows = COUNT(*) FROM (SELECT TOP 1 * FROM YourTable) d

SELECT @HasRows

Cheers

ChrisM

Hi Suresh

You're very nearly there, just a couple of small changes...

[font="Courier New"]DECLARE @UserId BIGINT

SELECT @UserId = UserId

FROM DAMS_Tbl_UsersLogin

WHERE UserName = @UserName

INSERT INTO  DAMS_Tbl_RegisteredUsers

   (UserId,FirstName,LastName,DateOfBirth ,StreetAddress1 ,StreetAddress2 ,

       City,State ,CountryId...

Many thanks...

Are they spaces? Or are they non-printing characters?

Try returning the ascii value of

LEFT(REVERSE(yourstring), 1)

and

SUBSTRING(REVERSE(yourstring), 2, 1)

Cheers

ChrisM

Hi Roger:

Update Billed

set bill_amount =

Case When product_Code like '%0000' then STATE_DUES

When product_code like 'CHAPT/%' and product_code not like '%0000' Then Local_dues

Else '9999'

End

where billed.ID = '123456'

Cheers

ChrisM

You're welcome maui, many thanks for the feedback.

Crosspost, see http://www.sqlservercentral.com/Forums/Topic577820-147-1.aspx

This might help:

[font="Courier New"]DECLARE @Today DATETIME

SET @Today = DATEADD(dd,DATEDIFF(dd, 0, GETDATE()), 0) -- today with no time component

-- Sanity check:

SELECT @Today, DATEADD(dd, 1, @Today) AS Tomorrow_1, DATEADD(dd,1+DATEDIFF(dd, 0, GETDATE()), 0)...