Viewing 15 posts - 2,806 through 2,820 (of 5,394 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...
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...
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...
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
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...
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...
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. 😛
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...
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...
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...
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.
August 30, 2011 at 7:29 am
This is Oracle code.
CONCATENATE and TRIM are Oracle functions.
Is this a migrated database?
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...
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...
August 30, 2011 at 6:35 am
August 30, 2011 at 6:13 am
Viewing 15 posts - 2,806 through 2,820 (of 5,394 total)