Search results for query: *

I finally got it to work.... I had to set the parameter to a string in ssrs Convert the parameter values to characters In the dataset/properties(?? The ellipsis )/parameters tab make that parameter CChar(parameters!parameters.Value(0)) Then in my stored procedure set @parameters varchar(11)...

I've tried them both now. Margaret

yes, I've tried that --now I get a "cant covert smallint" error which I'm trying to track down. Margaret

yes, the parameter being passed back is 1,2,3 or 8,9 (usually). The SP is quite involved but the parameter is in the first where clause .... so are you saying instead of using the SP, to completely encompass the entire script into this exec sqlstatement? I don't think I can do that.... I create...

I just tested that theory and I'm correct. making the query read Convert(varchar(2), priority) in (@priority) will not give me an error,however, only returns data if I've chosen one priority and I need for them to be able to choose more than one if they wish. Margaret

It's in the where clause as a Where priority in (@parameter). Since priority is an integer, having the @parameter come back as a varchar isn't going to work well. I suppose I could convert the priority field as I call the parameter, but that just seems wrong. Margaret

It's being passed TO the SP. Thanks Margaret

I've sucessfully passed string parameters back to a stored procedure to limit data coming into my report, but now have to pass a list of integers to a report to filter on. My report is failing saying it's unable to convert a string to an integer. I guess that SSRS passes all such back to an sp...

I did that -- still no luck. Thanks! Margaret

I've created a new smartlist and set the security to allow it to be seen by specific user classes, but they cannot see it. Once I log out of Dynamics and back in, it disappears from my smartlist as well. Any ideas? Dynamics 9.0 on SQL2005. Thanks!

...being after the email is sent, when I had it before the email, the email still wasn't sent. Also, I'm telling it to rollback transaction A which *should* mean it only rolls back the insert. Since the main source of crap-out on this insert is violation of the primary key, it is probably not...

You do NOT have to install fonts in order to make them appear in PSP. I have a folder in My PSP files that is labelled Fonts. All I do is open the font I want to use and it becomes available in PSP. You do not want to install too many fonts in your C:/Windows/Fonts folder as it will bog your...

First off, you need to identify the font used. Once you know what your font is, set the background to black, your line size to 2 or 3 (since that outline looks pretty fat) and your foreground to that funky gradient peach color. Then type your word, apply your curve. Now duplicate that layer...

Why don't you use your pen and create your shape as a vector shape? Make one line. Click the edit button on the toolbar, then select the end point of it, right click and choose curve before (if it's the end -- if it's the start, choose curve after). Click off the line, then click back on your...

Ok - so although the JOB fails because of trying to insert a duplicate row (the most common cause of failure for this particular insert), you're saying I cannot trap it? BUMMER! Margaret

...and econupdate.econupdate_identity=newwork.updateindex declare @query varchar (255) set @query = 'select * from econupdate where chk=2' exec master..xp_sendmail @recipients='margaretn@ttc-inc.com', @subject='Event insert step failed', @query=@query, @attach_results='true', @width=250...

Thanks Crowley -- I thought that might be happening, but didn't really know how to get around it. Margaret

Well, I do know an error was generated as the job failed, but I will do that (assign the error to a variable). Thanks SQLSister! Margaret

Either way will take the same amount of processing time and i/o, so whichever way is easiest for you do do. You're talking about a once and done thing here. Just be sure to backup before you do it just in case. Margaret

...exec master..xp_sendmail @recipients='margaretn@ttc-inc.com', @subject='Event insert step failed', @query='select * from econupdate where chk=2', @attach_results='true', @width=250 ROLLBACK TRANSACTION RETURN END COMMIT TRANSACTION end When an error occurs, I don't get the...