Viewing 15 posts - 346 through 360 (of 3,543 total)
i got the answer,its due to the space between the words in 1st column.Any...
July 28, 2017 at 4:27 am
July 27, 2017 at 9:26 am
Your format does not match the data, not all the data is quote delimited
try this
1 SQLCHAR 0 0 "\"" 0 FIRST_QUOTE SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 ...
July 26, 2017 at 7:48 am
HA!
That's marvelous.
My personal favorite was the two different people applying for the mid-level...
July 18, 2017 at 9:30 am
June 26, 2017 at 1:57 am
OK try thisCREATE PROCEDURE [dbo].[Z]
@StartDateTime datetime,
@EndDateTime datetime,
@Para NVARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SQLString varchar(1000);
SET @SQLString = 'SET QUOTED_IDENTIFIER OFF;
SELECT DateTime,['+@Para+'.ENERGY]...
June 15, 2017 at 2:05 am
As I said I changed the query in my post
and added two single quotes on the third line from bottom before the close bracket
June 14, 2017 at 7:00 am
jasona.work - Tuesday, June 13, 2017 9:02 AMOoo, and MUMPS, can't forget MUMPS
IDMS 😉
June 13, 2017 at 9:12 am
June 13, 2017 at 6:28 am
Not sure about 2008 as I am on 2008R2
Try selecting the required text and changing the format
or
create a placeholder, select HTML as styles and use <b></b> for...
June 13, 2017 at 6:24 am
June 13, 2017 at 5:45 am
My bad :blush:
Changed my query to add missing last quote
June 12, 2017 at 6:43 am
CREATE PROCEDURE [dbo].[Z]
@StartDateTime datetime,
@EndDateTime datetime,
@Para NVARCHAR(50)
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SQLString varchar(1000);
SET @SQLString = 'SET QUOTED_IDENTIFIER OFF;
SELECT * FROM OPENQUERY(INSQL, ''
June 9, 2017 at 5:54 am
I changed my SQL as it was flawed.
You do not need to convert the datetime in the query as you can format it in the report if needed.
The...
June 9, 2017 at 5:35 am
To get this to work edit your procedure and change
SET @SQLString = @SQLString + '"SELECT DateTime = convert(nvarchar, DateTime, 21), ['+@Para+'.ENERGY] , ['+@Para+'.FLOW], ['+@Para+'.POWER] '
to
SET @SQLString =...
June 9, 2017 at 2:34 am
Viewing 15 posts - 346 through 360 (of 3,543 total)