Luis Cazares

Forum Replies Created

Viewing 15 posts - 2,056 through 2,070 (of 8,731 total)

RE: Need some help with query

And here's an example based on that article (you'll need to complete it):
SELECT machine_id,
type_id,
MAX( CASE WHEN attribute_name LIKE 'issuer%' THEN attribute_value END)...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 12, 2016 at 7:32 am

#1906114
RE: Are the posted questions getting worse?

Lynn Pettis (10/11/2016)
Ever get the feeling that you are being used to do someone else's job for free?
When that happens, I stop working.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 1:40 pm

#1905979
RE: Today's Random Word!

djj (10/11/2016)
Ed Wagner (10/11/2016)
Hugo Kornelis (10/11/2016)
Kaye Cahs (10/11/2016)
Manic Star (10/11/2016)
djj (10/11/2016)
Ed Wagner (10/11/2016)
Hugo Kornelis (10/10/2016)
Luis Cazares (10/10/2016)
crookj (10/10/2016)
Shape
Square
Attend me
Devices
Switch
Off
Duty
Free
Will
Last
Least
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 12:16 pm

#1905966
RE: Recursive loop

What are you checking? Why do you need it to be recursive?
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 12:16 pm

#1905964
RE: Are the posted questions getting worse?

Y.B. (10/11/2016)
Ok, I think I might be going crazy but I've never seem to have any issues with html encoding when posting code before. However, for some reason I'm...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 10:14 am

#1905934
RE: Performance issue when testing the value of ROW_NUMBER in a WHERE clause

There's not enough information to give an accurate response, check the following that might help.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 10:12 am

#1905933
RE: search date in stored procedure

Why do you think that converting to nvarchar will make things better?
What type is DateReceived in Reassessments table?
Are you storing time in DateReceived? '2016-10-11' is not the same as '2016-10-11...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 7:20 am

#1905883
RE: Introducing the Set-based Loop

John Hick-456673 (10/10/2016)
No, I understand the problem and I have seen this solution before.
Uncommenting the loop returned the same results because the loop is supposed to run only...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 11, 2016 at 6:28 am

#1905870
RE: Today's Random Word!

crookj (10/10/2016)
Shape
Square
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 2:06 pm

#1905779
RE: Introducing the Set-based Loop

hjp (10/10/2016)
Luis, one question to your solution: Isn't it "unsafe" to rely on @@ROWCOUNT?
I experimented with this sort of code in the summer, but settled for a different approach due...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 12:24 pm

#1905746
RE: Extract a uniform pattern from a file path

This might be is simpler.
DECLARE @INPUT_STR VARCHAR(1024) = '\\cc0dware01\BMF\RMS\REBATERATES-WORKING-2016ToEnd08-20160905180112.csv';
SELECT SUBSTRING( @INPUT_STR, LEN( @INPUT_STR) - 17, 14);
I wonder what are the varying parts of the file path. Is it only the...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 9:32 am

#1905690
RE: Introducing the Set-based Loop

Asavko (10/9/2016)
Good technical information is provided by there is no need in a technical article to offend programmers with procedural programming background. It is not professional.
I'm sorry, it's not intended...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 6:45 am

#1905646
RE: Introducing the Set-based Loop

pradeepcse.t (10/7/2016)
This could be slower when you have complex business logic in Join or Where condition
Yes, every bit of additional work will make the solutions slower. But if it makes...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 6:39 am

#1905644
RE: Introducing the Set-based Loop

John Hick-456673 (10/7/2016)
Please try this after commenting out this line:
--WHILE @@ROWCOUNT > 0 --Update until there's no previous group for any Client
I believe that you will find no difference.
You might...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 10, 2016 at 6:37 am

#1905641
RE: Introducing the Set-based Loop

marcceloselv (10/7/2016)
Maybe change the CTE recursion for a temporary table (#table), whould change the game.
Can you show me what do you mean with some code? I'm not sure what you...
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2

October 7, 2016 at 11:59 am

#1905442

Viewing 15 posts - 2,056 through 2,070 (of 8,731 total)