Forum Replies Created
Viewing 15 posts - 1,261 through 1,275 (of 1,469 total)
-
RE: Use variable in the Identity Seed of create table
2 Possible options ...
DECLARE @SeedVal INT = ISNULL((SELECT LID_ID_NB from LastIDNumber WHERE LID_KET_NM = 'TableName'), 0) +1;
DBCC CHECKIDENT ( TableName, RESEED, @SeedVal ) WITH... -
RE: Is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
walter.dziuba - Friday, February 10, 2017 11:41 AM -
RE: Based on Min Timestamp get ID
SELECT TOP(1) ID
FROM YourTable
ORDER BY StartDate DESC; -
RE: modifying a 'replace' function to use Lower and Upper
briancampbellmcad - Friday, February 3, 2017 7:06 AM
If the fields in this screenshot are declared as NVARCHAR, it shows...
-
RE: modifying a 'replace' function to use Lower and Upper
briancampbellmcad - Monday, February 6, 2017 11:05 AM -
RE: modifying a 'replace' function to use Lower and Upper
Lowell - Thursday, February 2, 2017 12:10 PM -
RE: modifying a 'replace' function to use Lower and Upper
Also note that the input parameter to the function should be declared as NVARCHAR
-
RE: Merge multiple .sql files into one single file
lewisdow123 90045 - Thursday, February 2, 2017 1:48 AM -
RE: Merge multiple .sql files into one single file
You can create a batch file that will merge them for you.
Create a file called SomeName.BAT
Add the following content, and then simply Double-Click the .BAT file -
RE: How can I prevent a record from appearing based on two columns
crmitchell - Wednesday, February 1, 2017 2:54 AMRE: How can I prevent a record from appearing based on two columns
However ....
When comparing varchars
'100' < '99'RE: Error: Msg 529, Level 16, State 2, Line 4 Explicit conversion from data type datetime2 to float is not allowed.
drew.allen - Monday, January 30, 2017 2:43 PMRE: Error: Msg 529, Level 16, State 2, Line 4 Explicit conversion from data type datetime2 to float is not allowed.
Tn37355 - Monday, January 30, 2017 2:02 PMRE: convert column to rows
This will unpivot the data, but the column names may need some tweaking
declare @test-2 as table (
ID int
, Title varchar(7)
, StageName...RE: Error: Msg 529, Level 16, State 2, Line 4 Explicit conversion from data type datetime2 to float is not allowed.
declare @t as table (
initial_date_time smalldatetime
);insert into @t values('2017-01-30 15:05:00'), ('2017-01-30 15:22:00'), ('2017-01-30 15:37:00'), ('2017-01-30 15:54:00')
select
case
when RIGHT('0'+cast(DATEPART(mi,initial_date_time)...Viewing 15 posts - 1,261 through 1,275 (of 1,469 total)
