Development

• Topics

  Started by

  Posts

  Last post

• newbie - need help tweaking this script to make data in 1 db column parsed and extracted to 3 columns

  Hi, We have a table tblImport that we have on our production server to insert rows into or flat fil…

  adam spencer

  7 replies

  15 years ago

  By: adam spencer

• To get the Max value from one column with case statement without using any aggregate functions

  Hello there; I need to know is there any way to get the maximum value of one column without using a…

  Marcel Proust

  76 replies

  15 years ago

  By: GSquared

• Query - Array

  Hi In my table values below like that Table1 State 'Indiana','Kentucky','Ohio' City 'Addyston','Al…

  aspdotnet.ghvisali

  5 replies

  15 years ago

  By: Jeff Moden

• SQL Query -- need help

  I have 2 tables. The first table has a SessionID and other columns. There will be multiple SessionI…

  gary.morey

  6 replies

  15 years ago

  By: Johan Bijnens

• Crap Query.... Anyone help tune it in better way

  We have four tables Table1, Table1, Table3, Table4 in differernt databases. There are common fields…

  sql_butterfly

  2 replies

  15 years ago

  By: Jeff Moden

• Genrate .txt file through SQL server 2005 stored procedure

  Hi, I want to genrate .txt file through stored procedure in SQL server 2005. Is anybody have idea h…

  avinash repe

  6 replies

  15 years ago

  By: Jeff Moden

• Must Declare the Table Variable

  HI All am trying to create a cursor, which will fetch the count of a particular record from diffe…

  mj_saran2002

  3 replies

  15 years ago

  By: Jeff Moden

• Parameter Size In Stored Procedures

  Hi All, I have few stored procedures in my server which were developed long back .I found few store…

  snoop123

  1 replies

  15 years ago

  By: GSquared

• Import pacs.008.001.01 xml into db table

  I am going to create a stored procedure, where it captures the xml data and insert them into a db t…

  p.gauci

  1 replies

  15 years ago

  By: GSquared

• How to insert into foreign key table

  Hi, I have a one to many relationship tables, Customer and Order. I want to make sure that Customer…

  felix-659856

  4 replies

  15 years ago

  By: parthi-1705

• How to write optimized query for this case

  Suppose I have table CityInfo as - Package IDCity ---------------------- 2 Pune 2 …

  rshivarkar

  2 replies

  15 years ago

  By: rshivarkar

• How to Get the OUTPUT of a column on DELETE where the column you want is in the FK cascading table

  I have a table tblBatch that has a PK FK relationship (Cascading Delete) on tblSubmissionHistory. W…

  adam spencer

  1 replies

  15 years ago

  By: rVadim

• newbie - how to correctly filter on date select * from dbo.tblSubmissions where createdby = CreatedOn > '2011-02-03'

  How to correctly filter on date? I have to now use this greater than OR the exact date time below. …

  adam spencer

  6 replies

  15 years ago

  By: Michael Valentine Jones

• Improvising Database to better perfomances

  Hi all, Need a help Regarding to improvising database performance and optimizing qu…

  farooq.hbs

  3 replies

  15 years ago

  By: Gail Shaw

• newbie - Needs help with a delete query that joins 3 tables

  I am working on a C# app and I am new to this company's data and processes. I need to delete these …

  adam spencer

  5 replies

  15 years ago

  By: GSquared