T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• nested left and right query?

  Is it possible to nest (or perhaps stack via CTE) left and right? For example, if i had a list of …

  sqldriver

  9 replies

  12 years, 2 months ago

  By: sqldriver

• Using the CONTEXT_INFO Function for multiple objects in the same database

  I have a situation where CONTEXT_INFO is currently being used in one area of our PROD instance on a…

  SQL_ME_RICH

  1 replies

  12 years, 2 months ago

  By: Orlando Colamatteo

• Help please

  This is probably a simple join issue but here goes... We have a system (HAL) that does not contain …

  Vertigo44

  4 replies

  12 years, 2 months ago

  By: Jan Van der Eecken

• Format values as Percent

  Hi ALL, SQL: Select MyColumn FROM ( SELECT CAST(CAST(0.10*100 AS numeric(10,2)) AS varchar(5)) + '…

  SMAZ-429882

  15 replies

  12 years, 2 months ago

  By: Calibear

• Excel VBA call to execute stored procedure.

  How do you surround a stored procedures parameters so that any with a single quote don’t cause a cr…

  Kelvin Phayre

  2 replies

  12 years, 2 months ago

  By: Kelvin Phayre

• INFORMATION_SCHEMA.COLUMNS reference

  How do you reference INFORMATION_SCHEMA.COLUMNS from a linked server? When I try doing that, I get …

  levsha_z

  6 replies

  12 years, 2 months ago

  By: MMartin1

• Fatal error 824

  Im using sql2005 and in a simple query in the mngt studio return the error: Msg 21, Level 24, Stat…

  sergio hi

  11 replies

  12 years, 2 months ago

  By: Gail Shaw

• SQL IS testing

  Hi, Does anyone have a list of all the IS (date/numeric) type syntax available? I've been trying to…

  sqldriver

  11 replies

  12 years, 2 months ago

  By: sqldriver

• Assign Validation Codes

  Here's the scenario. Table CustomersA: RowIDCustomerNameCustomerIDCreationDateCreatedByValidat…

  parikiti

  12 replies

  12 years, 2 months ago

  By: parikiti

• userdefined function for average

  Hi guys, I tried to create a new userdefined function for calculating the average of top 10 values …

  afuchs 47083

  3 replies

  12 years, 2 months ago

  By: ChrisM@Work

• I am getting learn to post,am i correct now??????? What will be your reply for this???????

  --===== If the test table already exists, drop it IF OBJECT_ID('TempDB..#mytable','U') IS NOT …

  andrewalex.r

  4 replies

  12 years, 2 months ago

  By: Ron McCullough

• I need the code part for splitting the row into different columns?

  1 : 7 ; 9 : 21:Task Completed:2013-04-08, 1 : 8 ; 10 : 22:Good:2013-04-08, 1 : 9 ; 8 : 19:N…

  andrewalex.r

  4 replies

  12 years, 2 months ago

  By: ronang

• Need help

  Hello, I need syntax to get the all the values of one employee from the employee table, in …

  andrewalex.r

  4 replies

  12 years, 2 months ago

  By: Sean Lange

• Compare two data sets-- Please help

  Hi, I have a scenario while comparing the data between two data sets. CREATE TABLE DATA (ID BIGINT,…

  Ram:)

  4 replies

  12 years, 2 months ago

  By: Ram:)

• What is an index.is is object ??how visualize...

  Hi we can visualize a table as m*n matrix where m and n indicates number of rows and columns . But …

  anoop.mig29

  2 replies

  12 years, 2 months ago

  By: Gail Shaw