GilaMonster (5/8/2013)

---

Can you be a bit clearer what you want?

Kill all the queries that have been running for 2 hours and have been blocking other queries for 2 hours?

Kill all...

caspersql (5/8/2013)

---

This query was so long-running (over 2 days) that I...

No real need for dbo.DelimitedSplit8K here if you only expect maximum two parts (left and right). The following will work a bit faster (please note extended sample data):

IF OBJECT_ID('tempdb..#TempTable') IS...

Also, you could use MERGE, which can be extended to update non-matched records or/and delete some:

MERGE lookuptable AS dest

FROM lookuptable1 AS src

ON ...

First of all your check for a.FieldIDNumber = '1' should better be moved into WHERE clause:

SELECT

MySelectList

FROM SourceTable a

LEFT JOIN SourceTable a1

ON ...

Actually you can, if you really want or need to!

You should use cursor datatype in output parameter of your procedure. Here you will find a sample:

http://msdn.microsoft.com/en-GB/library/ms175498(v=sql.105).aspx

Should, also mention that this...

Phil Parkin (2/13/2013)

---

mister.magoo (2/12/2013)

---

dubem1-878067 (2/12/2013)

---

I have a varchar column containing dates (not my design) with this format 2013-02-12

I need to extract records between two dates

this code will do...

khayamshah52 (5/8/2013)

---

heloo dear ..

i am facing this error from last 4 days ...... please give me solution .

Run-time error "-2147467259 (80004005):

[Microsoft][ODBC Driver Manager]Data source name not found and no default...

skb 44459 (3/21/2013)

---

-- this works fine

SELECT a.* FROM OPENROWSET('SQLNCLI', 'Server=sql01;Trusted_Connection=yes;', 'SELECT * from syte_APP.DBO.employee') AS a

-- this code gives me error

DECLARE @Cmd VarChar(4000)

SET @CMD =...

Drammy (3/21/2013)

---

Thanks for the quick reply.

And thanks for the suggestion with the money data type.

I understand what ISNUMERIC is used for; that was just an example.

I was just trying to...

What hardware are you using to run your...

ISNUMERIC doesn't guarantees that the value is of NUMERIC datatype.

It's only the indicator if the value can be converted into one of many SQL Server numeric data types (exact...

Then it's logical...

I don't think you will get...

You should start to help our helpers (link at the bottom of my signature), by supplying DDL and sample data insert scripts instead of "I have table like that..." thing.

But...