Viewing 15 posts - 5,056 through 5,070 (of 7,191 total)
Please will you show expected results for your sample data. It's not clear whether you're looking for the highest high or the highest high for each individual index code.
Thanks
John
September 30, 2011 at 4:49 am
Jnrstevej (9/30/2011)
some of the syntax used does not seem to work.
Steve
Please will you be a bit more specific. Error messages? Unexpected results?
Thanks
John
September 30, 2011 at 4:03 am
Try what I suggested and UNION it with the rows with NULL in ColC. Still waiting for the DDL and sample data so that we can visualise and test...
September 29, 2011 at 3:49 am
It's difficult to work out what you require from your description, but it sounds like you just need to add WHERE particular_column IS NOT NULL to the end of your...
September 29, 2011 at 2:58 am
My advice would be not to be put off by the job description. Most recruiters ask for the moon on a stick, but they don't (or shouldn't) expect to...
September 28, 2011 at 7:34 am
prakash 67108 (9/28/2011)
he needs only india and iran...why should we go for other countries..?
ashuthinks (9/28/2011)
i need to select name and region of the countries in the regions containing 'India', 'Iran'.
Using...
September 28, 2011 at 7:11 am
prakash 67108 (9/28/2011)
yes, Ratheesh is correct...may be you select wrong column...
just use select name,region from bbc where name in ('india', 'iran')
No, because this doesn't return the other countries in the...
September 28, 2011 at 4:31 am
First, select the region(s) where name is India or Iran. Then join back to the table to get the other names with the same region(s). If you provide...
September 28, 2011 at 3:41 am
Jpotucek (9/11/2008)
Also, Is there a way to get 'SQL' uptime? like individual database uptime?
That is 'SQL' uptime. tempdb is created when, and only when, SQL Server is restarted.
John
September 28, 2011 at 3:37 am
ashuthinks (9/28/2011)
something it wrong
Care to be more specific?
Your query will return only rows where region is equal to 'India' or 'Iran'. If you want rows that contain certain...
September 28, 2011 at 3:27 am
Yes. Now if you give us some more details, we may be able to help you in doing so.
John
September 28, 2011 at 3:22 am
Please will you show us the DDL for both tables (including constraints), and some sample data.
Thanks
John
September 28, 2011 at 3:17 am
Not in SQL, as far as I know. But you could write some VB and embed it in the workbook so that the format is changed whenever the cell...
September 28, 2011 at 2:05 am
So you only want one row returned for each unique combination of those two columns? How are you going to decide which row that will be when there's more...
September 28, 2011 at 1:48 am
What do you mean maintained but not updated? How do you know the index hasn't been used?
John
September 27, 2011 at 6:55 am
Viewing 15 posts - 5,056 through 5,070 (of 7,191 total)