Viewing 15 posts - 1,726 through 1,740 (of 2,452 total)
Alex koranteng (1/27/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2013 at 6:37 am
almany_13 (1/27/2013)
i want the entry for adding 2 value but i want show in the third cloumn all result with null value!!need ur help:-)
Hi...welcome to the site.
its a bit difficult...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 27, 2013 at 6:34 am
wtolbert (1/10/2013)
Thank you J. below is the desired output taken from a different data set that I'm looking for.
Hi...am a bit busy just at the mo....maybe someone else will...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2013 at 1:21 pm
wtolbert (1/10/2013)
bump
Hi...everyone here provides their time and expertise free of charge ....so please be patient. 🙂
It will probably help us to help you if you could provide the results you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 10, 2013 at 12:31 pm
great...look fwd to seeing the scripts
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 4:11 pm
pbaldy (1/9/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 3:47 pm
wtolbert (1/9/2013)
J I am new. Thank you for the welcome. Any pointers will be helpful. SQL Server 7, 2000 is not what I was looking for.
ok...what version...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 3:44 pm
Hi
seems you are new around here...so a big welcome ...hopefully you will find this site a friendly and helpful resource.
first off...you have posted in SQL 7 , 2000 forum...is...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 3:34 pm
suggest you search this site (and others) for "Calendar tables"....
weeks are generally peculiar to the industry/company...there is a lot of help out there if you care to read.
regards
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 9, 2013 at 3:26 pm
further reading here may give you some ideas
http://www.sqlservercentral.com/articles/Hierarchy/94040/
http://www.sqlservercentral.com/articles/T-SQL/94570/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2013 at 12:07 pm
steve.pantazis (1/7/2013)
Yes, agreed. I have a steep learning curve ahead of me, but it's necessary. Thanks again for your contribution.
Steve
may be worth your while posting some "base data examples" here...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2013 at 11:16 am
steve.pantazis (1/7/2013)
........ Long story short, we need to rewrite our aggregation routines, and it looks like you're pointing us in the right direction.
Steve
I would entirely agree with your comment and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2013 at 11:04 am
+1
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 7, 2013 at 9:17 am
CREATE TABLE [dbo].[mydate](
[mydate] [datetime] NULL
)
INSERT INTO [dbo].[mydate]([mydate])
SELECT '20121222 00:00:00.000' UNION ALL
SELECT '20121223 00:00:00.000' UNION ALL
SELECT '20121224 00:00:00.000' UNION ALL
SELECT '20121225 00:00:00.000' UNION ALL
SELECT '20121226 00:00:00.000' UNION ALL
SELECT '20121227 00:00:00.000'...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2013 at 2:29 pm
karna5999 (1/6/2013)
(even division of a decimal)
For example:$102.10 / 2
Result:-
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 6, 2013 at 2:11 pm
Viewing 15 posts - 1,726 through 1,740 (of 2,452 total)