T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Pivoting Multiple Columns

  I need to pivot multiple columns. I am better off doing 2 different Pivots and joining them, or usi…

  Khades

  8 replies

  15 years, 1 months ago

  By: Jeff Moden

• export to excel file

  hi all. i have table that store excel files to varbinary column,now i want export this data from ta…

  elham_azizi_62

  1 replies

  15 years, 1 months ago

  By: danschl

• How to group by where we have char data type

  Hi All, I have five distinct rows in table, something like id col 100 A 100 B 100 C 100 D…

  srikantzs

  1 replies

  15 years, 1 months ago

  By: LutzM

• BCPing out a Table without xp_cmdshell

  declare @cmdstr1 varchar(500) select @cmdstr1='BCP "select * from AdventureWorks.dbo.Employee" quer…

  prasadau2006

  7 replies

  15 years, 1 months ago

  By: Jeff Moden

• Filter a table to get unique rows in a certain logic

  Hi, I'm trying to select specific rows from this table: CREATE TABLE MVTS (idMvt1 int, idMvt2…

  moadh.bs

  75 replies

  15 years, 1 months ago

  By: SwePeso

• Adding a Table - Merge Replication

  I've managed to use sp_repladdcolumn to add columns to replicated tables. By golly, the new table a…

  Half Bubble

  2 replies

  15 years, 1 months ago

  By: Half Bubble

• select max len pattern that matches with column

  Hi, Please help me on the following, create table address(postcode nvarchar(100),Country nvarchar(1…

  Deepthy

  6 replies

  15 years, 1 months ago

  By: Deepthy

• loop in function

  Is it possible to write a loop in a function? I'm getting the following error: "Cannot access tempo…

  L09041975

  3 replies

  15 years, 1 months ago

  By: Jeff Moden

• Very Complicate Query....

  Hi, this is my table with records CREATE TABLE [dbo].[Person]( [RtnSetId] [int] NOT NULL, [FirstN…

  rajesh-303966

  10 replies

  15 years, 1 months ago

  By: WayneS

• delete help using output.deleted option

  I AM TRYING TO DELETE CONTACT ID FROM CONTACT AND SALESHEADER TABLES USING OUTPUT.DELETED OPTION( C…

  Smash125

  2 replies

  15 years, 1 months ago

  By: Smash125

• Where is place to store description of Columns?

  I was created a table with some columns inside it. For example, I have a table with name "TableX". …

  eko indriyawan

  3 replies

  15 years, 1 months ago

  By: Vedran Kesegic

• Just closed the wrong page!

  I just closed without saving the wrong page (I was doing a comparison) Is there a place to go to re…

  shannonjk

  5 replies

  15 years, 1 months ago

  By: mister.magoo

• output on a merge statement

  Greetings everyone 😀 I have a Merge statement I am using as part of an ETL process. It works as int…

  shannonjk

  1 replies

  15 years, 1 months ago

  By: GSquared

• finding occurences of select *

  I'm thinking about how to identify occurences of select * in sql code (sp's, views and functions.) …

  David McKinney

  14 replies

  15 years, 1 months ago

  By: David McKinney

• RIGHT OUTER JOIN not returning correct data

  I am using the RIGHT OUTER JOIN to try and bring back a list of ALL Grades from a lookup table and …

  Squatt Gmail

  10 replies

  15 years, 1 months ago

  By: Lowell