Viewing 15 posts - 1,456 through 1,470 (of 5,111 total)
Like I said in your other topic please don't post things as attachments that can be included on your question's text. Include the details of what you are asking in...
November 11, 2018 at 11:15 am
What attempts have you made so far? Please do share your attempts. Could you post your data as something other than an excel spreadsheet please? DDL and DML statements for...
November 11, 2018 at 10:35 am
The problem is you're declaring your variable as the wrong data type. A datetime should be stored as a datetime(2), not a varchar. When using CONVERT and supplying varchar as...
November 9, 2018 at 5:52 am
Jonathan AC Roberts - Friday, November 9, 2018 4:47 AMYou just need to call msdb.dbo.sp_send_dbmail with the right parameters.
If your in SSIS...
November 9, 2018 at 4:59 am
November 8, 2018 at 9:25 am
Also, be careful with syntax like CONVERT(varchar, @start_date). I doubt it'll be a problem with this specific scenario, but you should really be declaring your lengths for your...
November 8, 2018 at 9:00 am
Did you set your report up like the Group Properties screen shot that I posted...
November 8, 2018 at 8:51 am
November 8, 2018 at 8:43 am
NineIron - Thursday, November 8, 2018 7:22 AM
And are the MRN and Name columns in the group in the...
November 8, 2018 at 8:22 am
November 8, 2018 at 7:18 am
Alternatively, you can just put the values in the high level of the group, like I have in this report:
November 8, 2018 at 7:09 am
NineIron - Thursday, November 8, 2018 6:42 AMI didn't merge the AccountNumber. It's a group.
AccountNumber isn't a group, the combination of AccountNumber,...
November 8, 2018 at 7:03 am
Here's an image. I would like the AccountNumber, MRN, and Name to show only once.
November 8, 2018 at 6:32 am
So, you're saying that you have a varbinary value without 0x at the start? I didn't even think that was possible. As an example the following code doesn't work:
November 8, 2018 at 5:43 am
Viewing 15 posts - 1,456 through 1,470 (of 5,111 total)