Development

• Topics

  Started by

  Posts

  Last post

• Where Clause IN Statement

  Hi Guys, i am stuck in listing some of the data, My issues is i am providing a list of the branchs …

  patelmohamad

  3 replies

  14 years, 9 months ago

  By: Subbu S

• String Replacement in XML datatype

  DECLARE @t table ( xml_text xml) INSERT INTO @t SELECT '<Report xmlns:xsi="http://www.w3.org/200…

  Bhuvnesh

  6 replies

  14 years, 9 months ago

  By: Bhuvnesh

• Days in a month

  I need to find the no.of days in each and every month. If i give @startdate = '15 - jan - 2010' …

  Subbu S

  7 replies

  14 years, 9 months ago

  By: Kingston Dhasian

• Dynamic query in a function

  Hi All I wish to keep a function in one database and plan to call ir from different database. For t…

  S_Kumar_S

  17 replies

  14 years, 9 months ago

  By: Subbu S

• Procedure

  I'm attempting build a prodedure that performs the below bulk insert. The catch is I'd like to pas…

  nick.rakich

  4 replies

  14 years, 9 months ago

  By: nick.rakich

• Table Normalization

  Hi All, I am new to the Database world. I would be very happy if any body Normalize the below tabl…

  parivedamohan

  9 replies

  14 years, 10 months ago

  By: Philipp Post

• Assigning output of a query to a variable

  Hi, Is there a possibility of assigning the output of a sql query to a variable in a batch file. fo…

  viksds15

  12 replies

  14 years, 10 months ago

  By: quickdraw

• Fulltext thesaurus

  Looking for Hebrew Thesaurus for SQL Server FullText Search

  evgeny.gozman

  1 replies

  14 years, 10 months ago

  By: andrew gothard

• Zip File

  Hi all, Is there any way to create zip file in file system from SQL server (TSQL Code) …

  ningaraju.n

  3 replies

  14 years, 10 months ago

  By: Lowell

• Without while loop

  /*Table describes the question details*/declare @DetailTable table ( Idbigint identity(1,1), …

  ningaraju.n

  3 replies

  14 years, 10 months ago

  By: ningaraju.n

• Cursor works fine - doesn't from job?

  The main goal of this process is to hop through different servers and databases and execute this qu…

  curious_sqldba

  2 replies

  14 years, 10 months ago

  By: curious_sqldba

• Different results running SQL as sp vs. adhoc

  Hi all, I've got a situation I've never encountered before. Any help is appreciated: The source is …

  dfalso

  3 replies

  14 years, 10 months ago

  By: Adi Cohn-120898

• Computed Columns

  Hi Guys, Is there a way to reference columns of other table in computed columns except tr…

  ningaraju.n

  8 replies

  14 years, 10 months ago

  By: Johan Bijnens

• Need to Duplicate Data

  Hi all i have a strange requirement of duplicating data in a table. I have 26 rows to be copied fro…

  vani_r14

  3 replies

  14 years, 10 months ago

  By: vani_r14

• Union Question

  Hi all I am working on a report which pulls out costs for different items. I have the following fo…

  vani_r14

  5 replies

  14 years, 10 months ago

  By: GSquared