T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Convert XML Data to String / text

  Hi How to convert XML data field to string / text. Example: data is stored in the field is: T…

  Vijji-429978

  8 replies

  17 years ago

  By: OTF

• Equivalent for SQL-Plus's "BREAK ON" in T-SQL

  Hello, I am trying to create a view which gives records. Some of them have the same values over mos…

  discover.sql

  3 replies

  17 years ago

  By: OP_HELP

• Unable to sum correctly Error message

  SELECT distinct SD.ERP_ORDER, SH.SHIPMENT_ID, SH.INTERNAL_SHIPMENT_NUM, SC.ITEM, SC.LOT, SN.SERIAL…

  develope

  3 replies

  17 years ago

  By: develope

• I got an answer of 4 for the above, was expecting that it would be 1.

  declare @table table (id int, [name] varchar(20)) insert into @table values(1,'SQL Server 2005') in…

  VM-723206

  12 replies

  17 years ago

  By: VM-723206

• Create Multiple column Primary key on a table that already exists?

  Hello all. So I can go into the design mode of a table and ctrl + select columns to add them to a p…

  shannonjk

  4 replies

  17 years ago

  By: GSquared

• can this UPDATE statement be optimized?

  I have an imported table with group names that are sharing a special code among rows. The business …

  Jesse Reich

  9 replies

  17 years ago

  By: GSquared

• how to use a column name in argument of top() ?

  Hi, I have been receiving below error when i use top(p.nid) in my select. error: The reference to c…

  descentflower

  15 replies

  17 years ago

  By: Dave Ballantyne

• Select from where problem

  Hi Guys, I'm stuck with a query that I could do with some help on if anybody doesn't mind: It goes …

  lemonsqueezy101

  7 replies

  17 years ago

  By: Paul White

• Save SP Results to a TXT File

  Hi, I am using SQL 2005. I have a SP which creates temp tables from a selection of other tables. At…

  discreetfunct

  3 replies

  17 years ago

  By: discreetfunct

• Shutdown instance, copy database files, and re-attach at destination server.

  Hi All, I have a requirement like, I am working with two servers,one is in intranet(lan or local…

  kishoretukuntla

  6 replies

  17 years ago

  By: ps.

• Charindex and patindex

  Whats's the difference between charindex and patindex. blog: http://sarveshsingh.com Twitter: @sarv…

  ss-457805

  3 replies

  17 years ago

  By: ps.

• date conversion

  table contains date like 071009(mmddyy),42209 (mddyy) how to convert this in datetime?

  rpatil22

  4 replies

  17 years ago

  By: Gatekeeper

• Checking Negative Number

  Hi All I need to check whether a passed number is positive or negative, is there any pred…

  CrazyMan

  6 replies

  17 years ago

  By: Gatekeeper

• Getting DB roles from SQL2000 and 2005

  We had all SQL 2000 servers. I needed to get some information including the roles from each server.…

  Rog Saber

  6 replies

  17 years ago

  By: Rog Saber

• Avoid mulitiple join on same table

  I have a table that has multiple rows for any id I want join all ids that have a one code but not a…

  Robert Klimes

  6 replies

  17 years ago

  By: John Rowan