T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• List of Values to Stored Procedure

  Hi, I wrote a SP to pass a value to SP. It works well ALTER PROC [dbo].[getCompleteItems] (@p_ItemI…

  DKG2014S

  5 replies

  12 years ago

  By: SQLBlimp

• DateDiff() function reported as NonDeterministic

  I am trying to assign the number of days from the beginning of a program to an event in that progra…

  agiambalvo

  8 replies

  12 years ago

  By: agiambalvo

• ProperCase Function

  I'm having an issue converting a scalar function into Table-Valued function and was hoping some of …

  Dohsan

  30 replies

  12 years ago

  By: Sean Lange

• TEMPDB to store temp "User" tables?

  Ok... without going into lots of detail, here is what I have. i. Users log into our web reporting s…

  DB_Newbie2007

  1 replies

  12 years ago

  By: Grant Fritchey

• stored procedure parameter

  I have a stored procedure, I need to set the parameter default value to below, but in it shows the…

  sqlfriend

  3 replies

  12 years ago

  By: Dwain Camps

• Long running query need to be tuned

  Hi I have a long running query that's been running for more 20 hours now. I have stopped the query.…

  deep_trance_

  4 replies

  12 years ago

  By: deep_trance_

• Reading XML

  Hi all, I have a table with column XML type. I am trying to read values from XML datatype but I ot …

  kapil_kk

  4 replies

  12 years ago

  By: Tava

• Need to automatically add a custom server role to any login created

  I have a need to automatically add a server role after any login is created. The idea so far is to …

  random_name

  4 replies

  12 years ago

  By: random_name

• how to pass multivalue based on single value

  Hi, I have below table CREATE TABLE [dbo].[Temptable]( [name] [nvarchar](50) NULL, [namesrt] [in…

  latitiacasta

  4 replies

  12 years ago

  By: Hunchback

• Where clause on XML column

  Hi all, Here is the table script and some data below: Create table XMLwithOpenXML ( ID int identit…

  kapil_kk

  3 replies

  12 years ago

  By: Hunchback

• How to return something when there is no record

  Hello, I have an existing query: SELECT i.Division, DocStatus, SUM(CAS…

  halifaxdal

  12 replies

  12 years ago

  By: ChrisM@Work

• How to check missed schedules of custom scheduler?

  Hello, I have created a custom scheduler that has been running fine, but it depends on SQL Server A…

  Kuzey

  7 replies

  12 years ago

  By: binsel

• How to write query to count and group by different value based on a field

  I am sorry to ask a similar question here again because requirement changed, below is the script to…

  halifaxdal

  10 replies

  12 years ago

  By: Dwain Camps

• Beta distribution

  Hi All, We have a formula called BetaDist() in MS Excel. I want to implement the same formula in …

  saravanakumar.G

  2 replies

  12 years ago

  By: Dwain Camps

• Type conversion in expression - Warning

  Hi All, Getting Type Conversion Error for Select statement. LEFT OUTER JOIN PART_LIST p2 ON e.stat…

  DKG2014S

  2 replies

  12 years, 1 months ago

  By: Igor Micev