Viewing 15 posts - 811 through 825 (of 2,452 total)
does this help at all
http://www.sqlservercentral.com/Forums/FindPost1774146.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 14, 2016 at 1:54 am
just curious....how many rows/columns in the Access table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2016 at 11:18 am
not sure what the OP wants....keeps peeping out from behind the sofa each day and logs on......but never replies 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 13, 2016 at 8:51 am
RV16 (4/12/2016)
output would be:1/19/2016 ?? ??? ?????
ok...so thats the output....what was the "input" for this result....(you have said that it is datetime datatype)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 12, 2016 at 2:56 pm
have you got an example of a datetime that is creating this problem?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 12, 2016 at 2:34 pm
here is the original post set up for SQL
USE tempdb
GO
IF OBJECT_ID('tempdb..TABLE1','U') IS NOT NULL
DROP TABLE TABLE1;
IF OBJECT_ID('tempdb..TABLE2','U') IS NOT NULL
DROP TABLE TABLE2;
CREATE TABLE Table1(
callID_T1 ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 12, 2016 at 12:44 pm
Jeff Moden (4/11/2016)
J Livingston SQL (4/11/2016)
if there are millions of rows as suggested then it would be good...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2016 at 4:19 pm
It would be appreciated if the OP can post some sample data etc.
if there are millions of rows as suggested then it would be good to see some performance testing.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2016 at 3:38 pm
amitsingh308 (4/10/2016)
Yes I want to count each item in each order and assign serial number to each item.
no idea really, because you haven't given us your expected results based on...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 11, 2016 at 2:00 am
i'll throw this out here
make of it what you will and see how you get on.....no claims on performance or accuracy, need you to review to see if it what...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 9, 2016 at 12:02 pm
can you please post create table / insert data scripts and expected results based on your sample data
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
April 9, 2016 at 5:09 am
well...I am no Access expert, but I am guessing that Access is pulling all 6 million rows into your access app in the first instance.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2016 at 10:24 am
GrassHopper (4/8/2016)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2016 at 9:57 am
SQL_Surfer (4/8/2016)
Can you give me some examples?
not sure if this is what you want....tis always good to detail expected results, saves time and confusion
SELECT CASE WHEN ColumnaName = 'CustomerGroup' THEN...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 8, 2016 at 7:32 am
is there any primary key or a unique index on your SQL table?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
April 7, 2016 at 3:05 pm
Viewing 15 posts - 811 through 825 (of 2,452 total)