T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Urgent: 8 Consecutive days worked

  Hi All, I have table with columns: [ASSOCIATEID] [LASTNM] [FIRSTNM] [STRNBR] [D…

  kotteesh

  1 replies

  15 years ago

  By: spaghettidba

• how to create surrogate id for view in tsql

  hi, i have problem in tsql while creating the surrogate key for a view table. can any one hel…

  maheshkrishnas

  5 replies

  15 years ago

  By: Jayanth_Kurup

• can we create surrogate id on view table

  Hi, this is my table i need to create a view table for this with surrogate Key can any one help on…

  maheshkrishnas

  1 replies

  15 years ago

  By: Jeff Moden

• Help with another developer's T-Sql asp.net code

  Here's the stored procedures. 85% of the time table 1 is being populated, the other 15 percent it …

  pym8

  3 replies

  15 years ago

  By: Jeff Moden

• incorrect Charindex results for unicode text

  For the following i am getting incorrect charindex in case of 2nd select charindex('a',N'aृ'). If a…

  Murthy-152277

  3 replies

  15 years ago

  By: mister.magoo

• XQuery and syntax of either query or value method to pull data from xml column

  What should the proper syntax be to pull the data back where value2 is yo5? SELECT AdditionalData.v…

  Barret-330682

  3 replies

  15 years ago

  By: Orlando Colamatteo

• Way to insert into a table one row at a time??

  Is there a way in t-sql or ssis to go through a table row by row and insert each record into anothe…

  asm1212

  6 replies

  15 years ago

  By: Lowell

• Conversion failed when converting datetime from character string

  Hi All, When I try to run the below code with @test-2 = '2009 12 17 22 31 00 000', It works fine, …

  ssc_san

  3 replies

  15 years ago

  By: ssc_san

• SP or function to create a one to many table

  Morning, I know the title is a bit obscure, essentially what I would like to do is use the stinters…

  olibbhq

  3 replies

  15 years ago

  By: Jan Van der Eecken

• query for continuous period

  Hi, I have been facing an annoying issue and not able to overcome it. Need some inputs from experts…

  Aspg

  17 replies

  15 years ago

  By: Jeff Moden

• Avoiding index scan

  I am on a database in sql2000.I have a small table with 300000 records and there is a small query t…

  chandan_jha18

  4 replies

  15 years ago

  By: Paul White

• Help with replacing Superscript 2

  I am converting a scientific print catalog to be diplayed on the web. I would have been using the T…

  mpdillon

  4 replies

  15 years ago

  By: Orlando Colamatteo

• Data for the current week

  Hi, I m trying to write a query to find out all the data in the current week. Like, If I run query …

  ssismaddy

  6 replies

  15 years ago

  By: LutzM

• Using While loop logic...looking for something better

  My Project's Outline: Parse a file that has up to 1200 characters per line. We have definitions for…

  jarid.lawson

  5 replies

  15 years ago

  By: Orlando Colamatteo

• Help Required Pleased: I don't even know how to pharase the question to search for an answer myself :-(...

  Hi All Imagine i have a query returning two columns (EventID, EventType) like this (I've added a 3r…

  BCLynch

  17 replies

  15 years ago

  By: Evil Kraig F