T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Date Difference Between to dates

  Dear All; Any one help to solve this problem CIDEmpId EDATETIMEs F…

  sqlfriends@sql.com

  4 replies

  15 years ago

  By: parthi-1705

• Performing a datediff between 2 timestamps, but excluding weekends

  I have to provide a report on how long it takes to produce an order. The time must not take into ac…

  _Beetlejuice

  1 replies

  15 years ago

  By: Paul_Blackwell

• Insert into table using function.

  Hi all, I've been busting my head trying to create a function that inserts into a table and returns…

  JohnG69

  9 replies

  15 years ago

  By: clarkandreson101

• Collation Problem

  Hi All, Let me first outline my environment and then ask the question to my problem. I restored a S…

  gbd77rc

  4 replies

  15 years ago

  By: gbd77rc

• need help find overlapping dates in a table

  we have a table we store rates in we re-use the rate table names but use date ranges and primary ke…

  Mountain Steve

  10 replies

  15 years ago

  By: WayneS

• Merge statement using only table variables fails

  Testing for new features of SQL2008 R2 I stumbled on a problem with merge. When I use only table va…

  Johan Bijnens

  9 replies

  15 years ago

  By: chaitanyagoa

• Date columns of the month matrix report

  Hi All, I have an application in which i have following 2 tables. Tasks Master ------------- Task_I…

  joshtheflame

  7 replies

  15 years ago

  By: joshtheflame

• SSIS Data Conversion

  Hi, I created a package which copies data from one db1 to another db2. So in columns in one DB1 are…

  tripri

  3 replies

  15 years ago

  By: SQLRNNR

• request a parameter when running sql

  Does anyone know of a way so that when a stored proceedure is executed the user is asked to enter a…

  LoosinMaMind

  2 replies

  15 years ago

  By: GSquared

• Most efficient parsing of Juniper syslogs in SQL?

  Hello, Im about to start investigating how to do the follow, but any direction would be much apprec…

  Pete-L

  5 replies

  15 years ago

  By: Pete-L

• Clustered Index question

  Hi, Come across a couple of strange things when working with a clustered indexes using a test table…

  jonwolds 8288

  5 replies

  15 years ago

  By: jonwolds 8288

• Need a Help in Importing CSV file into DB

  Dear Experts, I have a difficulty task in SQL Procedure creations, I have to Import the csv file i…

  Saravanan_tvr

  10 replies

  15 years ago

  By: Saravanan_tvr

• Year to Today sales Figure

  Hi All, I need to calcualte the Year to Today sales details from last 4 years Is any simple sql sta…

  Mathew M.Varghese

  6 replies

  15 years ago

  By: tfifield

• Update a date field to a specific day and time

  I have a temp table in which I want to update a date field. If the date field is after 07:00, I wan…

  Rog Saber

  3 replies

  15 years ago

  By: Rog Saber

• Is it Poosible to Update the table with View one More table?

  Hi All. I have view with 3 tables inner joined, While I Bulk update with data , I have to Write thr…

  Saravanan_tvr

  2 replies

  15 years ago

  By: movnabbs