SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Query approach

  I can figure a number of Big Hammer methods of doing this job, but I"m trying to improve myself and…

  rray 44280

  11 replies

  11 years, 10 months ago

  By: autoexcrement

• Run ASPX file from Stored Procedure?

  Hey, After my Stored Procedure has run, I need to call a https://site/blablabla.aspx file. Can this…

  Raymond van Laake

  2 replies

  11 years, 10 months ago

  By: Elliott Whitlow

• Check to see if multiple VALUES exsit in a table

  I know how to check for a sinle vlaue but how do I chekc to see if multiple values exist. I need to…

  Minnesota - Viking

  4 replies

  11 years, 10 months ago

  By: aaron.reese

• SQL - Does Geography Point In A Closed Polygon Problem (2nd try)

  Ok, Been chewing on this for several hours.. I have a closed polygon that coincidentally is in the …

  Elliott Whitlow

  1 replies

  11 years, 10 months ago

  By: Elliott Whitlow

• Query to find user who last modified user roles/access?

  Hello all- I was recommended to this site for all the wealth of knowledge and I was hoping ya'll co…

  DBANoobie

  3 replies

  11 years, 10 months ago

  By: DBANoobie

• SQL Geography Data Type - Test if Point is inside a closed polygon

  Ok, Been chewing on this for several hours.. I have a closed polygon that coincidently is in the sh…

  Elliott Whitlow

  1 replies

  11 years, 10 months ago

  By: Elliott Whitlow

• Error while executing a function

  SQL Fellows, I am getting one error below which says A SELECT statement that assigns a value to a v…

  swagh

  5 replies

  11 years, 10 months ago

  By: swagh

• Slow Query Issue...

  Hi All, I'm posting a query that is troubling me. The query is taking 3-4 mins and not exists …

  T.Ashish

  5 replies

  11 years, 10 months ago

  By: Gail Shaw

• Using Exec at insted of Linked servers

  I have a fairly long query that joins tables on residing on different physical servers. While using…

  Len-153367

  1 replies

  11 years, 10 months ago

  By: Andrew G

• SQL CLR Assembly

  We use a SQL assembly to make web calls. We have 1 assembly with a few dozen functions, all use web…

  dlevin

  2 replies

  11 years, 10 months ago

  By: Elliott Whitlow

• Issue with String concatenation need help please

  Dear friends, i have 8 fields - and I have requirement to concatenate using '+' operator with semi…

  dhananjay.nagarkar

  6 replies

  11 years, 10 months ago

  By: dhananjay.nagarkar

• SQLServerCentral is issuing a public apology to Itzik Ben-Gan

  Hi, Please be careful do real research, http://www.sqlservercentral.com/articles/SQLServerCentral/1…

  Lou

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• Returning Value fo Foreign Key

  I have a table tbl_rules. This table will define rules for each role. I have not yet defined the fi…

  tinausa

  1 replies

  11 years, 10 months ago

  By: Lowell

• Read XML data with related attributes/properites

  Hi Team , i have a table with one of the column of xml type. the column contains xml like given bel…

  kumar-378458

  2 replies

  11 years, 10 months ago

  By: kumar-378458

• Split string into Columns based on Special Character

  Hi, Can anyone help me get the required result in SQL 2012 Create table DBInfo (Path varchar (500))…

  ksrikanth77

  1 replies

  11 years, 10 months ago

  By: Ed Wagner