Forum Replies Created
Viewing 15 posts - 3,991 through 4,005 (of 5,109 total)
-
RE: SSMS Tips - Text Results
use this shortcut accidently all the time, too used to using it for a new tab in Firefox, which my brains translates to "new Query tab" in SSMS every now...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Import AdventureWorks2012_Database.zip to SQL Server 2016
flash_os - Tuesday, April 4, 2017 9:55 PMStill I have a problem: 🙁
The error is telling...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Update SQL with excel files?
stino - Tuesday, April 4, 2017 11:09 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Update SQL with excel files?
What are you using to join your two tables? There appears to be no ID field in your data, so how do you know Peter? Vanderbroek is Peter vdb?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Need to update Price based on partial comparison of one column vs another ?
With no sample data, this is a little difficult. At a guess, maybe something like...
DECLARE @Newprice decimal(12,2), @SKU varchar(10);
--Assume you provide the SKU so that it...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: UPDATE Field in multiple rows using another table
On a separate note I would also suggest using a JOIN clause, rather than a CROSS APPLY and then doing the matching in your WHERE clause:
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Import AdventureWorks2012_Database.zip to SQL Server 2016
Yes, the database will just run in compatibility mode 110, as it is a SQL 2012 database.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: SELECT output formation
kevv - Tuesday, April 4, 2017 6:13 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Are the posted questions getting worse?
jasona.work - Tuesday, April 4, 2017 5:55 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: SELECT output formation
I could be missing the point entirely here, but do you mean something like this?
USE DevTestDB;
GOCREATE TABLE example
(id int IDENTITY,
...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk -
RE: Can you reorganize this SQL stmt please ?
mw112009 - Monday, April 3, 2017 4:13 PMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Help me rearrange the SQL statement - It works but ?
mw112009 - Monday, April 3, 2017 12:03 PMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Help me rearrange the SQL statement - It works but ?
ChrisM@home - Monday, April 3, 2017 11:54 AMThom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: Help me rearrange the SQL statement - It works but ?
For my own sanity, and probably others:
SELECT CLAIM.DClaim.FormNbr, CLAIM.DClaim.AdmitDate, CLAIM.DClaim.Membernbr,
CLAIM.DClaim.TotalNetAmt, DClaim_1.TotalNetAmt AS TotalNetAmt2,
CLAIM.DClaimServiceLine.NetAmt, CLAIM.DClaimServiceLine.ProcedureCode,
...Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.ukRE: passing tableName as a variable in stored prcoedure
anjaliagarwal5 - Monday, April 3, 2017 9:47 AM
