Viewing 15 posts - 61 through 75 (of 607 total)
We can't see your data, but try the following:
1 - just return the charindex() and len() functions as separate fields, so you can see what the calculations are that are...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 29, 2020 at 12:44 pm
I have never understood the utility of returning the bit value from a stored procedure execution. It's too abstract of a concept to say "it worked" or "it didn't work"...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 18, 2020 at 2:55 pm
Jeff, quit torturing the poor guy and just give him the link
http://www.sqlservercentral.com/Forums/Topic530630-8-2.aspx
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 14, 2020 at 7:43 pm
Make your Final table a view instead, so that it selects the max(createdate) for each customer. That way, even when they weren't all updated at the same time, you see...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 14, 2020 at 5:40 pm
So....what in the world are you doing where you need to know how toxic Alopecia is?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 13, 2020 at 4:36 pm
I think what you're doing is a good idea, but everyone should still be thinking about what they're presenting, who is consuming it and what they want the audience to...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 13, 2020 at 4:33 pm
question is also, why is NULL allowed? Is that an issue that needs addressed so that the SUM is actually correct data? Simply because it handles the situation doesn't mean...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 13, 2020 at 4:28 pm
I feel like I'm missing something. An inner join is necessarily an existence check, why not:
SELECT u.UserId
FROM UserTable u
JOIN TableA a ON a.UserId...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 12, 2020 at 10:21 pm
Why even use a CTE? Why not just join to those tables?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 12, 2020 at 6:57 pm
impacts to me have been that I can't sit outside on the deck anymore, because the neighbor now sits on *his* deck and I have to hear his conference calls...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 11, 2020 at 2:23 pm
Bueno, la única información que tenemos es que hay una "pérdida potencial de datos", tal vez el valor de origen es demasiado largo para el destino?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 10, 2020 at 2:00 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 8, 2020 at 6:47 pm
EDI format files, 834 (Enrollment) , 820 (premiums) , 270/271 (verification files), 837 (claims remittance), etc.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 5, 2020 at 2:09 pm
"The loudest critics are always those who have the least education, knowledge, experience, and judgement to do the job themselves."
No, but that's a convenient way to dismiss people giving legitimate...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 5, 2020 at 1:16 pm
It's impossible to be "caught up", because that means you'd have to have watched all the animated series' too, cared enough to follow that but still keep track of what...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
May 4, 2020 at 8:17 pm
Viewing 15 posts - 61 through 75 (of 607 total)