Viewing 15 posts - 361 through 375 (of 3,957 total)
nwtsqlserv (2/11/2015)
February 11, 2015 at 5:50 pm
Dave Ballantyne (2/11/2015)
nwtsqlserv (2/11/2015)
Why is it wrong can you explain?I think there is nothing wrong in sending a comma seperated list.
Other than going through the unnecessary overhead of concatenating the...
February 11, 2015 at 5:50 pm
I have to agree with what everybody else is telling you. I believe you are establishing an "artificlal" requirement here for some reason. I cannot imagine a case...
February 11, 2015 at 5:43 pm
tomek tomek (2/11/2015)
I would be very, very greteful...
February 11, 2015 at 5:23 pm
As it turns out there is this workaround for the hyphens.
Looks like crap to me but it will probably work.
February 11, 2015 at 2:27 am
The following will remove the last row with the row count and I illustrated what I meant by the 3 part naming (assumes your schema is dbo).
atul.jadhav (2/10/2015)
DECLARE
...
February 11, 2015 at 2:12 am
You may have a tough time removing everything you want to remove, as sp_send_dbmail doesn't seem to have that level of control.
You can probably remove the first line about switching...
February 11, 2015 at 2:00 am
sqldriver (2/10/2015)
SQL_Surfer (2/4/2015)
ANSI_NULLS: True, ANSI_PADDING: True, ANSI_WARNINGS: True, ARITHABORT: True, CONCAT_NULL_YIELDS_NULL: True, NUMERIC_ROUNDABORT: False, QUOTED_IDENTIFIER: True => Through SSMS
ANSI_NULLS: True, ANSI_PADDING: True,...
February 10, 2015 at 8:29 pm
Jeff Moden (2/10/2015)
Is it an absolutely true parent/child relationship where no child can be it's own parent and that each child has one and only one parent?
Why do I sense...
February 10, 2015 at 6:15 pm
venoym (2/10/2015)
February 10, 2015 at 5:50 pm
pietlinden (2/9/2015)
SELECT N.trnID
, CommaList = STUFF((
SELECT ', ' + PrdID
FROM trnPrd P
WHERE P.trnID = N.trnID
...
February 10, 2015 at 5:41 pm
N_Muller (2/10/2015)
declare tableName table
(
uniqueid int identity(1,1),
id int,
starttime datetime2(0),
endtime datetime2(0),
parameter int
)
A stored procedure has new set of values for a given id. Sometimes the startime and endtime...
February 10, 2015 at 5:17 pm
Here's one way but whether you want to use it or not depends on what else is going on with that table.
CREATE TABLE dbo.Test
(
columnA ...
February 10, 2015 at 5:10 pm
Coincidentally I just now ran across a quite interesting article on this subject by Erland Sommerskog in his blog and since I didn't see anyone post that link here, I...
February 10, 2015 at 4:44 pm
mark.worthen (2/10/2015)
The data is structure such that children point to their parent but parents do not point to children.
Bug 1 has no idea it has any children...
February 10, 2015 at 4:38 pm
Viewing 15 posts - 361 through 375 (of 3,957 total)