Viewing 15 posts - 181 through 195 (of 5,502 total)
If a person insist in something it's always hard to change their mind.
What might be a slightly different strategy though:
Write a c.u.r.s.o.r *cough* in SQL Server and show that person,...
May 18, 2014 at 5:49 am
If you press F4 the properties window will open. There's a parameter "Schema" with ethe value "dbo". Change it to Category.
Then create your table and save it as ParentCategories. Finally,...
May 18, 2014 at 4:24 am
Would you mind sharing the reason and how you resolved it?
It might help others running into the same issue...
May 18, 2014 at 4:14 am
Did you use the table designer in Mnagement Studio?
If so, you'll need to change the schema in the properties window (F4).
Or, even better, use the SQL command CREATE TABLE in...
May 18, 2014 at 3:51 am
What happens if you use a unicode data type to query the data? Might be an issue with implicit conversion. Hard to tell without the actual execution plans and the...
May 17, 2014 at 2:51 pm
Here's something to get you started:
SELECT
CAST(
(SELECT '' AS [Description], RCode, '' as Override
FROM #TAICR ICR
WHERE ICR.TAICID=IC.ID AND RCodes = 'Comment'
ORDER BY [XMLOrder]
FOR...
May 13, 2014 at 11:50 am
Depending on the process it might be more efficient to perform joins, apply filters and/or aggregate data on the "source server" (Server A), e.g. by writing a stored procedure on...
May 13, 2014 at 11:10 am
I second Erland's approach: create a sproc that will perform the tasks that need to be done and use one of the options described in the article he referenced.
We do...
May 10, 2014 at 11:39 am
"dbo" has two interpretations:
a) the object "dbo" is the default schema of a database and
b) the principal "dbo" is the default user when a database is created that will be...
May 10, 2014 at 10:42 am
Can you provide an example (rows in a table and hoe those should look in the XML you're looking for)?
Might help to "knock down" the language barrier.
May 5, 2014 at 12:10 pm
...customer decides they are missing some data or have too much and they throw another code that needs to be excluded\included...
Exclude/include values in a report usually is a scenario where...
May 4, 2014 at 12:06 pm
There's only one absolute No-Go for me due to the technical side effects it can have: never ever prefix a stored procedure sp_ !
The other "strong" standard is not to...
May 4, 2014 at 5:11 am
something like tihs?
select
person.x.value('(./personId)[1]','varchar(max)') as personId,
person.x.value('(./name)[1]','varchar(max)') as name,
note.y.value('(./date)[1]','varchar(max)') as [date],
note.y.value('(./text)[1]','varchar(max)') as [text]
from @xml e
cross apply e.xmldata.nodes('organization/department/person') as person(x)
outer apply person.x.nodes('note') as note(y)
May 3, 2014 at 5:32 pm
...which is refrenced across 63 columns in 40 + tables...
Just wondering: Why is a PK column refernced by more than one column of another table?
There are cases when it is...
May 3, 2014 at 12:20 pm
Yep. 😀
If nothing else, at least I could promote one of RG's products 😛
May 3, 2014 at 11:42 am
Viewing 15 posts - 181 through 195 (of 5,502 total)