In the '90s, I worked for a company where the fiscal year started on the founder's birthday, March 23.

Chimp

Just to be clear, the entire world would be way better off if everybody, always used, spoke and thought in YYYYMMDD. Is it the 1st of April or April...

Luis Cazares (4/29/2015)

---

chgn01 (4/29/2015)

---

How about use ISNULL?

-- Q3

SELECT

*

FROM

#abc a

...

Not true, it equals...

+1 :hehe:

Alan.B (4/21/2015)

---

Minnu (4/21/2015)

---

Hi Team,

The solution provided by are working fine..

but there is a change in my result.

my request is

if a record_1 is in Table_A and Table_B, then

output :...

+1

Hugo Kornelis (4/17/2015)

---

The question is okay, but the explanation is absolutely incorrect.

The difference between the two functions is caused by some pretty non-standard behaviour of the ISNULL function. (Which is...

Here's an alternative that uses a tally table:

;with dataLen as (select len(@inputString) i, len(@searchString) s)

select

'POSITION OF THE SEARCH STRING >> "' + @searchString + '" IS AT :'...

Grant Fritchey (4/6/2015)

---

I'll go one further. I'd suggesting taking a look at Jeff Moden's article on Tally Tables[/url] and using that to take the comma delimited list and turn it...

Koen Verbeeck (3/5/2015)

---

That's not a typo, that is a mistake.

DELETE FRAM BBB, that is a...

TomThomson (3/1/2015)

---

I'm afraid that this...

Jeff Moden (2/23/2015)

---

Heh... table names as plural nouns. Makes for some interesting and non-automatable naming conventions.

So, let me ask... do you have an Employee table or an Employees table?...

patrickmcginnis59 10839 (2/19/2015)

---

dwain.c (2/19/2015)

---

CELKO (2/18/2015)

---

I need to create random alphanumeric characters as primary key values when inserting a record [sic]. .. I don't want to use GUID or...