T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• declare @a = max(len(fieldX)) > convert(varchar(@a),fieldX)) - why does this fail?

  For formatting reasons I want to: DECLARE @a INT SELECT @a = MAX(LEN(fieldX)) FROM tabY SELECT @…

  snomadj

  3 replies

  14 years, 7 months ago

  By: snomadj

• Help with a sql query

  Hi All, I need help with writing a sql query. This is how my table is structure NameABCdE John…

  hussain27syed

  8 replies

  14 years, 7 months ago

  By: Welsh Corgi

• Count and compare the no. of chars in a text field

  Hi All I need to query a column in a particular table to find out which entries in that coulmn cont…

  Phineas Gage

  2 replies

  14 years, 7 months ago

  By: Phineas Gage

• T-SQL Question

  I have to write a query that will output a ---fixed lenght -- sequential text file? for example I h…

  Maique

  12 replies

  14 years, 7 months ago

  By: Jeff Moden

• Running different peice of code for different parameters in single stored proc

  I have 3 input parameters and I want to run different peice of code for all 3 different parameters.…

  jaya

  3 replies

  14 years, 7 months ago

  By: LutzM

• SQL Server 2008 Uniqueidentifier as Primary Key

  Hi All, I'm having 40 tables in my database and each table is having uniqueidentifier datatype colu…

  User7766

  9 replies

  14 years, 7 months ago

  By: Eugene Elutin

• speed up and lean up my SQL Statement that will be come a view

  Will you look at my SQL Statement and give me ideas on how to speed it up and make it leaner. It wi…

  twdavis-893252

  5 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• How will you write a query for this scenario

  I have a table called patientDates PatientId int, DivDate datetime There can be multiple dates for …

  vermarajiv

  32 replies

  14 years, 7 months ago

  By: Flexdog

• Help with Query

  Consider the following scenario: Tracking cases by doctor's username - two types of cases: OBCases …

  garry.j.frenkel

  3 replies

  14 years, 7 months ago

  By: garry.j.frenkel

• Using TableDiff.exe ??

  Hello, I am trying to make use of this executable which is included in SQL. How to compare 2 tabl…

  anand_vanam

  2 replies

  14 years, 7 months ago

  By: Jayanth_Kurup

• any one with good nd great knowledge on partitioning can solve this question.........

  i partition the table by datetime. After that i tried to insert the data into the partition table. …

  sqlmaverick

  1 replies

  14 years, 7 months ago

  By: Lynn Pettis

• Before create a procedure send a trigger to a table

  Hello folks I´d like to know if I can create a trigger that verifies procedure name exists into a c…

  ulisseslourenco

  4 replies

  14 years, 7 months ago

  By: ulisseslourenco

• Tuning a query

  Guys, I am stuck with a task here. there is a procedure which gets called from a report but the pr…

  chandan_jha18

  43 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• Use Dynamic SQL in a function? Not working.

  Hi All: I'm trying to build a function that has to use some dynamic SQL. There are two input value…

  CptCrusty1

  15 replies

  14 years, 7 months ago

  By: CptCrusty1

• String to binary

  Hello, I like to convert string to binary in SQL Server 2000, the code I used to do this is decl…

  dfine

  1 replies

  14 years, 7 months ago

  By: Lowell