Viewing 15 posts - 1,171 through 1,185 (of 2,452 total)
SQLRNNR (7/22/2015)
Moreau
Scaramouche
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 22, 2015 at 1:39 pm
darren-hong (7/17/2015)
Hi Thanks for your help.Could u include Insert statement as well ?
uncomment this line
--INTO ATABLE
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 17, 2015 at 10:20 am
as an idea
SELECT TOP 100
LocID = 1 + CAST(ABS(CHECKSUM(NEWID()) % 9) AS int),
SerialNo = 'SN-' + CAST(ABS(CHECKSUM(NEWID()) % 90000) AS varchar(5)),
KeyID = CHAR(ABS(CHECKSUM(NEWID()))...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 17, 2015 at 10:05 am
can we assume that the dummy records are all to be different eg different dates/serial numbers etc but in the format you describe?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 17, 2015 at 7:08 am
to make it easier for others...here is your source data from fiddle
CREATE TABLE [dbo].[SourceData](
[WeekNum] [nvarchar](128) NULL,
[MONTH] [varchar](50) NULL,
[Abs_Status]...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 16, 2015 at 7:06 am
I'll throw this in for discussion
-- some test data
SELECT TOP 10000
ProdID = 1 + CAST(Abs(Checksum(Newid()) % 9 ) AS INT),
SalesQty =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 14, 2015 at 9:54 am
Welsh Corgi (7/13/2015)
I can copy and paste but not the whole line when I try and scroll.Could you please place the code outside of the CQL Code Tag?
Thanks.:-)
Drews code for...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2015 at 11:06 am
I can't copy sand paste the code.:blush:
browser issue?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2015 at 10:06 am
edit>>>
why not provide simple create table / insert data scripts that explains your issue......this can be sorted very quickly I am sure
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2015 at 9:41 am
dont know if this will help, but have you seen this
http://saltydogllc.com/in-visual-foxpro-using-32-bit-odbc-drivers-on-a-64-bit-machine/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 13, 2015 at 8:26 am
assuming you are using Ed's solution....suggest that you script out the data you have inserted into the exmaple tables he gave you....(eg INSERT )
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2015 at 10:43 am
an idea
SELECT
sum(case when sumla < 5000 then 1 else 0 end) as LT5K
,sum(case when sumla >=5000 and sumla < 10000 then 1 else 0 end) as GT5kLT10k
,sum(case when...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 11, 2015 at 10:21 am
BallaKet (6/15/2015)
Hello,I need to convert an MS Access 2013 database to an MS SQL database (2008 R2 or 2012).
I appreciate any help.
Thanks!
MK
Why?
you dont provide any details on how this...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 7, 2015 at 2:37 pm
quick idea........self join the table eg A.ID+1 = B.ID
but the question is why alter the exg data to NULL
....what is the benefit / business reason.....why cant a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 5, 2015 at 3:59 am
farrukhhameed786 (7/4/2015)
I have already post the insert/create table results excel file in winrar compress folder . I don't know. Why people afraid to open that it is not a...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
July 4, 2015 at 1:17 pm
Viewing 15 posts - 1,171 through 1,185 (of 2,452 total)