Since you "investigated" what a tally table is, the following code should be self explaining. It will return 18 lines as requested.

-- build sample table and insert data

DECLARE @A TABLE...

Hi Priya,

would you please show us what you've tried so far so we can help you to make your code performing better.

I think it's a better idea than just throw...

GilaMonster (6/6/2009)

---

From what I understand, the current rule is that documented features have to go through a 1 or 2 stage deprecation cycle (sysobjects, deprecated in 2k5, final deprecation in...

Did you look into BooksOnline (aka BOL), the SQL Server Help that usually is installed together with SQL Server? You can open it by using {F1} from the Management Studio.

There...

Hi,

referring my previous post I would have done it as follows (example from AdventureWorks, thought it would clarify a little more what I was thinking about than just throwing those...

Hi Wayne,

your link doesn't work (double referenced).

Edit: problems during post submission.

Edit: problems during post submission.

Another option would be to add the column names using the UNION ALL function within the SELECT statement of the BCP command.

Something like

SELECT 'Col1','Col2','Col3' UNION ALL

SELECT CAST(Col1 AS VARCHAR(10)),...

You might want to look up DATEPART function in BOL.

Then you can use it to do a SUM() GROUP BY DATEPART().

If you need a more detailed answer you should provide...

If I understand you correctly you're asking what's faster:

You have an asp.net application and you're asking for the faster of the following two options (using .net coding):

1) find a specific...

LOL :hehe:

Haven't seen that one for a long long time!

Do...

SELECT

ArticleID,

STUFF((SELECT ' ' + Title + ' ' +Text FROM TABLE t2 WHERE t2.ArticleID = t1.ArticleID FOR XML PATH('')),1,1,'')

FROM

TABLE t1

GROUP BY

ArticleID

Just change your FROM clause to

FROM (SELECT TOP 10 * FROM @Temp ORDER BY Row_Id) as sub Cross APPLY TempXml.nodes('DATA/FIELD')...

Hi FlamedLove05,

please provide a little more information so we can see what you see...

1) The row you provided is incomplete. Please provide completed SQL statement.

2) We don't know the structure...