Viewing 15 posts - 496 through 510 (of 2,894 total)
GilaMonster (5/8/2013)
Kill all the queries that have been running for 2 hours and have been blocking other queries for 2 hours?
Kill all...
May 8, 2013 at 8:37 am
caspersql (5/8/2013)
ChrisM@Work (5/8/2013)
Can you post the actual execution plan as a .sqlplan attachment please? Makes this kind of exercise much easier.
This query was so long-running (over 2 days) that I...
May 8, 2013 at 5:39 am
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...
May 8, 2013 at 4:17 am
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 ...
May 8, 2013 at 4:04 am
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 ...
May 8, 2013 at 3:56 am
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...
May 8, 2013 at 3:43 am
Phil Parkin (2/13/2013)
mister.magoo (2/12/2013)
dubem1-878067 (2/12/2013)
I need to extract records between two dates
this code will do...
May 8, 2013 at 3:36 am
khayamshah52 (5/8/2013)
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...
May 8, 2013 at 3:16 am
skb 44459 (3/21/2013)
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 =...
March 21, 2013 at 9:31 am
Drammy (3/21/2013)
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...
March 21, 2013 at 8:17 am
shashi.bi245 (3/21/2013)
Thanks for the replay.I am having almost 600 records, so is there any other way to get the result without case statement.
What hardware are you using to run your...
March 21, 2013 at 8:07 am
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...
March 21, 2013 at 8:00 am
... however I can see in the proc the same table is called again later on, so putting in a temp table may be the way to go.
Then it's logical...
March 21, 2013 at 6:56 am
frecal (3/21/2013)
yes thats correct. To be honest i havent gotten very far . I have never used coalesce update query.are there any examples about?
Many thanks
I don't think you will get...
March 21, 2013 at 6:51 am
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...
March 21, 2013 at 5:25 am
Viewing 15 posts - 496 through 510 (of 2,894 total)