T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• SUM relative to row date value

  Dear all, With a table like this shown below, I'd like to use the Yearmonth value and then sum the …

  greg.bull

  24 replies

  14 years, 3 months ago

  By: greg.bull

• Replace text string containing 2 character hex values with there CHAR values

  I'm doing some performance tuning for a ETL process. In a particular string fields we have a a vari…

  Paul Sims-405749

  1 replies

  14 years, 3 months ago

  By: Martin Schoombee

• Has anybody constructed dynamic SQL by storing SQL in fields in tables?

  I've been working as a Contractor for an organization documenting their stored procedures and proce…

  Francis McFaul

  26 replies

  14 years, 3 months ago

  By: tfifield

• subquery recursive?

  Hi, I'm building a query related to account-agency This is the query that I want to show: accountco…

  Lou

  4 replies

  14 years, 3 months ago

  By: Lou

• Trying to Pull the First Incomplete Operation

  We have mfg jobs with several operations, and they always go in operation number sequence. I have b…

  ducksql@gmail.com

  7 replies

  14 years, 3 months ago

  By: ducksql@gmail.com

• is there a max size for the attachment size in msdb.dbo.sp_send_dbmail

  trying to attach an excel file thats 4 megs and i get the below error Msg 22051, Level 16, State 1,…

  BaldingLoopMan

  5 replies

  14 years, 3 months ago

  By: SW_Lindsay

• to create a view by record set of a system sp

  Is it possible to create a view that will be populated by record set generated by execution of a sy…

  Atif

  3 replies

  14 years, 3 months ago

  By: gpolelo

• System Databases and DBPro........

  I have a database project I am trying to create. It references several objects in MSDB and one in M…

  Angelindiego

  4 replies

  14 years, 3 months ago

  By: Angelindiego

• Dealing with a "replicated" system

  Hi all, Title doesn't really explain my situation very well, so I'll try to be a bit more clear. I'…

  kramaswamy

  1 replies

  14 years, 3 months ago

  By: kramaswamy

• Find String like 'aaaaa' or 'bbbbbb' or 'cccccc' etc....

  Hi guys, In order to clean up some tables in my database I would like to find all records like 'aaa…

  peanuts91

  17 replies

  14 years, 3 months ago

  By: peanuts91

• Finding Max Value from a 4-character Date String

  Hi all, Somewhat of an odd question maybe, but it makes sense given my context I have a table which…

  kramaswamy

  6 replies

  14 years, 3 months ago

  By: kramaswamy

• Convert to UTC and find out date difference in seconds ?

  I have a date time as '4/26/2011 5:00'. I need to convert this to UTC format and find out the diffe…

  SQL Kidu

  3 replies

  14 years, 3 months ago

  By: drew.allen

• SQL example for Procedural & Declarative

  Hi All, I have recently read about Procedural language and Declarative language. I need a classical…

  karthik M

  10 replies

  14 years, 3 months ago

  By: karthik M

• Single row to multiple columns

  Hi All, I have to split the below signle row into multiple columns.Since i have to use the same que…

  karthik M

  41 replies

  14 years, 3 months ago

  By: Jeff Moden

• Want a solution on cursor problem

  Hi All, I am in trouble with cursor problem, please give me a hint, ideas or links to solve it. I w…

  prashavhad

  7 replies

  14 years, 3 months ago

  By: prashavhad