Viewing 15 posts - 2,401 through 2,415 (of 8,754 total)
drew.allen - Monday, January 30, 2017 11:11 AMUnless I'm missing something, it's very simple.
SELECT *
FROM #T
WHERE PrescriptionID < DuplicatePrescriptionIDDrew
January 30, 2017 at 11:26 am
Have you checked the connection configurations?
😎
January 30, 2017 at 10:47 am
Can you post the DDL (create table) script, sample data as an insert statement and the expected results please?
😎
January 30, 2017 at 10:44 am
Can you elaborate a little bit further on the problem and the expected output, not entirely clear what you are after?
😎
Quick suggestions, not certain though
January 30, 2017 at 10:39 am
Joe Zonum - Monday, January 30, 2017 10:00 AM
First thought would...
January 30, 2017 at 10:10 am
IIRC, there was a connect item for this error for 2008 SP1, had to do with a registry key "ConfigurationState"
😎
January 30, 2017 at 10:06 am
Almost the same as John pointed out but performs better
😎
CREATE table #TempTable
(
regioncountry varchar(50),
sserver Varchar(50)
)
insert into...
January 30, 2017 at 9:56 am
I have an SQL 2012 standard ED. and also have SSDT 2015 installed....
January 30, 2017 at 9:47 am
I have trawled the website looking for a previous post similar to the...
January 30, 2017 at 4:21 am
January 30, 2017 at 3:27 am
January 29, 2017 at 6:15 am
Quick thought, looks like an SSMS error, not an SQL error. Do you have a lot of stuff running/plenty of ram/long time since last restart etc.?
😎
January 28, 2017 at 9:47 am
BrainDonor - Friday, January 27, 2017 1:30 AM
Got one, now my previous client want's the one that was wearing it 😀
January 28, 2017 at 8:36 am
My bad with the DATEFROMPARTS method, here is a correct version with the integer math
😎,DATEDIFF(MONTH,@Birth,DATEFROMPARTS(YEAR(@Service),1,1)) / 12 AS DFPAgeAsOfJanFirst
Again and as always, you...
January 28, 2017 at 8:32 am
Viewing 15 posts - 2,401 through 2,415 (of 8,754 total)