T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• sql server truncates leading 0's for an integer column

  I know for a integer column(say ID) sql server truncates any leading 0's but i have a particular sc…

  sandyinfowave

  10 replies

  14 years, 11 months ago

  By: GSquared

• run sprocs with date

  I'm running a procedure other one wrote. It has a input parameter EndDate VARCHAR(10) and in the st…

  sqlfriend

  5 replies

  14 years, 11 months ago

  By: Ron McCullough

• Handle NULLs

  I have a situation where I'm querying two tables, each that has up to two hobbies listed. The first…

  Mike Scalise

  92 replies

  14 years, 11 months ago

  By: Orlando Colamatteo

• Filter challenge

  Hi helpers, Could you please help me with the following? How can I filter the following sample? No …

  JohnDBA

  33 replies

  14 years, 11 months ago

  By: Paul White

• T-SQL Linked Server Query to Stop a JOB and Start it again

  Hi I need a Tsql Query to stop a job - referesh it and start it again. I have a job which runs for …

  xXShanXx

  3 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• Why Index Scan instead of Index Seek

  I have a query select top (1) A, B, C from …

  Steve-443559

  7 replies

  14 years, 11 months ago

  By: Gail Shaw

• Recursive problem

  Hi, I have got an Unit of Measure table in my database currently. I need function to calculate the…

  dewaldf

  2 replies

  14 years, 11 months ago

  By: Paul White

• How to call a UDF from a linked server inside and select query

  I have been trying the following to do an insert into a table using a UDF which is located on a lin…

  dndaughtery

  2 replies

  14 years, 11 months ago

  By: The Dixie Flatline

• Where clause

  Hi All, I have an issue, Where I have a set of values in the where clause, In those set of values, …

  ssc_san

  4 replies

  14 years, 11 months ago

  By: ssc_san

• CTE race condition?

  Today on SQL 2008 I was working on a query that seemed to run fine on production in the morning and…

  Cody Konior

  6 replies

  14 years, 11 months ago

  By: Paul White

• Reducing joins on same table

  Hi everybody, since this is my first post here i want to say thank you for delivering such great co…

  christian.kuewen

  3 replies

  14 years, 11 months ago

  By: christian.kuewen

• make sargable

  Hello, I remember reading functions in WHERE clauses aren't sargable or something like that. I foun…

  smallmoney

  4 replies

  14 years, 12 months ago

  By: smallmoney

• Create Stored Procedure in Batch file not allowed?

  I'm trying to create a batch file that I can hand off and someone else can run to update our schema…

  andy.gear

  3 replies

  14 years, 12 months ago

  By: andy.gear

• Update Column WHEN table1.field_name = table2.field_name WITH table2.field_name_2

  Hello - I am trying to update a column in my table using the following code: UPDATE dbo.MasterStag…

  Triality

  6 replies

  14 years, 12 months ago

  By: Triality

• Indexes:Few querries

  Hi all Indexes have been discussed a numerous time both in this forum and outside this forum but s…

  koustav_1982

  8 replies

  14 years, 12 months ago

  By: The Dixie Flatline