T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Grouping a String by everything other than the last numbers considering they exist

  Hey Guys, Our database has Unique SKU's for each product, however when it comes to Jewelry every s…

  miker 8667

  2 replies

  13 years, 1 months ago

  By: miker 8667

• sql server connection to database

  if the following is in the connection string in an app.config file, the following will use the sql …

  wendy elizabeth

  2 replies

  13 years, 1 months ago

  By: wendy elizabeth

• How can I caliculate Number of times my job runs between any selected dattime

  Hi I have a job which is runs every 6 hours a day. 2:00 AM, 8:00 AM, 2:00 PM, and 8:00 PM. For any …

  Mac1986

  3 replies

  13 years, 1 months ago

  By: Ant-Green

• Trying to select XML data for one tag from an text field and isn't returning the data I need

  Hello DBA's/Developers, I'm trying to select XML data from one tag that is stored in an TEXT data t…

  davidsalazar01

  7 replies

  13 years, 1 months ago

  By: Cadavre

• 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, 1 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, 1 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, 1 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, 1 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 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, 2 months ago

  By: DaveBriCam