When you say push to a client application, can you be a bit more specific?

Well, since we can't see from here what you see there, not really. Maybe if you provided us with the DDL for the table, some sample...

Other than all those double quotes (which I removed), I really don't see anything wrong with the code below:

UPDATE P SET

Stock = T.Stock

FROM

...

Here is your code formatted:

SELECT i.IncidentIDRef

,(

row_Number() OVER (

PARTITION BY sc.PnxCodeValue

,a.IAREF# ORDER BY a.IAREF#

) + 2

) seqno

,'Type: ' + IATYPE + ' | Last Name: ' + IALNAM + ' First...

Nope. Have you read...

I'm thinking this is more what is needed:

USE [Sandbox] -- My playground, change as needed

GO

/****** Object: UserDefinedFunction [dbo].[itvfn_FormatTimeHHMMSS] Script Date: 06/07/2012 10:08:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

In your SSMS window, does it matter which is run first? Is there a batch separator between them?

Nidhi G (6/7/2012)

---

These are the csv results:

CHJUSDDN,App,LMA,2012-03-30 00:00:00.000,I/O,16.9,2012-05-25 18:31:29.323

CDGDFGD545E,App,LMA,2012-04-03 00:00:00.000,MEMORY,0.22,2012-05-25 18:31:29.323

CRFGFG12ZE,WEB,LMA,2012-04-30 00:00:00.000,ScanRate,0,2012-05-25 18:31:29.323

CDFGDRFDGD,App,ESN,2012-05-12 00:00:00.000,RUNTIME,0,2012-05-25 18:31:29.323

BGFGHJ676RF,SQL,LMA,2012-05-31 00:00:00.000,CPU,0.0426399999999989,2012-05-25 18:31:29.323

HHJUI878DFE,DB,POR,2012-06-01 00:00:00.000,DiskSPACE,164.8,2012-05-25 18:31:29.323

i NEED COUNTER_VAL IN 'MEMORY, I/O, CPU'

INSERT DDL:

INSERT INTO [EMDB].[dbo].[STG_CAP_HLI]

...

From Books Online. I simply went to the Index tab and entered database roles.

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in...

Only thing that could be obvious is if the @ID2 is used in a way that would may the OUTER JOINs into INNER JOINs and there was no data that...

BrainDonor (6/7/2012)

---

Horribly obvious!

And yet it would appear I'm not the first to miss that, from the hunting around through the world of Google.

And you've just made me realise - we...

Well, it is hard to help debug code when we can't see what you see.

I see where you use @ID1, but what about @ID2?

Interesting. I thought I would give you another alternative since you were only returning a single record (value).

I am posting your code plus the code I added. The...

Charmer (6/7/2012)

---

GSquared (6/7/2012)

---

There isn't one built in, but a date-check regex should be easy enough to build into a script component. Bing/Google/whatever, ".net date regex", and you'll find several...