T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• ISDATE() And converting

  Hey all, I have a database that is unfortunately not under my control. There is a certain varchar …

  danielfountain

  3 replies

  14 years ago

  By: Jeff Moden

• Speed up Function

  Hey all, I have this piece of code SELECT * , CONVERT(DATETIME, RIGHT('00' + CAST(DAY(ans…

  danielfountain

  3 replies

  14 years ago

  By: okbangas

• Query SQL Log to find errors

  Hi, is it possible to make a query to show the row that matches the where criteria and also the row…

  PHXHoward

  6 replies

  14 years ago

  By: PHXHoward

• Help with a query.

  Hi All, i have this data: DECLARE @tblCron TABLE( id INT ,Nivel INT, A INT, B INT, C INT, D INT ) I…

  xRafo

  14 replies

  14 years ago

  By: xRafo

• How to conditionally add rows to a resuts set

  Hi all, I appreciate that when joining, I'm adding columns to (example) table1, from table2 - and y…

  greg.bull

  5 replies

  14 years ago

  By: Lynn Pettis

• How can we extract each query(Statement) in a procedure??

  Consider the scenario : DECLARE @var1= 'Create proc example1 AS begin Select * from table1 se…

  mailatunni

  2 replies

  14 years ago

  By: sturner

• large self-join taking ages, anything I can do?

  Hi all, I have a query that is trying to identify unique sales records by comparing against all pre…

  CraigIW

  17 replies

  14 years ago

  By: CraigIW

• View definition from a Linked Server

  Is it possible to get a definition of a view from a linked server via OpenQuery command? As the cre…

  marks_262

  3 replies

  14 years ago

  By: GSquared

• error plz solve its urgent

  hi, please solve this error ,its urgent Msg 6260, Level 16, State 1, Procedure pPerformanceHistoryS…

  hbtkp

  18 replies

  14 years ago

  By: Brandie Tarvin

• Variable not getting reset inside the loop

  My colleague told me this weired thing that he observed in T-SQL. I am just wondering why is that s…

  Old McDonald

  25 replies

  14 years ago

  By: patrickmcginnis59

• Remove GUID within a String Field

  Hi All, I have a string field that contains 1 or more GUID data which needs to be removed. Here's a…

  mchu 54023

  11 replies

  14 years ago

  By: Jeff Moden

• Unexpected Round behavior

  Hello All, I'm experiencing some unexpected behavior using rounds and sums on a floating point colu…

  FarNorthDBA

  10 replies

  14 years ago

  By: FarNorthDBA

• Select Query, but being picky about the Rows Returned

  Happy Friday Everyone I hope that everyone is having a good day so far. I am working on a query tha…

  AndrewSQLDBA

  6 replies

  14 years ago

  By: Cadavre

• sargability, optimized execution plans, their caching, dynamic sql, and or highly modularized stored procedures.

  I decided to add this as it’s own discussion. If I have a proc who takes optional params. Say 10 a…

  Snargables

  11 replies

  14 years ago

  By: TheSQLGuru

• Is this a bug?

  create table tTst ( id int not null, tst varchar(20) ) insert into tTst values(1, 'bob') insert int…

  terry999

  18 replies

  14 years ago

  By: jcb