Viewing 15 posts - 2,806 through 2,820 (of 5,393 total)
Problem is if I go with the suggested approach, then I will have to make varchar columns for example 'zzzzzzzzzzzzzz' in the inner case statement
You're right. You can use REPLICATE(<maximum...
-- Gianluca Sartori
August 31, 2011 at 6:01 am
You're on the right track, just make sure that every WHEN brach returns the same data type.
dt.Name appears to be a char/varchar column, so I guess that changing 1 into...
-- Gianluca Sartori
August 31, 2011 at 4:09 am
Surendra Patle (8/31/2011)
3) Or you can delete the log(.ldf) file from disk and add another as below.
As I followed this recently therefore elaborating the steps:-
1) Right click one...
-- Gianluca Sartori
August 31, 2011 at 3:39 am
Something like this?
DECLARE @UserDate datetime
SET @UserDate = '20110810'
DECLARE @SampleData TABLE (
Startdate datetime,
Enddate datetime
)
INSERT INTO @SampleData VALUES ('20110801', '20110812')
SELECT *
FROM @SampleData
WHERE @UserDate BETWEEN StartDate AND EndDate
-- Gianluca Sartori
August 31, 2011 at 1:35 am
Tempdb contains user objects (temporary tables, table variables) and internal objects (hash tables, bitmaps and so on).
If your tempdb fills because you create lots of temp tables, just drop them.
If...
-- Gianluca Sartori
August 30, 2011 at 11:07 am
WayneS (8/30/2011)
Gianluca Sartori (8/30/2011)
jcrawf02 (8/30/2011)
Gianluca Sartori (8/30/2011)
On the plagiarism, I don't see it. After all, musical notes are just seven. 😉You must not sing the blues...
I prefer hard-rock. 😛
Oh, well...
-- Gianluca Sartori
August 30, 2011 at 10:53 am
jcrawf02 (8/30/2011)
Gianluca Sartori (8/30/2011)
On the plagiarism, I don't see it. After all, musical notes are just seven. 😉You must not sing the blues...
I prefer hard-rock. 😛
-- Gianluca Sartori
August 30, 2011 at 9:44 am
Cadavre (8/30/2011)
peanuts91 (8/30/2011)
Thanks Gianluca.But If I have a field containing for example 'Abraham', it will detect the A appears 3 times. But not 3 times in a row like aaa.
How's...
-- Gianluca Sartori
August 30, 2011 at 9:11 am
peanuts91 (8/30/2011)
Thanks Gianluca.
But If I have a field containing for example 'Abraham', it will detect the A appears 3 times. But not 3 times in a row like aaa.
Try this...
-- Gianluca Sartori
August 30, 2011 at 9:09 am
Roy Ernest (8/30/2011)
Sorry if I am being stupid but why not just run sp_recompile for just that stored proc? It will recreate the plan.
Quite true, indeed. Maybe freeproccache with @plan_handle...
-- Gianluca Sartori
August 30, 2011 at 7:31 am
gregory.anderson (8/30/2011)
Is this possible? If so, is that the "sql_handle" parameter?
That's it.
-- Gianluca Sartori
August 30, 2011 at 7:29 am
This is Oracle code.
CONCATENATE and TRIM are Oracle functions.
Is this a migrated database?
-- Gianluca Sartori
August 30, 2011 at 7:28 am
This should do:
;with data (string) as (
SELECT 'Saaaateres'
UNION ALL
SELECT 'NoRepeats'
UNION ALL
SELECT 'aabbbcdef'
),
tenRows (N) AS (
SELECT 1
UNION ALL SELECT 2
UNION ALL SELECT 3
UNION ALL SELECT...
-- Gianluca Sartori
August 30, 2011 at 7:26 am
jje_de (8/30/2011)
Gianluca Sartori (8/30/2011)
..... into a stored procedure and then call it from SQL Server......Gianluca
Hi Gianluca,
thanks for your reply!
Ok, if this is a way, I try it. COuld you say...
-- Gianluca Sartori
August 30, 2011 at 6:35 am
This one made me smile.
"Close the ticket". :hehe:
I think he confused SSC with MS support.
-- Gianluca Sartori
August 30, 2011 at 6:13 am
Viewing 15 posts - 2,806 through 2,820 (of 5,393 total)