T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• update column

  hi i have following tmp table that i am loading through SSIS package. create table tmp_management (…

  coool_sweet

  1 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• generate dynamic update statement

  I'm trying to generate an update statement based off select statement results. A very basic exampl…

  Erin.

  6 replies

  11 years, 7 months ago

  By: Alvin Ramard

• compare multiple column between two tables

  Hi, I am having two tables as below: I want to display records from @table1 only when combination o…

  abhas

  2 replies

  11 years, 7 months ago

  By: lnoland

• query with several joins fills up tempdb and won't finish

  Hi, so I have this query I need for a report. Originally it was 4 queries to be used in Crystal Rep…

  NoDBA

  13 replies

  11 years, 7 months ago

  By: NoDBA

• trigger with text type

  Dealing with 3rd party app that is somehow deleting records. Was going to put a delete trigger on …

  tcronin 95651

  7 replies

  11 years, 7 months ago

  By: tcronin 95651

• Replace multiple characters with single character in a column

  Experts, I am trying to replace all special characters in a column with one special character. Exa…

  Learning1

  9 replies

  11 years, 7 months ago

  By: Brandguru

• TDE Encryption and t-sql

  Does anyone have a t-sql query that will encrypt several databases without using the use DB_name? I…

  lkennedy76

  6 replies

  11 years, 7 months ago

  By: lkennedy76

• Query help please

  Hey all, It's been a while due to a job change I don't get to do as much SQL anymore...although thi…

  Kazmerelda

  9 replies

  11 years, 7 months ago

  By: Kazmerelda

• What has got SSMS Object Explorer blocked?

  How do I find what is keeing SSMS Object explorer from giving a list of tables or stored proc's? Ev…

  dwilliscp

  3 replies

  11 years, 7 months ago

  By: x

• SQL Job Truncation Error

  Updating my local [Event] table with the data from a source SQL box [Event] table. Just need to in…

  Deuce

  4 replies

  11 years, 7 months ago

  By: Mike Good

• Collation errors, damned if I do and damned if I don't!

  Hi Everyone, I am receiving a number of 'collation' related errors with the following query - WITH…

  david.dartnell

  6 replies

  11 years, 7 months ago

  By: Gazareth

• Need help to design table which is can store Education Requirement for the Job Vacancy

  Hi, This is my table named - CV *CVID is a primary key This is my table named - CVEducation *CV t…

  Qira

  5 replies

  11 years, 7 months ago

  By: Qira

• problem with selecting top 5

  Hi, I am having temp table where i am inserting records from to queries. eg. insert into #temp 1 …

  abhas

  3 replies

  11 years, 7 months ago

  By: rxm119528

• Sql Join Clause with BETWEEN Statement

  Hi Everyone I would appreciate your help on this. I need to write a SQL script where a join conditi…

  azdeji

  2 replies

  11 years, 7 months ago

  By: Jack Corbett

• The FOR XML clause is invalid in views, inline functions, derived tables, and subqueries when they contain a set operator.

  I have the following XML statement, where I want the union of several tables to be presented as XML…

  petervdkerk

  6 replies

  11 years, 7 months ago

  By: michael.evenson-916214