Viewing 15 posts - 31 through 45 (of 2,452 total)
as a side issue what is the datatype for [ie].[DateTime]
am just wondering what this bit of code is for?
CONVERT(varchar(10),REPLACE(CONVERT(varchar(10), [ie].[DateTime],101),'/','-')) AS [Void_Date]
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Data Tab > queries and connections >> right click your query >edit
New Query editor opens....Home tab > advanced editor.
hope this helps
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
xtrmus2319 - Thursday, January 25, 2018 3:04 AM
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
for clarification please.......if you use these dates 1st October 2017 to 31 December 2017 for your report and a customer has orders in Oct and Dec but not in...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
wild guess.....
SELECT ABS(id)
FROM yourtable
GROUP BY ABS(id)
HAVING(COUNT(DISTINCT grp) > 1);
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
first off...please read this link https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ You will be surprised how you get faster and better answers by following the advice.
secondly why return -102 and not 102?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
some sample data would help please.....your question doesnt really make any sense without data that shows your problem
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
richardmgreen1 - Friday, January 5, 2018 6:59 AM
still waiting 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
khpcbgnt - Wednesday, January 3, 2018 1:42 PM
....and what solution have you decided to use?....tis a two way...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 15 posts - 31 through 45 (of 2,452 total)