Viewing 15 posts - 1,411 through 1,425 (of 2,894 total)
I'm not going to write the sample query as there are a lot of them if you google.
I can give a bit more detailed steps of what you will...
June 18, 2012 at 6:12 am
You should read the article (link at the bottom of my signature) about how to present questions like that to help your helpers to help you 😉
create table #MyDataTable (...
June 18, 2012 at 6:01 am
okbangas (6/18/2012)
... Btw, I do hope you did not actually post an adminstrator password?
It does look like the real one to me...
So, need an IP address and off you go!
:w00t:
June 18, 2012 at 5:51 am
Full-text search.
You will need to create the view which will hold the concatenated value of columns you want to search by. Then create Full-Text index on this column and you...
June 18, 2012 at 5:49 am
What do you mean by "arraylist"? There is no such object/data type in SQL server. It's not c#!
June 18, 2012 at 5:46 am
-- return records from T1 if no records exist in T2
SELECT t1.id,
t1.Field1,
NULL as Field2
FROM T1
WHERE NOT EXISTS (SELECT 1 FROM T2)
UNION ALL
-- return records from T1 JOINED to T2
SELECT...
June 18, 2012 at 4:22 am
You can do it with FT. But it may not be fast enough for you, it's really depends...
You will need to use CONTAINSTABLE to get the best match based...
June 18, 2012 at 3:40 am
Give me all records from T1 if there is no join on T2, else just return records where they exist in both tables?
What? Return records from T1 only or from...
June 18, 2012 at 3:35 am
every line where you have
RETURN
should return the table variable.
Make sure you have the same before function end.
June 15, 2012 at 5:32 am
It's in line before the INSERT. You have used wrong type of single quote. Copy this one in:
SELECT @strErrorMessage = 'Error whilst ' + COALESCE(@strErrorMessage, 'doing something')+ ',' + COALESCE(@Description,...
June 15, 2012 at 1:37 am
There is no such object In SQL Server as Table Alias, so you can not create it by any means.
Could you please provide a bit more details about what...
June 14, 2012 at 9:33 am
You need to double your single quotes.
... like ''sbrpt%'' and c.path not like ''%Subreport%'''
June 14, 2012 at 9:23 am
Yeah, have you tried tools for working with Oracle?
After SQL Server you will not like it! In last years they became much better but still far away from SQL ones.
Plus,...
June 14, 2012 at 8:45 am
Line:
IF @hr 0
misses "="
BTW, your code looks like pot of Singaporean noodles 🙂
Try to format you code so it's easier to read. When posting to forum you can use code="sql"...
June 14, 2012 at 8:01 am
Viewing 15 posts - 1,411 through 1,425 (of 2,894 total)