Viewing 15 posts - 1,156 through 1,170 (of 4,820 total)
June 4, 2018 at 12:11 pm
One option might be to populate a global temp table (name starts with ## instead of just #) with the ID values you are getting, and then LEFT OUTER JOIN...
June 4, 2018 at 11:26 am
How about posting the table create statements you can get from scripting out the table in SSMS. That should help us figure out why you keep failing. Also post the...
June 4, 2018 at 11:12 am
June 4, 2018 at 11:00 am
June 1, 2018 at 2:04 pm
Well, it figures. Just when I think I've got it nailed down and just needed a quick clue, I figure it out and dropped the unnecessary index and I'm back...
June 1, 2018 at 2:02 pm
June 1, 2018 at 1:25 pm
June 1, 2018 at 1:02 pm
You'll need a cursor to iterate through the tables, 1 by 1, using dynamic SQL and sp_executeSQL, I'm pretty sure there's no other alternative. Not sure I would want to...
June 1, 2018 at 12:58 pm
Does anyone know or suggest a way to extract column information from the Json...
June 1, 2018 at 12:54 pm
June 1, 2018 at 12:50 pm
June 1, 2018 at 12:03 pm
jwmott - Thursday, May 31, 2018 2:01 PMThank you gentlemen.
You're welcome.
June 1, 2018 at 11:57 am
SELECT CS1.ScoresID, CS1.[Type], CS1.AG AS AgeGroup, CS1.CompNum, CS1.LastName, CS1.FirstName,June 1, 2018 at 11:39 am
Viewing 15 posts - 1,156 through 1,170 (of 4,820 total)