Viewing 15 posts - 2,401 through 2,415 (of 2,452 total)
....IIf([T Shipments].[SH PU Rcvd Web 0/1]=1,[T Shipments].[SH PU Rcvd Web 0/1],0)) AS [Depart PU EDI], IIf([T Shipments].[SH Arv D Loc EDI 0/1]=1....
Look up CASE statement IN BOL
untested code:
CASE [T Shipments].[SH...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 11, 2009 at 4:23 am
what was the correct answer?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 3:46 pm
can you please us show the results you are expecting
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 2:56 pm
GSquared (8/10/2009)
cthariharan (8/10/2009)
You are working as a garbage man ???????
Nope. I'm providing that as a "useful answer".
I play online games professionally, and have a hoby of spending 8-9 hours...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 1:18 pm
As Matt already mentioned ...not sure what you require as results
try this
SELECT Specialty, Team, Code1 AS Code
FROM ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 12:53 pm
trackingraj (8/10/2009)
I'm working as a developer in filenet technology.
is that document management and image processing ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 12:19 pm
Have you tried the SQL Import and Export Wizard?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 12:17 pm
trackingraj (8/10/2009)
Hi,I'm working as a developer in some technology. My technology is an old one and having less opportunity. So I want to change my technology and job.
What are you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 12:13 pm
Getting back to the descision on that... there's always AVG. :hehe: Actually, is there a way to get the entry time on the date entered column? If...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 11:41 am
Hi
Please dont think I am being rude....but perhaps if you gave us a little more information on ......
the data source and type
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 10, 2009 at 11:13 am
On the cost thing... My executive decision would be to show both the lowest and highest costs in the case of ties and let someone else make the decision. 😛
.
Heh..can...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 9, 2009 at 3:00 pm
Mr Moden...first of all thank you for your generous comments on the set up data...:blush:...It did take some effort to create and double check before posting but as your article...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 9, 2009 at 1:06 pm
any good?
SELECT dt, DATEADD(dd, - DAY(DATEADD(m, 1, dt)), DATEADD(m, 1, dt)) AS EOM
FROM dbo.MyCalendar
regards Graham
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2009 at 10:56 am
The "Create Some Data" part of the "tutorial" is complete gibberish since it avoids showing how to assign static values to ANYTHING! (Kee-rist, who comes up with this...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2009 at 10:26 am
Thank You Gah for the heads up. I hope this is better.
suggest you dont reply by editing original post...it will get missed.
try this
SELECT Ref#,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 6, 2009 at 8:01 am
Viewing 15 posts - 2,401 through 2,415 (of 2,452 total)