T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Very cool problem -- with Dymamic SQL, Backups/Restores, and variables (maybe)

  This is a really cool solution to a common problem: this script auto-generates exactly the right RE…

  jpSQLDude

  14 replies

  14 years, 10 months ago

  By: bopeavy

• Seeking advise on the diff

  Greetings, I need your expertise on my issue. I do two tables, each has only one simple column (va…

  john9569

  3 replies

  14 years, 10 months ago

  By: Eugene Elutin

• unpivot help

  I have a table I am trying to unpivot the data in NameIDExamid1 Examproduct1Examid2 …

  dave 92282

  3 replies

  14 years, 10 months ago

  By: Eugene Elutin

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

  By: ulisseslourenco