T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help needed for a complex query.

  I have a table with large data. The structure along with the sample data of the table is as follows…

  KnowledgeSeeker

  14 replies

  11 years, 9 months ago

  By: KnowledgeSeeker

• Procedure Cache Hit Ratio

  Hi all I'm putting together some monitor scripts, have buffer cache ratio etc etc but struggling to…

  david.alcock

  1 replies

  11 years, 9 months ago

  By: david.alcock

• How do i handle login request?

  hi, i have a C# form as the client that sends login credentials (user / password) to SQL server. Im…

  sleekbinary01

  8 replies

  11 years, 9 months ago

  By: crmitchell

• Help needed

  create table #temp (id int, data varchar(80)) insert into #temp (id, data) select 1, 'a,b,c' union …

  raghava_tg

  8 replies

  11 years, 9 months ago

  By: Sean Lange

• Modify Job Log Path

  We are changing our drives this weekend.. and will have a different drive letter to write out job l…

  dwilliscp

  2 replies

  11 years, 9 months ago

  By: dwilliscp

• T-SQL Query help

  I have one table dbo.t1 with data like this: Col1Col2Col3 XYZ12RXM XYZ13XUV XYZ14RXM MOP22…

  sqlnaive

  9 replies

  11 years, 9 months ago

  By: sqlnaive

• Schedule table with open/closed slots

  I am trying to create a schedule/calendar. Table A shows my slots. Table B shows start/end times fo…

  Rog Saber

  3 replies

  11 years, 9 months ago

  By: Rog Saber

• Sequential data selection

  Hi All, how to identify different fields with in a group of records? Example: create table #test (…

  ssc_san

  1 replies

  11 years, 9 months ago

  By: Sean Lange

• T-SQL Order by on date descending in a column

  Below SQL gives the results of 2 columns and I need the DepartmentandDate column to be ORDER BY on …

  etirem

  6 replies

  11 years, 9 months ago

  By: Sean Lange

• Calculating Total Outage Time

  Hi I have a requirement to calculate the total outage time, based on logged fault tickets, of netwo…

  therron134

  3 replies

  11 years, 9 months ago

  By: mister.magoo

• comparing the column values in same table.

  Help needed for the below task as i am not able to get a hint how to resolve the below task create …

  raghava_tg

  6 replies

  11 years, 9 months ago

  By: raghava_tg

• Using CASE statement within a PIVOT

  Hi Guys, I am using a PIVOT function to obtain the Invoice Values, but they appear in different cur…

  SteveEClarke

  2 replies

  11 years, 9 months ago

  By: SteveEClarke

• Order of the result issue in T-SQL

  HI All, I have an issue while display the result in the required order. please help me to get the r…

  kbhanu15

  5 replies

  11 years, 9 months ago

  By: kbhanu15

• Time Table For simple ETL

  Hi, I am trying to build a simple time table and pre-populate the rows for lets say 1 year. Basical…

  chandan_jha18

  5 replies

  11 years, 9 months ago

  By: Koen Verbeeck

• Date format conversion

  Hello, i am trying to convert a string like this 'le dd/mm/yyyy' into a datetime. I have removed th…

  ralu_k_17

  3 replies

  11 years, 9 months ago

  By: ralu_k_17