T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Datetime in sql

  I have one column in table table1 that has period month of integer format. In this table I have dat…

  cpinky01

  5 replies

  15 years ago

  By: Ray K

• Group By Issue

  Hi All, I had some problem with getting output. My criteria is I want to select records which are h…

  DBTeam

  1 replies

  15 years ago

  By: ColdCoffee

• SETUSER Replacement for SQL 2008

  I am trying to replace the SETUSER with the EXECUTE AS as noted in the deprecated features list for…

  Greg

  1 replies

  15 years ago

  By: Greg

• xp_cmdshell move error

  Hello, I want to execute the following bit in a stored procedure (which is called through a cursor…

  Deepthy

  2 replies

  15 years ago

  By: Adiga

• Creating large semi-random data sets without cursors

  I have the following structure: Protocol--(1,M)--enrollment---(1,M)---[Cycle---(1,M)---Symptom]---(…

  pietlinden

  2 replies

  15 years ago

  By: Jeff Moden

• why is one query better performing than the other

  let me describe the scenario. There is an order, orderline and OrderLineStatus tables. There is one…

  winston Smith

  6 replies

  15 years ago

  By: The Dixie Flatline

• counting the number of stored procedures

  How to count the number of stored procedures inside a database using sql query? please help

  crprajan

  4 replies

  15 years ago

  By: ajay.sql2005

• Delete

  I have TWO TABLES ABC and XYZ ..and we are doing some logic to Insert millions of records into XYZ…

  nari.koud

  4 replies

  15 years ago

  By: nari.koud

• String or Binary data would be truncated

  I am using SQL Server 2008 Enterprise edition SP2 trial version. I have a table that have 5 columns…

  subhashpunia

  12 replies

  15 years ago

  By: David Webb-CDS

• CSV file import

  Is there a way that a CSV file can be imported into a SQL Server table using BCP if the file has th…

  jwaz1999

  2 replies

  15 years ago

  By: WayneS

• Condition addition of a trigger to a database?

  I have been googling this one for much of the afternoon with no success... Is it possible to add a …

  Lyekka

  10 replies

  15 years ago

  By: Lyekka

• adding Column

  Hi, I have one column in my table with name PeriodDescription which is of varchar type. The data in…

  cpinky01

  5 replies

  15 years ago

  By: steveb.

• ORDER BY datetime help

  I have a strange issue here. If I run the following SQL query in SQL management studio, it works f…

  Magy

  3 replies

  15 years ago

  By: Magy

• select distinct best row based on a condition

  Hi all . The application I'm working on only allowed that one user had one usergroup. I create a Us…

  jpdlp

  5 replies

  15 years ago

  By: ColdCoffee

• Integration of XQuery and T-SQL

  Hello, I'm struggling with the integration of XQuery and T-SQL syntax. I found a piece of code whi…

  tonyclifton77

  7 replies

  15 years ago

  By: LutzM