T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help on Trigger

  Hi Guys, Need your help. I have A table called [Period] and i have insert,update,deleted trigger on…

  vijay.singh 14112

  5 replies

  14 years, 5 months ago

  By: vijay.singh 14112

• dynamic sql execution plan caching question

  drop table itemtest create table itemtest (itemid int) go create proc testDynamicSQLCaching @itemi…

  Snargables

  4 replies

  14 years, 5 months ago

  By: Gail Shaw

• SQL to compare Access table with SQL table

  Hello All, I am moving a few tables from MS Access 2007 to MS SQL Server 2008. Even though the tabl…

  SQLCurious

  2 replies

  14 years, 5 months ago

  By: SQLCurious

• Query performance

  Hi, I have a query thats runs very very slow . select distinct R.A, R.B, R.C, (SELECT TOP 1 TrWee…

  PSB

  6 replies

  14 years, 5 months ago

  By: Sean Lange

• Opening and Closing Balance

  I have got a table as below StatementNoLedgerID OpeningBal ClosingBal …

  rka

  4 replies

  14 years, 5 months ago

  By: drew.allen

• can someone point me to a list of non-SARGable expresions?

  can someone point me to a list of non-SARGable expresions?

  Snargables

  10 replies

  14 years, 5 months ago

  By: GSquared

• tsql help

  Hi all, I have records under columns as: select top 4 MyColumnName from MyTable MyColumnName LN1, …

  etirem

  9 replies

  14 years, 5 months ago

  By: Lynn Pettis

• help with sql query for group by

  How to get avg balance amount grouped by CustomerNo. Also I need to name the avg balance as "Final …

  a9848627

  5 replies

  14 years, 5 months ago

  By: a9848627

• Help with Math in SELECT stmt

  I am sure what I am doing wrong is very simple, I just cant seem to figure this out. Why does this…

  GBeezy

  3 replies

  14 years, 5 months ago

  By: Jason Selburg

• help in query

  Hi, My requirement is as given below: My table contains three columns: start_date,id, prev_date ---…

  pandeesh

  1 replies

  14 years, 5 months ago

  By: GSquared

• The multi-part identifier "" could not be bound.

  Hi All, i am trying to execute this statement: begin tran update Attributes set EntityId = dbo.Enti…

  martin.kerr 34088

  2 replies

  14 years, 5 months ago

  By: MuraliKrishnan1980

• Over (Partition By)

  Hi Guys AdventureWorks 2008 DB When using the following Code select distinct SalesOrderID ,SalesOrd…

  SQLSACT

  8 replies

  14 years, 5 months ago

  By: SQLSACT

• Multiplication operator in a trigger

  G'day guys, I have a service that writes to a database, one of the tables the service writes to hol…

  ZombieRick

  1 replies

  14 years, 5 months ago

  By: ZombieRick

• Split Comma Separated String to Multiple Columns

  Hello Guys I am working with SQL Server 2008 and I have to make a T-SQL query to break a comma sepa…

  Sy-1148362

  3 replies

  14 years, 5 months ago

  By: Jeff Moden

• How to divide on row by another

  Hi, im looking for help with a query that im writing. Im not that great with math and I need to pop…

  strawb2

  16 replies

  14 years, 5 months ago

  By: Jared