halifaxdal (6/28/2013)

---

Currently I am using the following code to read all content of sp or fn and it works in most cases, however, it does return more than one rows...

hopefully you'll get a stack of options;

Here's one: this procedure returns a table of HTML-formatted information that documents some server settings, and object details of the currently scoped database:

Link To...

tstagliano (6/28/2013)

---

Thanks for the information but i dont what the table to be a temporary table in the tempdb database. I need it to appear in the ConstarOLAP_PROPHIX_FactDB where...

as long as you declare a temp table before the EXEC command, any other queries would have that table in scope, and can insert into it (same for permanent tables)

so...

Maddave (6/28/2013)

---

Can you change the SQL server to run under a dedicated account rather then system account? Then you should be able to set up the share to have write...

Japie i personally use CLR functions all the time, so it's probably how you are using it in an update, rather than the CLR being a problem all by itself.

can...

well, it seems to me the NTILE() funtion could group your data into groups, but your expected results looks like a simple GROUP BY results.

does something like this help? note...

you cannot...

add a where statement which will explicitly exclude non numeric data;do that for every table that is in your union all.

this , for example would allow integers only.(no decimal)

...AND...

yeah i see that now;

a simple test harness for others to use:

;With MySampleData([Name],[DecimalValue],[NumericValue])

AS

(

SELECT 'Number2_4', 0x14E20100000000000000000000000200, 1234.12 UNION ALL

SELECT 'Number1', 0xCF040000000000000000000000000100, 123.1 UNION ALL

SELECT 'Number5', 0xD9299549000000000000000000000500, 12345.12345 UNION ALL

SELECT 'Number4', 0xF24FBC00000000000000000000000400,...

in other programming situations, I've used a Regular Expression to strip html tags out of a field, leaving just the content; would that be a possibility?

then you could do Field=StripHtml(SomeValue)

Public...

you usually solve this by creating a Tally or Numbers table that has all possilbe values, and then joining that agaisnt your data.

this is doing what you asked for, based...

i prefer to use aliases for my updates, because the format for SQL makes it easy to include a SELECT statement very easily, which lets me do a quick Sanity...

i typically join the table against the insert/target table with a left join

it seems like the unique criteria you are using is the three columns i'm using in the join?...

i'm not sure if this will help, I'd really like to see a handful of sample data rows, and their expected values to really be sure.

but can you convert them...