T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 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, 5 months ago

  By: Jeff Moden

• searching for address matches using sql server 2008 full text search

  Hi, I am not sure how to search for address matches using sql server 2008 full text search. TableA…

  Sridhar-137443

  6 replies

  13 years, 5 months ago

  By: jcb

• need help with a query

  I want to compare column values of 2 consecutive records in a table of 425 records and capture the…

  Pyman

  11 replies

  13 years, 5 months ago

  By: Jason-299789

• No record count in PIVOT

  Hi, I have the following query to count the number of employees per costcenter using the pivot comm…

  michielbijnen

  14 replies

  13 years, 5 months ago

  By: michielbijnen

• Default fillfactor kept by SQL Server when it is rebuilding the indexes.

  Hi, When we want to do performance tuning we usually rebuild the indexes. When SQL Server is rebuil…

  Shadab Shah

  4 replies

  13 years, 5 months ago

  By: Jeff Moden

• List of SP

  Hi guys, Need help, how i can get the list of SP in my Database that were not accessed in the last…

  rocky_498

  2 replies

  13 years, 5 months ago

  By: Jeff Moden