Viewing 15 posts - 166 through 180 (of 240 total)
I think Jared is right. The whole thing boils down to incorrect formation of @Subnet parameter. That is why asked what is in it. If it's like below, you will...
August 14, 2012 at 11:31 am
You can check the execution log on the report server to see where report spends most of its time - retrieving data or rendering.
USE ReportServer
GO
SELECT
C.Name,
...
August 13, 2012 at 4:29 pm
Please next time provide DDL and INSERTs like this:
CREATE TABLE #Building_Information (
Building_Name VARCHAR(50)
,Subnet VARCHAR(15)
);
INSERT INTO #Building_Information (Building_Name, Subnet)
VALUES ('Building 1', '192.168.1.%'),
...
August 13, 2012 at 3:56 pm
This looks similar to this post:
http://qa.sqlservercentral.com/Forums/Topic1343554-391-1.aspx
August 13, 2012 at 11:32 am
roryp 96873 (8/13/2012)
Does this not work for you?
select REPLACE(yourstring '%sometext%', 'replaced')
from #temp
I think the point is to replace any text between %.
August 13, 2012 at 10:52 am
Create table with exact structure as returned by stored procedure. Then use INSERT-EXEC
August 13, 2012 at 1:39 am
Not sure if I understood you correctly but... can you do this:
1. Generate first dataset and save it into temp table.
2. Dump to Excel from temp table.
3. Generate pivoted dataset...
August 13, 2012 at 1:31 am
In case you mean how to execute Multiple Server Queries[/url] from SSMS then basically you need to create a server group and then register couple servers under it and then...
August 13, 2012 at 1:23 am
subbareddy542 (8/12/2012)
pls try below codeSELECT AccountId
FROM #Comma
WHERE PATINDEX('%5%',Commas)<>0
This won't produce the desired output.
August 12, 2012 at 9:01 pm
What you need is a split function. The function that turns string of deliminted values into table. There are tons of info on the internet and this site.
Here is one:
August 12, 2012 at 8:57 pm
J Livingston SQL (8/12/2012)
try removing the GROUP BY
The OP included Id in the list. So, i thought s/he wants totals by Id, not over all table. So, which is it...
August 12, 2012 at 11:00 am
COALESCE ([MAT], 'Tot') will return string 'Tot' for every MAT that has NULL.
If you want to add Tot as a row you need to use UNION.
August 11, 2012 at 11:35 pm
Did you try to google the following phrase?
System.Data.DataRowView does not contain a property with the name
August 11, 2012 at 10:59 pm
August 11, 2012 at 10:47 pm
Viewing 15 posts - 166 through 180 (of 240 total)