T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• SQL Express - Create maintenance plan to run truncate table

  Hi - I am new to SQL express, can someone please guide me to how I can schedule a task to run trunc…

  lsalih

  15 replies

  13 years, 4 months ago

  By: lsalih

• SQL query

  CREATE TABLE #holding( [TIDM] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CLIENT…

  freecoder

  4 replies

  13 years, 4 months ago

  By: Cadavre

• findingdifference between full or partial index scan in graphical execution plan?

  hi all, many times when looking to graphical excution plans I see the operator "clustered index sca…

  WolfgangE

  10 replies

  13 years, 4 months ago

  By: Grant Fritchey

• multiple columns to single column (normalization)

  Hi, I'm working on normalizing a small part of our DB, but having trouble building a particular que…

  memymasta

  6 replies

  13 years, 4 months ago

  By: WolfgangE

• string with int

  pretty basic so appreciate the help here,getting conversion error , what is the way to have int var…

  sqlquery-101401

  4 replies

  13 years, 4 months ago

  By: Eugene Elutin

• Converting a string to a date

  Hello everyone, I have 3 fields, all text strings but all supposed to represent dates. Field 1: var…

  dj1202

  5 replies

  13 years, 4 months ago

  By: Steven Willis

• String manipulation with variable

  i am trying to use @datestamp variable in simple string , but not luck , i dont want to use another…

  sqlquery-101401

  3 replies

  13 years, 4 months ago

  By: sqlquery-101401

• Optimization of stored procedures

  Hi, I have a number of stored procedures used for reporting and whenever we run these reports it sl…

  Nikhi123

  9 replies

  13 years, 4 months ago

  By: sqlnaive

• XML In Where Clause

  Hi, I am trying to search for rows by comparing a field (xml) in a table to an XML input parameter,…

  pierrebas

  5 replies

  13 years, 4 months ago

  By: Mark Cowne

• Adventure Works database

  I treid to install the Adventure Works sample database in my system but am not able to install that…

  kapil_kk

  1 replies

  13 years, 4 months ago

  By: TheMaskedDBA

• Rename Column

  I have a column name with name 'Procedure.ID' and want to rename it as 'ProcedureID' i write as: sp…

  kapil_kk

  1 replies

  13 years, 4 months ago

  By: kapil_kk

• Updating ID

  I have a table PatientLocDtl in which I need to update AccountIDon basis of ChartNo and PatientID. …

  kapil_kk

  3 replies

  13 years, 4 months ago

  By: kapil_kk

• Check this correct - my DBCC script

  Hi, I intend to run this against all our SQL Servers to check every database (not done nearly enoug…

  learning_sql

  5 replies

  13 years, 4 months ago

  By: learning_sql

• Which is best Inner join or Left outer join

  hope i get a solution here This is my DB structure CREATE TABLE [dbo].[TableA]( [id] [int] NOT…

  thava

  15 replies

  13 years, 4 months ago

  By: Jason-299789

• Weekly data converted to months

  Hi all. Hope you can help. I have data that is structured by week format. Year Week Total 20…

  scottsanpedro

  8 replies

  13 years, 4 months ago

  By: Jeff Moden