rkordonsky 63916

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 36 total)

RE: I need some help with Text data type in SQL Server table.

drew.allen - Tuesday, August 28, 2018 10:34 AM
rkordonsky 63916 - Tuesday, August 28, 2018 8:59 AM

August 28, 2018 at 11:02 am

#2003660
RE: I need some help with Text data type in SQL Server table.

sgmunson - Tuesday, August 28, 2018 10:28 AM
rkordonsky 63916 - Tuesday, August 28, 2018 8:59 AM

August 28, 2018 at 10:59 am

#2003659
RE: I got date conversion error

Luis Cazares - Thursday, December 14, 2017 9:01 AM
What happens if you run the following query?

SELECT YAB
FROM UD_Indiv_Data
WHERE YAB...

December 14, 2017 at 9:22 am

#1972167
RE: I got date conversion error

Luis Cazares - Thursday, December 14, 2017 9:01 AM
What happens if you run the following query?

SELECT YAB
FROM UD_Indiv_Data
WHERE YAB...

December 14, 2017 at 9:14 am

#1972162
RE: I got date conversion error

rkordonsky 63916 - Thursday, December 14, 2017 8:26 AM
Dear colleagues,
I got a very peculiar situation. Here is my code:

Declare @startdate...

December 14, 2017 at 8:39 am

#1972155
RE: How to get TOP ID in query?

drew.allen - Tuesday, December 12, 2017 12:31 PM
rkordonsky 63916 - Tuesday, December 12, 2017 12:21 PM

December 12, 2017 at 12:34 pm

#1971820
RE: How to get TOP ID in query?

Thom A - Tuesday, December 12, 2017 11:21 AM
Add an ORDER BY clause. Data inside SQL Server isn't...

December 12, 2017 at 12:21 pm

#1971813
RE: Did anybody have this problem

Lynn Pettis - Tuesday, December 5, 2017 1:20 PM
Phil Parkin - Tuesday, December 5, 2017 12:51 PM

December 5, 2017 at 1:37 pm

#1970797
RE: Resolving many to many linkage

HappyGeek - Wednesday, November 29, 2017 11:44 PM
With all the corrections I finally used the following which to be honest I don't...

December 1, 2017 at 10:00 am

#1970318
RE: Resolving many to many linkage

John Mitchell-245523 - Wednesday, November 29, 2017 9:40 AM
rkordonsky 63916 - Wednesday, November 29, 2017 9:28 AM

November 29, 2017 at 10:42 am

#1969946
RE: Resolving many to many linkage

John Mitchell-245523 - Wednesday, November 29, 2017 8:58 AM
Thanks for providing DDL and sample data, but please test before posting.
What results are...

November 29, 2017 at 9:28 am

#1969937
RE: How to resolve one to many linkage

Phil Parkin - Wednesday, November 15, 2017 10:51 AM
There is another possibility, something like this:
WITH LatestSubscriptions
AS
(
SELECT
s.ClientID
, ...

November 15, 2017 at 11:14 am

#1968241
RE: How to resolve one to many linkage

Thom A - Wednesday, November 15, 2017 9:23 AM
drew.allen - Wednesday, November 15, 2017 9:21 AM

November 15, 2017 at 9:32 am

#1968222
RE: How to resolve one to many linkage

drew.allen - Wednesday, November 15, 2017 9:21 AM
There are two main approaches, both of which have already been suggested. Which one performs...

November 15, 2017 at 9:26 am

#1968220
RE: How to resolve one to many linkage

Thom A - Wednesday, November 15, 2017 9:10 AM
How about using a CROSS APPLY:

November 15, 2017 at 9:20 am

#1968215

Viewing 15 posts - 16 through 30 (of 36 total)