T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to obtain the SUM from a CASE statement

  Hello, I'm trying to obtain the overall SUM from a CASE statement within a query I wrote. Below is…

  PFlorenzano-641896

  8 replies

  13 years, 3 months ago

  By: LutzM

• Trigger or Insert issue: Not generating the correct data

  HI Guys I have an issue, it is either with my trigger or when i simply insert a row into a table. B…

  ram_kamboz2k7

  15 replies

  13 years, 3 months ago

  By: Lowell

• how to know the log size of a table after removing some records from a table

  hi, 1.how to know the log size of a table after removing some records from a table?? 2.My table ha…

  punna

  1 replies

  13 years, 3 months ago

  By: spaghettidba

• writing prfessional queries

  I am writing sqlserver queries from a long time....can you help me how to write insert/update and d…

  MuhammadShafiq

  4 replies

  13 years, 3 months ago

  By: spaghettidba

• Concurrency Issue

  From a long time i have an interesting question in my mind.Would you people like to clear me here i…

  MuhammadShafiq

  6 replies

  13 years, 3 months ago

  By: LutzM

• xp_cmdshell and transactions

  Hi all, Got a situation which I'll simplify into the following question. Let's say I have this bloc…

  kramaswamy

  6 replies

  13 years, 3 months ago

  By: kramaswamy

• Bulk Insert processing

  I have a question regarding Bulk Insert and how it processes and connects to the import file. I hav…

  TeraByteMe

  1 replies

  13 years, 3 months ago

  By: sengeet86

• Constructing XML data

  Although I have extracted XML data on occassions, I have never constructed more than very basic XML…

  BrainDonor

  2 replies

  13 years, 3 months ago

  By: BrainDonor

• how to change oracle query for 2005 tsql use?

  I need some help please. I have a oraqle query, that i need to change to use in tsql 2005 I am not …

  Keri Taylor

  1 replies

  13 years, 4 months ago

  By: Eugene Elutin

• how to get the Every Friday to Thursday wise data in any Month

  For example: Feb 2012 i want bellow format: 1-2 1week, 3-9 2ndweek 10-16 3rdWeek 17-23 4th Week 24…

  narendra.babu57

  4 replies

  13 years, 4 months ago

  By: Cadavre

• The best function to use when writing to a text file

  Hi Guys The topic subject says it all really? Which is the best function to use when writing data t…

  ram_kamboz2k7

  1 replies

  13 years, 4 months ago

  By: Eugene Elutin

• If table exists, insert into

  Hi, I don't know if I've just been staring at this too long and can't see something obvious, but I'…

  adb2303

  4 replies

  13 years, 4 months ago

  By: Cadavre

• Update statement failed

  Hi, I am updating a table in a db in a remote server by using LINKED SERVER. I checked the connecti…

  SkyBVI

  1 replies

  13 years, 4 months ago

  By: SkyBVI

• Can you get query plan to WHERE inside a GROUP BY?

  I have a simple view: CREATE VIEW vw_quickview AS select quick.Instrument_Id, quick.TimeDate…

  neil-560592

  7 replies

  13 years, 4 months ago

  By: neil-560592

• Converstion Error Message in Update Statement

  (sorry that I posted in the wrong place; can't seem to find how to change categories or delete) SQL…

  Chris Gehringer

  2 replies

  13 years, 4 months ago

  By: Chris Gehringer