T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Why the server are running to slow?

  This has being a common observation since last few days. The server through which i am connected is…

  Shadab Shah

  8 replies

  13 years, 5 months ago

  By: Grant Fritchey

• Weird problem with changing databases

  I just came across something weird, and was wondering if anyone knows about this. I have two struct…

  Ray K

  12 replies

  13 years, 5 months ago

  By: Ray K

• Grouping Time Stamp using T-SQL

  With cte_time As (Select 100 As event_id, '2012-11-29 06:00:00' As event_ts UNION ALL Select 200…

  rka

  1 replies

  13 years, 5 months ago

  By: Mark Cowne

• QUERY OPTIMISATION AS IT TAKES MORE THAN ONE MINUTE TO FETCH THE RECORDS

  CREATE TABLE #CLIENTDETAILS( [CLIENTCODE] int NULL , [FullName] [varchar] (100) COLLATE SQL_Lat…

  freecoder

  23 replies

  13 years, 5 months ago

  By: freecoder

• Help with query...

  Hi, I have two tables that have the clustered index columns and the key columns from non clustered …

  PiMané

  1 replies

  13 years, 5 months ago

  By: Gail Shaw

• Search a string from multiple column in a table

  Hi I want to search a string in multiple columns and i want the result from the column which has ma…

  SQL006

  13 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Help with XQUERY

  Hi all, I have the following XML stroed in a table colum. I need to see all the following XML infor…

  Jonathan Mallia

  9 replies

  13 years, 5 months ago

  By: Eugene Elutin

• wiered - Self Referential Key

  All, I have recently faced the below scenario. create table fk_test ( eno int primary key, fno int …

  karthik M

  4 replies

  13 years, 5 months ago

  By: Lokesh Vij

• Charindex within case block

  SELECT UniqueIDSystem ,FullLastFirstName ,Position PositionOrig ,case Position …

  valeryk2000

  7 replies

  13 years, 5 months ago

  By: Sean Lange

• Compare results in a table with different dates

  Hi all, Trying to query a table that has sys.configuration data thrown in it to see if anything ha…

  n00bDBA

  7 replies

  13 years, 5 months ago

  By: n00bDBA

• Invalid Column Name

  When I run this query I got an error 'Invalid column name 'Gender' ' SELECT ROW_NUMBER() OVER( ORDE…

  kapil_kk

  1 replies

  13 years, 5 months ago

  By: Eugene Elutin

• Help with query - convert to int based on varchar value

  Hi i'm new here to SQL Server Central and after lurking for a bit it seems like a great community. …

  cs_source

  4 replies

  13 years, 5 months ago

  By: s_osborne2

• Keeping Current

  Hi All... I have a set of databases located at a facility hours away. I have a machine here at the…

  mike 57299

  3 replies

  13 years, 5 months ago

  By: OTF

• Show Blanks as Blanks or NULL in Date Field

  Hi All, I have a table which stores Dates as Text.I want to Convert that text into Date when sel…

  santa326

  5 replies

  13 years, 5 months ago

  By: s_osborne2

• Opinions/Advise on performance of a Query to get Login Information

  Hi Everyone, I'll start with posting DDL and Sample data : --DDL Create Table Ex ( EmployeeId…

  vinu512

  1 replies

  13 years, 5 months ago

  By: David McKinney