Goldie Lesser

Forum Replies Created

Viewing 15 posts - 196 through 210 (of 304 total)

RE: Updating Value of a particular XML node in a col where data type is xml

siddartha pal (10/30/2008)
I am trying to paste the xml content here but the site is now allowing me to do so.
Save the XML as a txt file and upload it...

October 30, 2008 at 7:14 am

#891743
RE: List all the departments that don’t have any employees

Madhivanan (10/30/2008)
rbarryyoung (10/29/2008)
naidussdba (10/29/2008)
I have to Display List all the departments that don’t have any employees(Without using sub query).
So why this unusual restriction?
Becuase it is an interview question 😉
Or a...

October 30, 2008 at 7:14 am

#891741
RE: List all the departments that don’t have any employees

Please post your DDL and some sample data in the format outlined in the following article:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
That will help us to solve your problem for you 🙂

October 29, 2008 at 9:04 pm

#891583
RE: How to retrieve data from ntext (xml) data

JohnDBA (10/29/2008)
Ggraber,
Here is the file of one value and one field.
Thank you!
Looks like Mark beat me to it. 🙂
If multiple dependencies or default values existed did you want one row...

October 29, 2008 at 8:11 am

#891240
RE: How to retrieve data from ntext (xml) data

Can you attach your XML as a txt document so we can play with it?

October 29, 2008 at 7:19 am

#891199
RE: Selecting records on condition that others exist.

Davroche (10/29/2008)
We need the DDL for the table(s), create statements. The tables are already there I did not create them. I am simply querying the data. I...

October 29, 2008 at 7:18 am

#891196
RE: Pivot, Crosstab report

I see you haven't received any answers to your question.
That is because you haven't provided us with enough information to assist you.
Please read the following article.
Forum Etiquette: How to...

October 28, 2008 at 7:37 pm

#890990
RE: Fine tuning database.

nairsanthu1977 (10/27/2008)
Also there are many tables, procedures, indexes etc which are not used at all.
Is there any way to find out unused/rarely used objects in the database..??
I would advise...

October 28, 2008 at 7:23 pm

#890988
RE: How to retrieve data from ntext (xml) data

Are you using this in an application?
If so, I would bring back the whole XML and use XPath Query to return the desired results.

October 28, 2008 at 7:10 pm

#890986
RE: SMALL HELP EGD ORDER BY

Seems to me you should be doing something like this.
I don't have SQL Server at home, so I couldn't test this code.
select datepart(mm,date) + '/' + datepart(yyyy,date) AS MonthYear
,count(*) from...

October 28, 2008 at 5:57 pm

#890980
RE: SELECT DISTINCT returns random duplicate rows

DISTINCT applies to all columns in the SELECT clause.
So it is possible your data really is DISTINCT but you do not realize it.
Please post some sample DDL, DATA, and your...

October 28, 2008 at 5:55 pm

#890979
RE: Test-Driven Development of T-SQL Code

Grant Fritchey (10/28/2008)
While I do agree, we use Visual Studio Team System Database Edition for unit testing now, a few of your negatives probably shouldn't be on the list. #4...

October 28, 2008 at 8:30 am

#890669
RE: Test-Driven Development of T-SQL Code

I spent most of the day researching TSQL Unit for the company I work for.
We are moving towards test-driven development and we are looking for a way to run data...

October 28, 2008 at 8:16 am

#890654
RE: Need list of sprocs using key tables

latingntlman (10/17/2008)
We're converting several tables to new table names and field names. We have reporting that use sprocs which call those current tables/fields.
My challenge and question is how to...

October 28, 2008 at 7:17 am

#890599
RE: Need help on performance and integrity

bhovious (10/27/2008)
Hey Seth,
Could you give me one example of the iterative situation you describe. I didn't see that in all of the examples I looked at. ...

October 27, 2008 at 6:16 pm

#890349

Viewing 15 posts - 196 through 210 (of 304 total)