T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Conditional sp_MSforeachtable not working

  I am trying to use the following script to move all tables from the s016PASP schema to dbo schema. …

  dndaughtery

  1 replies

  13 years, 2 months ago

  By: dndaughtery

• multi table match query

  I have 5 tables 1) cropid( this is the id for each time my procedure runs) create table cropr…

  scottichrosaviakosmos

  4 replies

  13 years, 2 months ago

  By: Sean Lange

• first official day of every month for past 3 years

  i have a table and a column with dates. there are multiple dates for same date . these dates are in…

  scottichrosaviakosmos

  2 replies

  13 years, 2 months ago

  By: Eugene Elutin

• Select column name and values.

  I need query for Select column name from information schema and display values for selected column …

  Venu_S

  6 replies

  13 years, 2 months ago

  By: Venu_S

• How to join four tables using left outer join

  Hi All, I want to show data from four tables on the basis of left outer join.All tables contain com…

  neellotus07

  7 replies

  13 years, 2 months ago

  By: drew.allen

• the job succeeded .. failed to notify 'vinay' via email..'

  I was looking in google to reslove this but i didnt find the solution.. I am attaching sysmail_m…

  vinay.varaala

  4 replies

  13 years, 2 months ago

  By: vinay.varaala

• Extract string before character occurrence.

  Hi, This is bugging me, the solution must really be easy. I have a column in a table with a variabl…

  Chris

  12 replies

  13 years, 2 months ago

  By: Sean Lange

• Is there a function for this?! Splitting field up using a delimter

  Hi, I have a column like this: "Thing, Thing2, thing14, more things" I would like to split it up us…

  learning_sql

  3 replies

  13 years, 2 months ago

  By: Jeff Moden

• How to Build a single row with groups of fields from several rows per key

  i have several rows like: Customer sn val1, val2, Val3 ..... (sn is a seq# from 1 to 15) A …

  Avraham de-Haan

  6 replies

  13 years, 2 months ago

  By: Avraham de-Haan

• Funky happenings with Data Export Wizard

  I am trying to use the DEW to export the return set from a stored procedure to an Excel file. This …

  MrBaseball34

  13 replies

  13 years, 2 months ago

  By: nickblethyn

• what is the difference between ODBC and OleDB?

  Hi Friends what is the difference between ODBC and OleDB?

  steven-733381

  5 replies

  13 years, 2 months ago

  By: Eugene Elutin

• STUFF & ISNULL

  Hi, I'm new in SQL Server, i want the working process of STUFF & ISNULL. How it works & h…

  mubarak.a

  3 replies

  13 years, 2 months ago

  By: robert.gerald.taylor

• Merging rows

  Hi All, Is it possible to combine two rows into a single row? example: Asset ID Asset Name …

  prady_1988

  13 replies

  13 years, 2 months ago

  By: prady_1988

• Customize SQL error message for VB.NET App use

  I am wondering if there is a way to overwrite or customize the system error thrown by SQL server. F…

  crux1187

  3 replies

  13 years, 2 months ago

  By: Rajat Jaiswal-337252

• How to partition data of huge table

  I have a table(T1) of around 20 million record and about to grow in future by 100 to 200%. It conta…

  av.abhishek

  1 replies

  13 years, 2 months ago

  By: Rajat Jaiswal-337252