T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Mask a column for SSMS

  I know this is not a new topic but there does not appear to be agood solution for my needs. The pr…

  bopeavy

  31 replies

  15 years ago

  By: Lowell

• Which procedures or function srae using my table???

  Hi, I am in middle of a huge replication project. My database has many tables which do not have pri…

  chandan_jha18

  14 replies

  15 years ago

  By: Jim Murphy

• Need Help on basic syntax for SQL Function

  create Function fn_test(@TestCol int) returns table as If (@TestCol =1) select 'Abc' as Col1 else…

  s-sql

  4 replies

  15 years ago

  By: s-sql

• List of databases in servers

  Hi I gto different servers whose names start with MSX like MSX001, MSX34, MSX674 and so on.. Now i …

  tripri

  1 replies

  15 years ago

  By: Lowell

• How to optimize this query

  I have this query where each select runs very fast, approx 1 to 2 seconds on a table with almost a …

  seftest_09

  19 replies

  15 years ago

  By: seftest_09

• Msg 235, Level 16, State 0, Line 28, Cannot convert a char value to money. The char value has incorrect syntax.

  We had a SQL statement that is similar to the following on SQL 2008 R2 (10.50.1600) on a 64-bit ser…

  TCCaines

  1 replies

  15 years ago

  By: SwePeso

• XML Output Question

  I need to format the output of a query to XML. There are only two columns in the output: tblCatego…

  DB Dude

  3 replies

  15 years ago

  By: DB Dude

• Cursor issue, @@fetch_Status turned out as -2

  I want to execute a SP in all databases, I have 40 Dbs on a server, Cursor executes, sometimes for …

  nic2885

  1 replies

  15 years ago

  By: nic2885

• Cursor possibility?

  Hi All I have a sp that has 100 columns where I perform the same CASE and function call on each of …

  TecheeGirl

  3 replies

  15 years ago

  By: TecheeGirl

• EXEC()

  Is it possible to issue multiple DML statements via one EXEC command? I have a linked server (Micro…

  Mike Scalise

  17 replies

  15 years ago

  By: Sean Lange

• string manipulation related.

  Hello all, I am in a situation where i need to find a particular string in an xml file 'itemid 285'…

  ekant_alone

  2 replies

  15 years ago

  By: ekant_alone

• Conversion failed when converting date and/or time from character string.

  Hi Guys., stored Procedure : USE [TMSLocal] GO /****** Object: StoredProcedure [dbo].[GetUpcomingE…

  ranganathanmca

  1 replies

  15 years ago

  By: ranganathanmca

• Union All - gets slow performance and timeout expired

  Hi, Please give me good solution as below SQL statement, application gets error - Timeout expired. …

  SQL Galaxy

  10 replies

  15 years ago

  By: Ken McKelvey

• Return the query in a particular format

  Here is my query I need to get All in the first row and the remaining in the alphabetical order sel…

  rasikawtc

  1 replies

  15 years ago

  By: manub22

• Profiler, SP_prepare

  I do the SQL Support on what is the worst written app I have seen in 30 years in the business. It'…

  manodak

  2 replies

  15 years ago

  By: paul.knibbs