T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need a logic

  i have posted my Table structure below DECLARE @Mtbl AS TABLE (id INT,Rid INT, DATA VARCHAR(10)) D…

  thava

  4 replies

  12 years ago

  By: thava

• passing multiple parameters with table valued parameter to stored procedure

  Hi All, Can we Pass table valued parameters and normal params like integer,varchar etc..to a single…

  nikku

  1 replies

  12 years ago

  By: david.gugg

• SQL/SSIS Help

  Hi Guys, I need help. Here is my Store Procedure, its a sample store procedure.. ALTER PROC [dbo].…

  rocky_498

  7 replies

  12 years ago

  By: MMartin1

• Mysterious performance issue when joining a view

  (edit - updated exe plan and added new indices) Hi all, We have a non-performant view, usual story …

  Jake Shelton

  22 replies

  12 years ago

  By: SQLRNNR

• Check multiple columns with one value

  I keep thinking this can be done in one query:UPDATE H SET Phone1 = NULL FROM Dialer.dbo.Agentless_…

  djj

  5 replies

  12 years ago

  By: djj

• Table Valued Function for Active Directory group membership

  For code reuse, I am trying to get a table valued function to return users of a given AD group name…

  Andrew.Buis

  7 replies

  12 years ago

  By: Lynn Pettis

• Inserting multiple records from a single variable

  I have two tables. Table 1 has column "job", table 2 has column "job" and column "item". In table…

  jhinch

  7 replies

  12 years ago

  By: Eugene Elutin

• Pulling incorrect records using date range in where clause

  Hi All, I've been experiencing difficulty with pulling records using a where clause date range. I'm…

  daniness

  18 replies

  12 years ago

  By: MMartin1

• Convert float to VARCHAR

  When I execute the below query i'm getting 801075 as result. How can I get 801075.003 as result? DE…

  sql server developer

  3 replies

  12 years ago

  By: Sean Lange

• Difference in seconds to round to minute

  Hi, I'm trying to get the difference between the two times in minutes with the seconds rounded up o…

  Marcus Farrugia

  5 replies

  12 years ago

  By: Eirikur Eiriksson

• Urgent: Can someone help me get past this error?

  SSQL 2008 R2 1. Can someone explain why this is a happening? 2. How do I get past this error? If I …

  TC-416047

  6 replies

  12 years ago

  By: ScottPletcher

• 1=1

  Now i Have not come accross the use of Where 1=1 before, strange it seemed to a colleague of mine. …

  Gordon Barclay

  7 replies

  12 years ago

  By: Gordon Barclay

• t-sql left outer join

  In t-sql 2208 r2, I have sql that looks like the following: select a.custname, i.item, i.amount,…

  wendy elizabeth

  4 replies

  12 years ago

  By: Luis Cazares

• Better way to do this

  A report developer came to me with the following method of parsing out a string...the data comes fr…

  MyDoggieJessie

  5 replies

  12 years ago

  By: MyDoggieJessie

• concatenate specific values from a column

  Give this data set; declare @BO table (Col1 varchar(50), Col2 varchar(50)) insert into @BO val…

  Geoff A

  7 replies

  12 years ago

  By: Geoff A