Development

• Topics

  Started by

  Posts

  Last post

• how to group by column name and get max value and its zone?

  how to group by following column and get the required output shown below? name value zone CA12…

  sql4us

  1 replies

  13 years, 10 months ago

  By: Evil Kraig F

• Extracting data into Table using OpenXML

  I have a XML file which I need to extract data from. The result set should give me two rows but I'm…

  maximation

  4 replies

  13 years, 11 months ago

  By: maximation

• dynamic query execution within a cursor

  Hi All, I am trying to execute 2 dynamic sql statements within a cursor. But i came to know only 1 …

  naveen.nagareddy

  4 replies

  13 years, 11 months ago

  By: Sean Lange

• Batch file

  Hi, I have 20 .sql files to be executed. I am executing one by one in query analyser. But I want t…

  pmadhavapeddi22

  7 replies

  13 years, 11 months ago

  By: cesimon25

• using While loop in place of cursors

  I want to use while loop for this.............. DECLARE Total_salary CURSOR FOR SELECT e.Emp_Id,Fir…

  Rakesh.Chaudhary

  9 replies

  13 years, 11 months ago

  By: Jeff Moden

• Table Column Header Visible false

  Hi Guys, I am working on two Server one is production and another is live server, whenever i do ch…

  patelmohamad

  1 replies

  13 years, 11 months ago

  By: patelmohamad

• SELECT * Into #tempTable

  Hi Guys What is the difference between SELECT * INTO #TempTable FROM CustomerMaster WHERE ...... O…

  patelmohamad

  7 replies

  13 years, 11 months ago

  By: spaghettidba

• Change collation on the fly (select statement)

  Hi All, Can we change the collation on the fly? i.e. using select statement?

  arup chakraborty

  2 replies

  13 years, 11 months ago

  By: David Paskiet

• will updating though a view help speed up the database response time?

  hello, in our company mostly 90% of all the queries are on one table so i want to take some of the …

  aswani2002

  4 replies

  13 years, 11 months ago

  By: aswani2002

• replace everything after space found in string

  In `derived column transformation` how do i format string.. i have value of `abc = CCO Holdings, L…

  ashuthinks

  2 replies

  13 years, 11 months ago

  By: Jack Corbett

• insert data in batches

  Hi Guys, I need to insert data in batches from one table to another. The script needs to insert 500…

  Imke Cronje

  2 replies

  13 years, 11 months ago

  By: steveb.

• DataType Table or TempTable Which is Best?

  Hi Guys, I Just wanted to know the difference between the below two tables which one should i prefe…

  patelmohamad

  4 replies

  13 years, 11 months ago

  By: Jeff Moden

• How to format a cell in excel using T-SQL

  Hi, I want to export some query result to excel file. I can use some utilities like sp_makewebtas…

  vaithi.saran846

  2 replies

  13 years, 11 months ago

  By: maddogs

• partitioning a table on the basis of last 2 digits of a column (computed column)

  Hello, I want to partition a table on the basis of last 2 digits of ID column such that there will …

  Sachin Vaidya

  1 replies

  13 years, 11 months ago

  By: Sachin Vaidya

• Need Joins statement

  i want to find a personid in the customer table in experts Database then using that personid find h…

  madhuu1905

  3 replies

  13 years, 11 months ago

  By: madhuu1905