T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Change Excel formula to Case Statement

  I have this formula I use within Excel, I'm moving most of the work into SQL & can't think how…

  J39L4753

  14 replies

  12 years, 6 months ago

  By: J39L4753

• wish to add rows having NULL values as placeholders for "missing" dates

  I have a table that contains stuff happening. There's a datetime stamp column to show on what date …

  polkadot

  9 replies

  12 years, 6 months ago

  By: polkadot

• Linking a SQL Server 2005 (Windows Authentication) to a SQL Server 2008 (Mixed Mode)

  I am trying to link a production database (SQL Server 2000) that is on Windows authentication to a …

  always_been_pretty

  1 replies

  12 years, 6 months ago

  By: ArkWare

• Question Regarding Store Procedure

  Hi Guys, I have quick question, I am using SP, in the SP I am using few Insert and Update statement…

  rocky_498

  8 replies

  12 years, 6 months ago

  By: Sean Lange

• Ignore Error in T-SQL

  Hi, How do we ignore an error in T-SQL? For e.g.:- The following code throw an error once the @lCo…

  C.K.Shaiju

  5 replies

  12 years, 6 months ago

  By: C.K.Shaiju

• T-SQL and BCP to qureyout to a file on database premissions

  Ok I at an end, I'm close but no grasping at straws. In this set of statement I collect instance an…

  SirFalcon60

  1 replies

  12 years, 6 months ago

  By: SrcName

• trying to write a case statement for datetime stamp - some trouble

  Hi. I'm working on creating a histogram using time, as the set of 6 buckets that data can fall into…

  polkadot

  6 replies

  12 years, 6 months ago

  By: polkadot

• Displaying nvarchar datatype column having a date value

  Please help me in displaying a nvarchar datatype column called 'txtValue' having date value in the …

  VSSGeorge

  8 replies

  12 years, 6 months ago

  By: Dwain Camps

• Need help on SP

  I'm trying to create an SP to execute the following msdb.dbo.sp_add_jobstep msdb.dbo.sp_update_jobs…

  MSSQL_NOOB

  3 replies

  12 years, 6 months ago

  By: Ed Wagner

• Dropping/Recreating Clustered Index

  Hi SSC, I've got a table with a clustered index which needs to be dropped and recreated to add an a…

  Xedni

  2 replies

  12 years, 6 months ago

  By: Xedni

• Return text from a PDF stored in the database (Adobe iFilter)

  We are storing PDF files inside a SQL Server 2008R2 DB. We have installed the Adobe iFilter to cre…

  merfees_junk

  4 replies

  12 years, 6 months ago

  By: merfees_junk

• get a specific time window across the night between two days

  Hi all I need some help me to get me in the right direction. I have collected some sql stats into a…

  Anonymous

  4 replies

  12 years, 6 months ago

  By: Anonymous

• SQL Agent Question

  Hi Guys, I have Virtual Machine that I installed SQL Dev Edition. Here I need SQL Agent So I can Sc…

  rocky_498

  1 replies

  12 years, 6 months ago

  By: happycat59

• Compare delimited data - same data but in a different order

  Hello All, I am currently working on comparing two versions of data for a comparison report. I ha…

  aochss

  6 replies

  12 years, 6 months ago

  By: aochss

• Using Dynamic SQL to build temp table...doesn't work?

  I am trying to pass a column name as a parameter to build a #temp table combining data from two tab…

  Marcus Farrugia

  5 replies

  12 years, 6 months ago

  By: ScottPletcher