T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How to divide number

  Hi I need to divide amount in joint account. So if joint account has 2 account holders & amou…

  vandana_j79

  4 replies

  12 years ago

  By: Dwain Camps

• Database Triggers to prevent large DDL transactions

  Hi All, I need help please. A server I'm working on has a very unique situation, where user tables …

  Jacques Rossouw

  6 replies

  12 years ago

  By: ScottPletcher

• Is cascade delete Slow

  Hi, Is cascade delete is slow in sql server ? Having fk reference of 15 tables. If the record is de…

  yuvipoy

  7 replies

  12 years ago

  By: ScottPletcher

• Odd behaviour from sys.dependencies

  (SQL Server 2008 R2 SP1) Hi all, I have an SSIS package that dynamically builds a set of SQL statem…

  JJB@TGT

  14 replies

  12 years ago

  By: bitumenpit

• To dynamically change values in this short script based on 3 values

  I have a script that I use after some amount of data massaging (not shown). I would like to be abl…

  pharmkittie

  6 replies

  12 years ago

  By: pharmkittie

• Circular variable reference

  Hi all, I'm going around in circles trying to visualise what's happening in this code, declare @Re…

  Jake Shelton

  1 replies

  12 years ago

  By: Sean Lange

• how to repeat columns based on rows

  Hi, I have two columns which needs to repeat based on ID and number of distinct rows in that ID. I…

  raghu.sudheer

  3 replies

  12 years ago

  By: Sean Lange

• IF EXISTS DROP INDEX ... IF NOT EXISTS CREATE INDEX

  How can I make the following a little more error proof where I check the Table and Schema Name? IF …

  Welsh Corgi

  19 replies

  12 years ago

  By: DQ Ninh

• Calculate and return the previous Date at 18:00 Hours

  How can I calculate and return the previous Date at 18:00 Hours? Here is a miserable attempt: DECL…

  Welsh Corgi

  9 replies

  12 years ago

  By: Welsh Corgi

• Pipe Row to Column

  Sample Data MemberID Codes 00000123 012|222|123|333 00000233 012|222|332 00000244 012|211 00000332 …

  domnick.eger

  6 replies

  12 years ago

  By: mister.magoo

• Combining keys to create a master list

  I am struggling trying to clean some data and identify duplicate records. I used fuzzy grouping in…

  peter 44613

  2 replies

  12 years ago

  By: Dwain Camps

• sp_create_trace script

  I've put together a trace script and I'm getting a confusing error. After the sp_trace_setevent's,…

  SQLHeap

  4 replies

  12 years ago

  By: SQLHeap

• Syntax advise please

  Hello, I'm trying to write a query and I'm receiving an error and I'm not sure how to get around it…

  igloo21

  23 replies

  12 years ago

  By: CKX

• how to pass an array of values as a parameter of function????

  Hello all, I am trying to find out a way to pass an array of pbaseid's to a function. I have a func…

  abi

  1 replies

  12 years ago

  By: Jack Corbett

• Parse, Convert, Convert back and Insert

  I am trying to construct a query to parse out the Date in a string, then convert that result to a D…

  jameslauf

  3 replies

  12 years ago

  By: mickyT