Viewing 15 posts - 31 through 45 (of 1,082 total)
You have two problems with the query.
1 you covering index only covers the columns in the where clause and not the columns in your output clause so you will get...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 13, 2009 at 5:31 am
try this:
CREATE TABLE purchase --table:
(Date DATETIME,
Location VARCHAR(100),
Purchase_id INT)
INSERT INTO purchase
SELECT '2009-12-24', 'Dadar', 123
CREATE TABLE Item --table:
(Item_name VARCHAR(100),
Item_id INT)
INSERT INTO Item
SELECT 'Laptop', 21 UNION ALL
SELECT 'Mouse', 22 UNION ALL
SELECT 'Speaker', 23
CREATE...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 8, 2009 at 6:12 am
WOW.
Lynn that is some awesome code. Very clever and very fast 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 2, 2009 at 10:05 am
Depending on how you system works you might need to make this dynamic as you may get more years creeping in for example 2009/2010/2011 ect.
if you need more help just...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 2, 2009 at 6:36 am
Because you using a case sensitive coalation so the query checks for case sensitivity
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 2, 2009 at 6:20 am
try this:
select *
from customer
where surname = LOWER(surname) COLLATE SQL_Latin1_General_CP1_CS_AS
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 2, 2009 at 6:08 am
Could you provide us with the actual queries please.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 1, 2009 at 10:08 am
you could also use this for the surname:
SUBSTRING(@nam,LEN(@nam) - charindex(' ',@nam),LEN(@nam))
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 1, 2009 at 9:40 am
Have you tried this.
taking the above post as base code.
REVERSE(left(REVERSE(@nam), charindex(' ',REVERSE(@nam))-1))
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 1, 2009 at 9:37 am
Ok I'm gonna guess and say that some of those nested correlated queries are going to kill you.
However please could you attach the Actual Graphical Execution plan (*.sqlplan) as a...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 30, 2009 at 10:20 am
Ok here is an example of some code, it doesn't look up from a table but I think the formula is what you will be interested in.
DECLARE @Year INT
DECLARE @Month...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 29, 2009 at 10:35 am
If you using 2000 you can't use include...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 29, 2009 at 5:24 am
As far as know you can't use the INCLUDE in SQL 2000
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 29, 2009 at 4:06 am
I must have missed something but I didn't see the op defining the input. The output rule is all that was defined.
If you now the values are going to be...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 26, 2009 at 10:28 am
timscronin (6/26/2009)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 26, 2009 at 10:08 am
Viewing 15 posts - 31 through 45 (of 1,082 total)