Viewing 15 posts - 2,206 through 2,220 (of 2,452 total)
some food for thought 😀
-- create some data
with produce (id,fruit, varieties)
as (
SELECT 101,'Apple', '3' UNION ALL
SELECT 101,'Banana', '2' UNION ALL
SELECT 102,'Orange', '1' UNION ALL
SELECT 103,'Melon' ,'2'...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 12, 2011 at 4:02 am
LutzM (9/8/2011)
You could use your design approach (which I consider to be valid btw) and create views to...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 9, 2011 at 7:35 am
this article should get you started
http://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 9, 2011 at 2:12 am
We can lift ourselves out of ignorance, we can find ourselves as creatures of excellence and intelligence and skill.
🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2011 at 1:37 pm
Hi clubbavich
good luck....I will also be watching this thread for any further posts 🙂
whilst I might not have been able to directly help you..... I have expanded my (very...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2011 at 12:24 pm
ok...sorry 😛
a few ideas
http://www.4waysolutions.co.uk
www,greymatter.com
there are many others
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2011 at 9:50 am
http://lmgtfy.com/?q=SQL+Server+2008+Standard+5+cal+UK+prices
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2011 at 8:24 am
JBANKO (8/30/2011)
But then again thats what I get paid to figure out.Joe B
ok...forgive me if I have missed some posts, but I do not see any set up scripts or...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 6:23 pm
Have been playing around a little more and was keen to see if any improvement could be made on SQL 2008 R2...especially getting the server AND device\max date
ended up with...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 2:31 pm
I have run Jeff's code on two different machines both with 2008R2 (both dev ed)
and I cannot get the results he did.
My results are almost identical to MM's and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 10:55 am
Debra
sorry that I have been unable to help you.
you mentioned a text file...if you care to post it I will try and take a look later.
kind regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 8:18 am
nairdeepa (9/5/2011)
thanks..
debra
....do we assume data is coming later?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 7:01 am
nairdeepa (9/5/2011)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 4:19 am
...I dont have much time either.
looking again at your logic isnt this just a simple update along the lines of
UPDATE TMPDATA
SET order_attribution =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 3:45 am
debra
please provide some test data that fully demonstrates your problem
in this format please:
INSERT INTO [dbo].[TMPDATA]([client_order_number], [order_date], [session_start_time], [mmc_vendor], [mmc_placement], [mmc_item])
SELECT N'H4246723', 20100813, 20100813111301, N'email', N'_bmuy', N'welcom' UNION ALL
SELECT N'H4246723',...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 5, 2011 at 3:21 am
Viewing 15 posts - 2,206 through 2,220 (of 2,452 total)