T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Pass multi values into procedures

  Hi I have a procedure which contains the code below. I have created a report in reporting services …

  felix-659856

  20 replies

  15 years, 5 months ago

  By: felix-659856

• Does sql server have something that is similar to open query but more functional?

  We support a bunch of different servers w/ seval sql server instances and version. We have a monito…

  BaldingLoopMan

  7 replies

  15 years, 5 months ago

  By: eko indriyawan

• Bulk Insert more than one CSV file

  Hi All I have got a stored procedure that will bulk insert many CSV files into a table, this is the…

  SG87

  6 replies

  15 years, 5 months ago

  By: Jeff Moden

• removing duplicate values and keeping original

  Hi, I have around 5200 rows in 1 table which has same row displayed twice or thrice... I want to …

  hemalchalishazar

  5 replies

  15 years, 5 months ago

  By: ColdCoffee

• Import Excel data to SQL

  Hi, Is there a way using the following syntax, to query the data from the Excel file starting from …

  infodemers

  6 replies

  15 years, 5 months ago

  By: Dan.Humphries

• Return groups in random order

  The need is to return groups in a random way. FranchiseID's own one or more unique SectorID's There…

  Andy Lucas

  8 replies

  15 years, 5 months ago

  By: Paul White

• OPENROWSET to return an integer with parameters

  OPENROWSET to return an integer with parameters Inside a function, I need to return an Integer. But…

  robert-695083

  5 replies

  15 years, 5 months ago

  By: Jeff Moden

• Nice one, please read and give your comments.

  Hi friends, I came to know this from a book, want to share this with you all. Below is the Table st…

  Hariprasad.M

  7 replies

  15 years, 5 months ago

  By: The Dixie Flatline

• retrieving NULL values using OPENXML

  I am having trouble retrieving NULL values using OPENXML. For some reason the statement returns 0 f…

  sheila.filteau

  2 replies

  15 years, 5 months ago

  By: sheila.filteau

• We have a view which reads from our email database (MS Exchange) through LDAP. For some users it returns user@gmail.com, for other users it returns juan@gmail.local, we want the view to return always, user@gamil.com.

  HI, We have a view which reads from our email database (MS Exchange) through LDAP. For some us…

  vamshikrishnaeee

  1 replies

  15 years, 5 months ago

  By: Ray K

• Compare date fields in SQL or determine which is older !

  Hi all, I do apologize that the question is long... I've a flat file that I cleaned the data out us…

  JasonYousef

  15 replies

  15 years, 5 months ago

  By: JasonYousef

• Trying to Find Incorrectly Named FK's

  Im trying (and failing) to find all FK's in a database that dont match a convention of FK_childtab…

  Simon_L

  3 replies

  15 years, 5 months ago

  By: Paul White

• Pivoting specific fields based on the grouping of another field

  Here's an example of the problem I'm trying to solve. I start with the following data in a table: t…

  sqlenvy

  5 replies

  15 years, 5 months ago

  By: sqlenvy

• Partition Count with slightly different names

  Hey guys, this is a very different tsql question. I have the following ddl create table #test1 ( id…

  npatel565

  2 replies

  15 years, 5 months ago

  By: npatel565

• Dynamic SQL HELP

  Could someone please give me a working sample? I need to set a variable in a SP that will contain t…

  Jeffery Williams

  3 replies

  15 years, 5 months ago

  By: david_wendelken