Luis Cazares (6/28/2013)

---

Or want to do a clustered insert...

SQL_Learning (6/28/2013)

---

Hi,

I have imported data into a database from an excel file and some of the columns contain values are like (392.03), (2.25),...

Until we have identity and we want to populate it in a specific order...

suresh0534 (6/25/2013)

---

Select * from candidates WHERE contains(c_resume_text,'"c++" or "houston" or "New York" or "Amsterdam"')

I have passed nearly 550 cities to search condition.

when i passed the 550 cities and run the...

you need to use FULL OUTER JOIN

SELECT ISNULL(t1.name, t2.name) AS name

,t1.JANclient

,t2.FRBClient

FROM ...

You cannot convert "any kind" of binary file into text file.

Binary file may contain any type of data in any format.

What binary file?

The best way to present such question would be with bigger example of required output.

If I understood you correctly your final table should have 6 columns...

So, may be that:

;WITH vals

AS

(

SELECT...

Looks fine to...

GilaMonster (6/11/2013)

---

There are no...

I will be very brave to disagree with Gail on this one. But...

There are such thing as a "nested transaction" in MS SQL Server. They just are not what...

Do not need in dopuble posting!

Your starting point might be here:

http://msdn.microsoft.com/en-US/library/ms170208(v=sql.110).aspx

Zeev Kazhdan (6/11/2013)

---

Thanks for the ideas!

In terms of auditing we thought as well that SQL is better, but the customer insists they do better auditing within their 4G application.

Thanks...

tshad (6/7/2013)

---

I have a CASE statement with a subquery that works most of the time but if the subquery comes back with zero rows, I get a null and I...

DataAroma (6/11/2013)

---

create procedure testRecur()

BEGIN

if

call testRecur();

end if;

select...