Viewing 15 posts - 46 through 60 (of 2,452 total)
maybe,,,,,,
DECLARE @test-2 TABLE (
coltoconvert varchar(20)
);
INSERT INTO @test-2 (coltoconvert )
VALUES ('123') ,('665584'),('13.4'),('16.8.7')
SELECT coltoconvert,TRY_CONVERT( INT, coltoconvert)FROM @test-2;
SELECT coltoconvert,TRY_CONVERT( DECIMAL(18,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
January 2, 2018 at 5:53 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 29, 2017 at 10:48 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 26, 2017 at 7:24 am
try this ....lots of solutions if you care to search on the web.
https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 24, 2017 at 8:08 am
hi....please take a look here 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
December 22, 2017 at 11:24 am
use SUM with GROUP BY invoiceno, cust_name,HSN
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 21, 2017 at 10:50 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 20, 2017 at 4:00 am
SELECT #t.OrderRecordUrnID,
s.itemnumber,
s.item
FROM #t
CROSS APPLY dbo.DelimitedSplit8K(#t.OrderRecordValue, '|') s
WHERE itemNumber = 31
AND item <> '';
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 19, 2017 at 8:58 am
@Jacek
http://utteraccess.com/forum/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 19, 2017 at 7:07 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 18, 2017 at 11:07 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
December 16, 2017 at 10:43 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 16, 2017 at 7:22 am
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 15, 2017 at 1:23 pm
autoexcrement - Friday, December 15, 2017 12:46 PMDREW = TOO SEXY
what results would you expect for this set of data?
INSERT...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 15, 2017 at 1:01 pm
fyi
DECLARE @start AS INT= 20171215;
DECLARE @end AS INT= 20180119;
SELECT CONVERT( DATETIME, CONVERT(VARCHAR(8), @start));
SELECT CONVERT( DATETIME, CONVERT(VARCHAR(8), @end));
SELECT DATEDIFF(DAY, CONVERT( DATETIME, CONVERT(VARCHAR(8), @start)),CONVERT( DATETIME,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 15, 2017 at 11:45 am
Viewing 15 posts - 46 through 60 (of 2,452 total)