T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Strange result using SUM with ISNULL(NULLIF...

  Hi, I'm very grateful for any light that can be shed on this. My code was per the following: SUM( I…

  david.jack

  13 replies

  8 years, 10 months ago

  By: sgmunson

• using foundation funds to settle lawsuits involving

  Western Michigan vs Kent State Live Streaming

  lathammilne

  1 replies

  8 years, 10 months ago

  By: Alan Burstein

• error 7421 Cannot fetch the rowset from OLE DB provider "SQLNCLI10" for linked server "IDb". .

  hi, I am running a stored procedure , in which I am getting rows from linked server.Its runs …

  komal145

  1 replies

  8 years, 10 months ago

  By: GED.Burnett 71559

• Help needed in recursive split

  I am using the function dbo.DelimitedSplit8K to split. i neeed to split the result of another split…

  KGJ-Dev

  12 replies

  8 years, 10 months ago

  By: KGJ-Dev

• Query to find indexes that are larger than 900 bytes

  In one of our databases, I just observed an index which is over 900 bytes. Index is on 3 key fields…

  Santhoshkumar KB

  4 replies

  8 years, 10 months ago

  By: Luis Cazares

• Counting field values per day between specific date ranges

  Hi All, thanks in advance for any help. I have a table where I store holiday bookings, one row per …

  sc-w

  17 replies

  8 years, 10 months ago

  By: sc-w

• Query to find all procedures that uses functions in the where clause(left operand)

  Hi, I was just trying to find out all the modules (procedures, functions, triggers) that uses funct…

  Santhoshkumar KB

  13 replies

  8 years, 10 months ago

  By: Sergiy

• Remove decimal from varchar field

  How can I use SQL to remove a decimal from a field value. Current value = 1.66770 Correct value = …

  maria.lindquist

  12 replies

  8 years, 10 months ago

  By: Sergiy

• Sql query help

  Hi, below is the sample table with data and expected output Create table Sample1(ID int,value1 int)…

  KGJ-Dev

  4 replies

  8 years, 10 months ago

  By: Luis Cazares

• SQL Server equivalent for MySQL's Substring_index

  Thanks for looking in to my question. Does anyone know if there is an equivalent function available…

  Siva Ramasamy

  7 replies

  8 years, 10 months ago

  By: Alan Burstein

• Next Identity needed

  How do you get SQL Server to assign the next identity to a query? I am getting a NULL not allowed f…

  dwilliscp

  8 replies

  8 years, 10 months ago

  By: dwilliscp

• Check for duplicate and send email of duplicates to End User

  Hi, I have the below table CREATE TABLE [dbo].[BookOrderTest]( [TitleID] [int] NULL, [Title] [nv…

  SQL_Kills

  3 replies

  8 years, 10 months ago

  By: Jeff Moden

• Stuck on simple XML

  declare @xml xml = '<root> <name>hand <val>strong</val> </nam…

  btio_3000

  5 replies

  8 years, 10 months ago

  By: DesNorton

• convert and format

  hi i have table from where data is coming like this price 12.345 345.6789 23.56 now i am taking th…

  coool_sweet

  2 replies

  8 years, 10 months ago

  By: david.jack

• Query Rewrite

  Does developer champs have a better idea of rewriting this simple query. It takes 20+ seconds to ex…

  MannySingh

  2 replies

  8 years, 10 months ago

  By: Sergiy