T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Parsing Out A String Into Separate Fields

  I'm looking to parse out a string into separate fields and I'm looking for a good solution to do th…

  joshdbguy

  3 replies

  9 years, 9 months ago

  By: Sean Lange

• How to add hours in SQL query

  Hi, I'm querying cube my last update like this : SELECT [CATALOG_NAME], [CUBE_NAME], [LAST_DATA_UPD…

  axaeffect 37346

  5 replies

  9 years, 9 months ago

  By: axaeffect 37346

• Help me with this syntax (1Customer code note more)

  I've Next Question . I am currently working on a location dimension. The following is not going so …

  GG_BI_GG

  1 replies

  9 years, 9 months ago

  By: Jeff Moden

• Need help on using a single SELECT query to transform a table, thanks.

  Hello, I have a table in the following structure: CREATE TABLE [dbo].[WeeklySummary]( [ID] [int] …

  halifaxdal

  5 replies

  9 years, 9 months ago

  By: halifaxdal

• How to return a date in Australian date format?

  Hello all, can somebody give me a hint on how to return a date in Australian date format? I aware t…

  marin-231997

  9 replies

  9 years, 9 months ago

  By: drew.allen

• SQL Server getting crashed sporadically

  Dear SQL Guru's, I have a scenario in one of our prod SQL Server. Build is SQL Server 2008 R2 SP3, …

  abendigeri

  2 replies

  9 years, 9 months ago

  By: abendigeri

• Why I can not search all records in my fn_dblog

  I am currently work with SQL 2008, I want search my transaction log which never truncate before and…

  calvin_wk_wong

  5 replies

  9 years, 9 months ago

  By: Gail Shaw

• Permutations of Orders

  Hi All I have an order table with order number and size of paper length. I need to find out the dif…

  bhaskar18

  2 replies

  9 years, 9 months ago

  By: serg-52

• How to run a view every 1000 rows to add in table?

  I have a view that have a total of rows 30Million. When i start mij SSIS package and my view runs t…

  GG_BI_GG

  3 replies

  9 years, 9 months ago

  By: GG_BI_GG

• Alternative Way to Parse JSON String?

  I know there are JSON parsers out there, but I'm hoping to avoid using a separate function as the q…

  omegadev21

  15 replies

  9 years, 9 months ago

  By: Jeff Moden

• Where clause prevents index seek

  A vendor script is doing a query like this: use databaseABC select column5 from table10 where '_' +…

  PHXHoward

  22 replies

  9 years, 9 months ago

  By: Lynn Pettis

• Transaction Data Base Table Design

  Hi Friends, We are Designing Database for a project. We have 1) Customer Master Table 2) Item maste…

  venkatesh.naikd

  8 replies

  9 years, 9 months ago

  By: ZZartin

• Help Needed in dynamic sql

  Hi, below is my sample query declare @Query nvarchar(max) DECLARE @Names VARCHAR(8000) Declare @tab…

  KGJ-Dev

  10 replies

  9 years, 9 months ago

  By: ScottPletcher

• Need help on sql query

  Hello , I have a table like this in sql server 20018 ID | COLA | COLB | COLC | ---------------…

  dprasannain

  7 replies

  9 years, 9 months ago

  By: Luis Cazares

• One to Many relationship in Join performance issue

  Hi Friends, I have one query which is taking huge time to execute. below is a query used in source …

  Re1

  2 replies

  9 years, 9 months ago

  By: Ed Wagner