Viewing 15 posts - 46 through 60 (of 2,451 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...
January 2, 2018 at 5:53 am
December 29, 2017 at 10:48 am
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/
December 24, 2017 at 8:08 am
use SUM with GROUP BY invoiceno, cust_name,HSN
December 21, 2017 at 10:50 am
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 <> '';
December 19, 2017 at 8:58 am
December 19, 2017 at 7:07 am
December 18, 2017 at 11:07 am
December 16, 2017 at 10:43 am
December 16, 2017 at 7:22 am
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...
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,...
December 15, 2017 at 11:45 am
Viewing 15 posts - 46 through 60 (of 2,451 total)