Viewing 15 posts - 16 through 30 (of 136 total)
Hi laurie-789651,
Thanks for your reply. Actually what i want is the rows that does not have 'Metro Fibre' or 'Metro Wireless'.
What i actually want are the rows that do not...
September 26, 2016 at 7:09 am
GilaMonster (4/25/2016)
The semicolon is a row terminator. Your code should be
declare @Parameter nvarchar(4000);
set @Parameter = 'Urbanisation';
With tmp as (
Select Count(*) as Base,...
April 25, 2016 at 4:20 am
Hugo Kornelis (4/23/2016)
There are scenarios that call for this type...
April 24, 2016 at 7:33 am
Ok guys,
seems like i solved my problem myself
This is the code that solves the problem:
declare @Parameter nvarchar(4000)
set @Parameter = 'Urbanisation'
;with tmp as (
Select Count(*) as Base, DayOfInterview, COUNT(DayOfInterview) as DaysOfInt,...
April 23, 2016 at 6:34 am
Luis Cazares (4/22/2016)
Edit:
Correct your sample data, be sure it runs correctly.
Also, share what you're trying to do with this data. You might...
April 22, 2016 at 4:38 pm
Well guys,
I think i found a solution to my code problem, the solution was to use a recursive cte and group by the field you want, that gives you...
April 21, 2016 at 11:40 am
GilaMonster (4/21/2016)
It's easy to get wrong, and it's prone to horrible security flaws...
April 21, 2016 at 8:53 am
Thanks for your reply,
so how do i do the dynamic sql?
Tim
April 21, 2016 at 7:31 am
Luis Cazares (4/7/2016)
DECLARE @tbl_MediumResults TABLE(
Answer VARCHAR(8000)
);
INSERT INTO @tbl_MediumResults
SELECT '{"Sunday:"[3,4,5,]},{"Monday:"[1,6,]},{"Tuesday:"[5,6,7,]},{"Wednesday:"[6,7,]},{"Thurday:"[5,6,]},{"Friday:"[5,6,]},{"Saturday:"[1,6,7,]},'
UNION ALL
Select '2,3,4,5,6'
SELECT Answer,
CASE
...
April 7, 2016 at 11:14 am
Thanks guys for your help.
Please i have another request, i've been trying to do some manipulations on the code, but i'm not getting the expected result.
Please what if i have...
April 7, 2016 at 11:01 am
Reading the article I mentioned in my post.
Thanks Luis,
This is what i needed, it works now
Thanks very much
Tim
April 7, 2016 at 3:47 am
Thanks Luis for your reply,
but please look below at the error being generated:
(1 row(s) affected)
Msg 208, Level 16, State 1, Line 8
Invalid object name 'dbo.DelimitedSplit8K'.
Please how do i overcome that?
Thanks
Tim
April 6, 2016 at 7:08 am
GilaMonster (1/20/2015)
If so, do so.
If not, you'll have to hack the DB into the server and repair it, you may lose data, you may...
January 20, 2015 at 2:44 pm
GilaMonster (1/20/2015)
timotech (1/20/2015)
Please how do i recover from this error while trying to attach my database:
Could not open new database 'MediaMonitoring'. Create database is aborted
msg 9003, level 20, state...
January 20, 2015 at 8:05 am
free_mascot (1/20/2015)
January 20, 2015 at 4:54 am
Viewing 15 posts - 16 through 30 (of 136 total)