Viewing 15 posts - 1,021 through 1,035 (of 8,731 total)
ilay.siva - Thursday, August 17, 2017 12:27 PMStuck with 2 things here.
9. ______.b.c.d - Across
8. a.b.______.d - Down.Any clues ?
a.b.c.d...
August 17, 2017 at 1:18 pm
You need to check your rCTE. You're not using its capabilities and could simply use the table without CTE for your update. Read the examples that Chris and I posted...
August 16, 2017 at 1:46 pm
Are you looking for something like this?
WITH rCTE AS (
SELECT [NewLevel] = 1,
ID,
ParentID,
[Name],
...
August 16, 2017 at 12:37 pm
August 16, 2017 at 8:00 am
There seems to be something missing there, but I'm not sure what would it be without sample data. I wrote an article about a similar problem some time ago, it...
August 16, 2017 at 7:48 am
John Corkett - Wednesday, August 16, 2017 1:51 AMHi
What's the easiest way of filling the crosswords in short of printing it out?Thanks
I...
August 16, 2017 at 7:13 am
August 14, 2017 at 7:02 am
This might help you.
http://www.sqlservercentral.com/scripts/T-SQL/117890/
August 14, 2017 at 6:41 am
Just found the following code. This is what happens when a procedural developer starts writing T-SQL. Fortunately, some learn to stop the non-sense.
--Variables names changed
August 11, 2017 at 11:35 am
August 11, 2017 at 8:17 am
August 11, 2017 at 8:11 am
August 11, 2017 at 7:17 am
TheSQLGuru - Thursday, August 10, 2017 12:05 PM2) CASE is your friend!!! Learn to use it!
Just curious. How would you use CASE...
August 10, 2017 at 12:29 pm
By the way, the execution plan attached is only for the following statement.set statistics time, io on
In other words, it's useless.
August 10, 2017 at 11:46 am
Viewing 15 posts - 1,021 through 1,035 (of 8,731 total)