Viewing 15 posts - 136 through 150 (of 345 total)
If your comma-separated lists are uniform, then you could search them like this
select * from #Temp
where ',' + Client_List + ',' like '%,9,%'
But only you can know if it will...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 14, 2011 at 10:08 am
Came across this: http://i.imgur.com/dsCw0.gif
As an ex-teacher, I love stuff like this that explains/shows the meaning behind these numbers and symbols.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 10, 2011 at 12:01 pm
tripri (9/8/2011)
Query:
select name , ' Geo: ' + Geo + ' Sci: ' + Sci
from name
Error:
Msg 245, Level...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 8, 2011 at 12:23 pm
Add a new column in table1 called something like "DuplicateOf" which contains the uniqueidentifier of the row it was copied from. Now you can join table2 to this new column...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 6, 2011 at 12:09 pm
Salil-386686 (9/2/2011)
HiI think this would be a better bet
select * from Form where FromID not in(3,4)
Thanks
Salil
Clearly, this is the way to do it:
select f.*
from @form f left join
(select 3 a...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 2, 2011 at 10:23 am
david 98157 (8/29/2011)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 2, 2011 at 7:48 am
What would be the logic to populate those values?
Do you already have the columns defined?
Is the start value a running total?
That takes care of #2, but the important question being...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
September 1, 2011 at 3:01 pm
Seconded. A good setup gets your question answered quickly. With tested code! 😎
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 31, 2011 at 2:14 pm
ColdCoffee (8/31/2011)
select ColA, ColB
from TestTable
order by isnull( ColA , ColB) ,
case when ColA is not...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 31, 2011 at 1:27 pm
Nice shot, CC. You got there seconds before me 😉
select * from TestTable
order by
ISNULL(ColA, ColB) + ISNULL(ColB, ColA)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 31, 2011 at 1:16 pm
Case when ISNULL(Field1,0) = 0 then 0 else 1 end +
Case when ISNULL(Field2,0) = 0 then 0 else 1 end +
Case when ISNULL(Field3,0) = 0 then 0 else 1 end...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 31, 2011 at 8:24 am
nairdeepa (8/30/2011)
the only problem i see though i have not tried this.is that it might update everything..and i want only the last one to be updated
Umm...when we say "try this"...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 31, 2011 at 7:15 am
Give this a try:
update a
set order_attribution = 'Y'
from TMPDATA a
where
mmc_vendor = 'email'
and mmc_placement = '_bmui'
and exists (
select 1
from TMPDATA b
where
b.session_start_time > a.session_start_time
and b.mmc_vendor = 'free_search'
)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 30, 2011 at 2:25 pm
So far what i did is...I loaded all the 100 files into one table as a a single column using for each loop.
You don't want to do this because now...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 29, 2011 at 9:37 am
It's called the Dunning–Kruger effect http://en.wikipedia.org/wiki/Dunning%E2%80%93Kruger_effect
We had a kid a few years out of college who couldn't program his way out of a wet paper bag, and yet couldn't tell...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
August 24, 2011 at 9:46 am
Viewing 15 posts - 136 through 150 (of 345 total)