T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need a backup script to get backup history status for the latest backup from all linked sql servers

  Hi Guys, I am actually in need of a t-sql or a powershell script that will help me get the latest b…

  Feivel

  16 replies

  13 years, 3 months ago

  By: Feivel

• Get the substring after second white space

  I have a requirement here. There is a string '0005 ganeshkumar A999'. I want the last four characte…

  Ganeshkumar005

  13 replies

  13 years, 3 months ago

  By: Dwain Camps

• Transpose rows dynamically / Recursion / Dynamic PIVOT

  I have a table as follows: Row#, Account#, ..., Column_40 With data that looks like: 1, 100, ...., …

  hkflight

  1 replies

  13 years, 3 months ago

  By: Dwain Camps

• Insert comma delimited values in table

  @id = 1,2,3,4,5 @name = 'NY, NJ, VA, DC,CA' I have a temp table called #tmp (id int, name varchar(4…

  dallas13

  2 replies

  13 years, 3 months ago

  By: Ron McCullough

• need help fixing the table to get the desired output

  Create table collapselist ( mnbr int, Pid int, Pname varchar(10), Jid int, Jname varchar(10…

  penu.v8

  1 replies

  13 years, 3 months ago

  By: Kenneth.Fisher

• export table with a geometry column

  I tried to export data from one server to another server, they are both 2008. When using export wiz…

  sqlfriend

  3 replies

  13 years, 3 months ago

  By: mickyT

• sp_ExecuteSQL View Creation

  Hi All I have a maintenance process to run whereby Indexed views are dropped and recreated during d…

  WoundedParrot

  8 replies

  13 years, 3 months ago

  By: Kenneth.Fisher

• Comparing Conditional WHERE clauses

  I've been trying to find performance stats on different ways to do conditional WHERE clauses. Take…

  Erin Ramsay

  3 replies

  13 years, 3 months ago

  By: ScottPletcher

• SUM() + GROUP BY + JOIN

  All, I have some queries as below. create table nav ( id int, amt decimal(16,8) ) insert into nav s…

  karthik M

  3 replies

  13 years, 3 months ago

  By: calvo

• Error converting data type varchar to numeric

  I get this error when using this function: CREATE FUNCTION dbo.[PSBPR_FormatData] (@DataValue DECI…

  DougG

  16 replies

  13 years, 3 months ago

  By: ~nano

• Neew T-SQL for setting date

  UPDATE [tblTransactions] SET [AllocatedDate] = ........ Basically I need to set AllocatedDate to "T…

  DaveBriCam

  3 replies

  13 years, 3 months ago

  By: DaveBriCam

• Want one values with similar ids

  Hi friends i have a question Id Transcation amount 1 20000 1 3…

  somillohani

  6 replies

  13 years, 3 months ago

  By: Dwain Camps

• sql server connection string

  I am trying to determine what is the best login for an application that is connecting to a sql serv…

  wendy elizabeth

  1 replies

  13 years, 3 months ago

  By: Vedran Kesegic

• IF or CASE on 2 different columns, THEN values x, y or z

  I'm trying to do a CASE statement comparing different columns for different result sets, and am won…

  Clarie DeWayne

  4 replies

  13 years, 3 months ago

  By: Clarie DeWayne

• Change rows into column without using pivot method.

  Change rows into column and vice versa without using pivot method.

  anandvish2006

  4 replies

  13 years, 3 months ago

  By: ChrisM@Work