T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• String Concatination - concat many xml column as varchar(max) do not concatinate all columns in resultant column

  Hi, I have a large table with 10 xml columns with large xml data. Now i want to join those columns…

  iBar

  4 replies

  14 years, 5 months ago

  By: iBar

• Help needed with dynamic pivot table

  I need to take data in the following format (in SQL 2005): System_NameManufacturerModelTypeOSF…

  jmoldover

  3 replies

  14 years, 5 months ago

  By: Orlando Colamatteo

• Grouping based on the common Time Frame

  Hi Guys, I have sample data like mentioned below. Student IDattendancefrom_dateto_date 1 …

  naveen0905

  5 replies

  14 years, 5 months ago

  By: naveen0905

• Single Invoice Row with Orders

  Hi, I have 3 tables, invoice_head, invoice_lines and Companies. Invoice_lines is basically a order …

  ringovski

  7 replies

  14 years, 5 months ago

  By: Welsh Corgi

• Portable PGP issue

  Hi, I am using portable PGP freeware, able to encrypt the file and drop in the clients sftp locatio…

  Data9

  1 replies

  14 years, 5 months ago

  By: Lowell

• How to alter nvarchar datatype to varchar in sql server

  in employee table...where i want to convert ename which is in nvarchar and later i want to convert …

  Sgar...

  4 replies

  14 years, 5 months ago

  By: prashavhad

• Choosing which Filter will be used within Function that returns a table.

  Hello. I'm trying to do a function that returns a table, but I'd like to be able to send a paramet…

  rmcomics

  5 replies

  14 years, 5 months ago

  By: Sean Lange

• SQL query alternative for performance improval

  I have a query where i am suing inline query which will take the latest data from table " select …

  scottichrosaviakosmos

  4 replies

  14 years, 5 months ago

  By: LutzM

• Parsing XML file

  I have an XML file in the following format and want to import it into the following table. How do I…

  robbase9

  3 replies

  14 years, 5 months ago

  By: LutzM

• ISNULL QUESTION

  I am just reviewing a script at workwanted to know the following line meant. WHERE NOT ISNULL(OP2.C…

  eseosaoregie

  7 replies

  14 years, 5 months ago

  By: LutzM

• General questions about Analysis Services

  To all, My company has decided to integrate Analysis Services as part of our data-reporting and man…

  WDT3

  3 replies

  14 years, 5 months ago

  By: CarpenterBob

• Converting money to varchar still gives me the values in my result set. HELP~~!

  Why is the query below still giving me .0000 in my result? SELECT A.MerchantLocationID, …

  davidsalazar01

  2 replies

  14 years, 5 months ago

  By: davidsalazar01

• Truncation of a float field when copying

  I am attempting to copy data from one table to another. The source table contains float data: Examp…

  scoleman_cambridge

  7 replies

  14 years, 5 months ago

  By: kramaswamy

• Pivot or row to column

  DECLARE @tblStudents table ( StudentID INT, StudentName VARCHAR(100), CollegeName …

  dva2007

  2 replies

  14 years, 5 months ago

  By: kramaswamy

• Mapping Item prices then selecting cheapest

  Hi, I have the following two tables: ****** ITEMS ****** ItemID__Price A_____5 B_____6 C_____7 ****…

  r-276086

  1 replies

  14 years, 5 months ago

  By: kramaswamy