Viewing 15 posts - 781 through 795 (of 3,543 total)
If you have SSRS and the non filtered data is not too large then you could create a report with one unfiltered dataset and 15 tablix each with a filter,...
April 29, 2014 at 5:41 am
SELECT t.ItemId,l.line,
CASE WHEN l.Line = 1 THEN t.Amount
WHEN t.SrvType IN (1,2) AND l.Line = 2 THEN t.Tax1+t.Tax2
WHEN t.SrvType = 3 AND l.Line = 2 THEN t.Tax1
WHEN...
April 29, 2014 at 5:34 am
If your solution is bad then anything we suggest may not be better, e.g.
SELECT b.BoxId,
MAX(CASE WHEN w.parameter = 1 THEN w.field1 END) AS [value1],
MAX(CASE WHEN w.parameter = 2 THEN...
April 29, 2014 at 5:13 am
Add an indicator within the group and set it's expression to use SWITCH to return a suitable value to show the relevant indicator
Use IIF to test the field for yes...
April 29, 2014 at 5:05 am
Also forgot to mention the response contains StatusCode and StatusDescription, check these as well as you might have an error which would be why no file was sent.
April 29, 2014 at 2:08 am
Also you can try to check what the response is and encode it as in this example http://msdn.microsoft.com/en-us/library/system.net.httpwebrequest.getresponse(v=vs.80).aspx
April 29, 2014 at 2:01 am
Brandie Tarvin (4/28/2014)[hrThat's all I'm getting back. Two little pictograms.
No you are seeing an attempt to convert a binary array as a string and there may be more than 2...
April 28, 2014 at 2:04 pm
Brandie Tarvin (4/28/2014)
As I continue troubleshooting this I keep finding interesting things. Now I'm getting a message box back with this response (see attached picture).Anyone know what this means?
It is...
April 28, 2014 at 9:43 am
GilaMonster (4/28/2014)
For the UK residents, what are my travel options for Birmingham -> Swansea?Not yet certain if that's where I'll go, but may well be a place to start.
If...
April 28, 2014 at 6:38 am
Use a dependency walker (http://support.microsoft.com/kb/256872) to check devenv.exe file for missing libraries.
I know some software installations can change C++ runtime libraries and break Visual Studio.
April 28, 2014 at 6:27 am
You're welcome 😀
April 26, 2014 at 4:48 am
It should do cannot see why it would not.
Best way is to try it
April 25, 2014 at 10:41 am
mrupperman (4/25/2014)
Can you tell me if the CTE is a standard SQL format that can be used outside of SQL Server if called from a 3rd party app?
Sorry I only...
April 25, 2014 at 10:34 am
Brandie Tarvin (4/25/2014)
As far as I can tell, it's reading in chunks because that's how it transmits. It's part of the multiform / data-part thing.
That is a misconception, the multipart...
April 25, 2014 at 9:01 am
Put your query in a cte and add the GROUP BY, SUM and ORDER BY to the SELECT FROM the cte
April 25, 2014 at 8:30 am
Viewing 15 posts - 781 through 795 (of 3,543 total)