Viewing 15 posts - 1,186 through 1,200 (of 1,468 total)
NineIron - Thursday, April 13, 2017 4:14 AMDesNorton,
What specifically am I to look for in the results of this query?
If you get...
April 13, 2017 at 5:53 am
April 12, 2017 at 12:52 pm
Folks,
I have inherited a table with 80K-100K records. Mostly, patient demographic data so, the columns...
April 12, 2017 at 12:49 pm
April 12, 2017 at 12:02 pm
reported as spam
April 12, 2017 at 7:58 am
Your problem is that you have not initialised your variables.
DECLARE @body2 NVARCHAR(MAX);
SET @body2 = @body2 + N'"Hello World"';
SELECT @body2; -- Returns...
April 11, 2017 at 11:36 am
Let's start with the CTE (Common Tbale Expression)
Because there is no guarantee that there are no gaps in the value of id in tbl_Client (even if it is an...
April 11, 2017 at 5:04 am
A small tweak to your code will get you what you are looking for
SELECT
data.AcctNum
, data.EffDate
, data.InactiveDate
FROM...
April 10, 2017 at 10:36 pm
In your ORDER BY, you need to
replace ORDER BY CASE WHEN (tc.id %@rownumber) = 0 THEN 1 ELSE (tc.id %@rownumber) END
with ORDER BY CASE WHEN (tc.id...
April 10, 2017 at 1:19 pm
April 10, 2017 at 4:18 am
Here's my shot at the problem using the technique that Luis and I...
April 9, 2017 at 11:57 pm
You are right, my bad, it was bnd_id, not no
I thought it was a...
April 9, 2017 at 12:00 am
April 8, 2017 at 2:16 pm
Please do not cross post.
This post is a duplicate of https://www.sqlservercentral.com/Forums/FindPost1869698.aspx
April 8, 2017 at 1:23 am
April 8, 2017 at 1:21 am
Viewing 15 posts - 1,186 through 1,200 (of 1,468 total)