janine.rawnsley (8/13/2009)

---

I'm just curious (and a tad concerned) but is this for a live app or a uni project or something?

Because honestly, I have no idea why you'd take the...

You are mixing both XML (xquery) and FULLTEXT?

DECLARE@ INT = 1

SELECT@ AS [INT],

@@VERSION AS [@@VERSION]

INT @@VERSION

----------- ------------------------------------------------------------------------

1 Microsoft SQL...

Thank you!

You did the hard work. I did nothing but finding some "edge" conditions for you to fix.

Congratulations Barry!

It's a good thing they accepted your late submission 🙂

Or use the new OUTPUT operator?

;with CTE1(col1,col2)

as

(

Select Col1,col2 From table 1

)

INSERT INTO table2

output inserted.*

into table3

Select * from CTE1

Try this.

SELECT object_name(object_id), * FROM sys.dm_db_index_usage_stats

where object_name(object_id) is not null

A bunch or replies here too

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=130520

Even if the parameters are never NULL, they form a query which filters by the parameters.

The result of the query may not match any record...

There seems to be a performance threshold about 13 levels deep.

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129754

Also see this blog post for alternate ways to display your data.

We can't help you any further because we don't have enought information.

Please prefix all your column names with table name or alias.

select distincta.EMPID,

sdate

into#temp1

fromdbo.vwJobcd as a

inner join#tabdates as b on a.EMPID...

See http://www.sqlmag.com/Article/ArticleID/98568/sql_server_98568.html

Adventures with Big Data: How to Import 16 Billion Rows into a Single Table

Tips on how to use T-SQL's BULK INSERT statement and the BCP utility

DBCC CHECKIDENT() with RESEED option.

Or create the procedures and functions using

WITH ENCRYPTION

will make it harder for people to read your code.

Of course not!

I just googled the keywords and the link popped up.