T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• count of column by different values in same row

  i would like to find out how to do a single query to return the count total for both values table1 …

  roy.tollison

  4 replies

  15 years ago

  By: roy.tollison

• MS SQL String combination

  I will like to return a table of rows consist of all possible combination of a string. For example …

  samuelg78

  24 replies

  15 years ago

  By: samuelg78

• Error Evaluating Converted/Cast VARCHAR

  I'm using SQL Server 2008. I have a table called "Notes" with the field "Description" that is VARCH…

  Chewbode

  5 replies

  15 years ago

  By: GSquared

• CTE problem with insert

  This code works just fine: with cte as (select userid, createddate, row_number() over (PART…

  Erin Ramsay

  5 replies

  15 years ago

  By: BeginnerBug

• HOW TO TRACK ALL QUERY IN A DATABASE IN A TABLE FORMAT

  DEAR ALL, HOW CAN I TRACE ALL THE QUERIES WHICH IS RUN IN NEW QUERY WINDOW AND IT AUTOMATICALLY INS…

  Ivan Mohapatra

  1 replies

  15 years ago

  By: Gail Shaw

• Common table exp

  WITH Sales_CTE (terminalid, LastLoadDate, LoadValue) AS ( SELECT tid, MIN(schedloaddate) AS L…

  PSB

  2 replies

  15 years ago

  By: Jeff Moden

• Help needed to decode comma delimited string and insert into tables

  Hi all, Recently, I was working on turning structured audit string into a table sample string 1: ,2…

  JJH82

  40 replies

  15 years ago

  By: JJH82

• date format problem

  I have 3 SQL Server 2000 with a merge replication between them. On 2 servers, everything goes fine.…

  Dominic Gagné

  2 replies

  15 years ago

  By: Dominic Gagné

• Test, fail, wait-a-while, test again

  Hi, I want to test whether somethin is true (in this case that a date column has been updated with …

  Duncan Lawrence

  3 replies

  15 years ago

  By: Khades

• Delete rows from table

  I have a temporary table I created from joins of 3 other tables ordered by PortNumber, INumber and …

  jillk

  5 replies

  15 years ago

  By: GSquared

• SQL Server 2008R2 Peek 100%

  My SQL server peek between 90 to 100 % for several days now. I tryed to restart and also Windows Up…

  gert.lindholm

  7 replies

  15 years ago

  By: gert.lindholm

• Table Scan

  I'm selecting from a table and a view. I'm trying to reduce the timeit takes to return the data. He…

  Rog Saber

  38 replies

  15 years ago

  By: Evil Kraig F

• select multiple wild cards...

  user will click on a tab 'ABC','DEF'... and when they do i need to query for all last names that be…

  roy.tollison

  2 replies

  15 years ago

  By: Vedran Kesegic

• Help in trigger

  Dear All! I need to audit the table1 records when its gets update , Ex: Table1 as table Name …

  Saravanan_tvr

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Replace data value with reference to the row of the same table in same database

  Hi all, I'm looking for the query to replace zero value from the another row in the same table with…

  SPtrt

  5 replies

  15 years ago

  By: Orlando Colamatteo