Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)

Topic Author Replies Read Last Post Help with weird Select statement  transcom_bcn 5 811 2007-04-11 by khtan Connecting to SQL 2005  enak 3 554 2007-04-11 by khtan datetime issue  gems 5 544 2007-04-11 by khtan Select distinct, order by not-distinct  trouble2 16 4323 2007-04-11 by harsh_athalye Alias  RichardChristie 2 508 2007-04-11 by SwePeso Count Distince Issue with Postcodes  mickyjtwin 8 817 2007-04-10 by khtan how do I join these tables?  Zim327 1 749 2007-04-10 by Vinnie881 order by numeric data in varchar column  tkizer 18 35265 2007-04-10 by Vinnie881 Is there a better way to write this query  bogey 2 613 2007-04-10 by SwePeso Finding a table name which have a specific field?  zeeshan13 5 862 2007-04-10 by SwePeso convert text field to numeric?  mapperkids 2 652 2007-04-10 by tkizer Use of EXECUTE() inside UDF  KurtW 3 537 2007-04-10 by SwePeso Dynamic Attributes using XQuery?  pnkfloydloon 4 919 2007-04-09 by pnkfloydloon Merging 2 (nearly) identical rows into 1??  Goalie35 11 699 2007-04-09 by harsh_athalye OK how to optimize restrictions in the WHERE claus  ramoneguru 3 578 2007-04-06 by Vinnie881 dynamically changing USE database  nic 6 3430 2007-04-06 by X002548 Post row data even if record not found  ddobbertin 5 620 2007-04-06 by jsmith8858 2 select in if exists  cjhardie 6 929 2007-04-06 by dinakar What does the N do in this stmt: select...N'Test%'  bogey 6 658 2007-04-06 by tkizer Newbie needing help  frankivey 4 598 2007-04-06 by X002548   Previous Page Next Page