T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need help with SQL query..

  [tbl_question] : questionId, question [tbl_answer] : answerId, questionId, answer, [tblTaskAnswer]:…

  gmk0351

  2 replies

  13 years, 1 months ago

  By: Mike.Hahn

• Different collation dbs .. except

  DB1 - COLLATION - SQL_Latin1_General_CP1_CS_AS DB2 - - COLLATION - SQL_Latin1_General_CP1_CI_AS SEL…

  bangsql

  1 replies

  13 years, 1 months ago

  By: Lynn Pettis

• combining the results of multiple select statements in to a single row

  All, I have a requirement to combine the results of multiple select statements in to a single row. …

  sandhyarao49

  4 replies

  13 years, 1 months ago

  By: Gabriel P

• Query Advise...

  Hi guys, I am not sure it is possible or not but would like to ask here. I want know is anyone kn…

  tooba111

  3 replies

  13 years, 1 months ago

  By: joeroshan

• Get number of unique values in group of columns

  Hi - I have the following scenario and not sure of the best way to write the T-SQL query without a …

  Triality

  2 replies

  13 years, 1 months ago

  By: Triality

• Multiple select in same query

  I have a sql storeprocedure where i want to count calls to a helpdesk.. The rows in my query for ex…

  tony 9186

  5 replies

  13 years, 1 months ago

  By: Steven Willis

• Unseen characters

  I have a table dbo.address in which i have an address column. When i am trying to do the len functi…

  WonderPra

  9 replies

  13 years, 1 months ago

  By: WonderPra

• TVP in SysObjects

  I want to grant all TVPs for permission to public. I have a script that is like this for Sprocs DE…

  JKSQL

  13 replies

  13 years, 1 months ago

  By: Vedran Kesegic

• removing duplicates rows from a parent table.

  Hi all, i need help in deleting duplicate records from a table a. but the table which i'm going to…

  gopikishan.maheshwarlal

  3 replies

  13 years, 1 months ago

  By: Jeff Moden

• Go to next record when there is a constraint issue.

  I am trying to automate purging data from two information tables. Table2 depends on Table1. Both …

  Erin.

  3 replies

  13 years, 1 months ago

  By: Lynn Pettis

• Enable/Disable Sequence Containers during rungime.

  I have a package that contains multiple Sequence Containers, each execute a bunch of tasks. We ref…

  PFlorenzano-641896

  1 replies

  13 years, 1 months ago

  By: Ray M

• Maximum Concurrent Users in a day

  Hi all I have a table which contains login and logout times for a large set of users, and we are wa…

  Kwisatz78

  12 replies

  13 years, 1 months ago

  By: Steve JP

• TRIGGER does not commit

  Hi, Very weird case I am facing at the moment. I have a trigger that works well until the moment it…

  boeledi

  3 replies

  13 years, 1 months ago

  By: Jeff Moden

• Need to split one table into three tables

  I have a table w/6066 distinct records; each record has total sales column and need to split it int…

  latingntlman

  4 replies

  13 years, 1 months ago

  By: latingntlman

• Weird Behavior of Trigger

  I've got a trigger (SQL 2008 R2) that does a few simple operations but the results are not logical.…

  Mark_1820

  21 replies

  13 years, 1 months ago

  By: Mark_1820