did i read your requirement wrong?

i thought you wanted to build an image on the fly based ond ata in your dataset, was i wrong?

that was the development path i...

ramadesai108 (6/26/2012)

---

The closing quote is correct. After the long string, I have a year, '2012' as a variable. If I run the proc as follows then there are no...

Check your data type on any parameters ,whether in a proc or n the code in your application.

Ive stepped in that myself where a parameter fornmy sqladapter was the wrong...

and here's another way just using a sub select instead of the function:

note to self: That cross apply stuff is kewl, need to use it more.

SELECT PS.LineGUID AS LINE_GUID,

PS.PODSID,...

what do you mean by application?

YourBusinessApp.exe, or do you mean the database the app connects to?

performance typically has a lot more to do with the queries being performed, and the...

careful there! the knee jerk reaction for DDL...

a query with Column1 > Column2 best plan is going to be a index scan, right? it has to use the index to get all values greater than to match...

as far as i know, the EXECUTE AS must use a user for permissions, so you'd need to add that superUser as a user so that you can use the...

i end up creating a special login/user for the whole execute as stuff:

it works well for me.

--first we need a sysadmin role with no login, which will beused

--for execution context...

two minor syntax issues;

the first is missing the single quote after "SSN_GRANTED"

EXEC sp_addrolemember N'SSN_GRANTED', N '[T001371\ViewSSN]'

and for both commands, there cannot be a space between the N and the single...

well it's a syntax issue, i'd guess you are missing something compared to my working example. the leading N or a single quote, or something.

Can you post the EXACT command...

Laura it's probably permissions;

since xp_cmdshell requires elevated permissions, try adding EXECUTE AS and see if that resolves it:

--the EXECUTE AS must be a user in the database...not a login

CREATE...

OK this was a fun proof of concept again.

building an image out of text on the fly is going to require programming;

i'm not an SSRS guy, but i can...

there's a different proc for that:

in this example, you'd change '[~~]' to '|':

take a look at the documentation, i think i fleshed it out with a lot of examples;

http://sqlclrexport.codeplex.com/documentation

EXECUTE...

where the heck did i put my jump to conclusions mat?

mea culpa, i would have sworn i read import via BCP/xp_cmdshell. it was the "This query works fine to import...