General

• Topics

  Started by

  Posts

  Last post

• Looking for Suggestions from the pros

  I am buiding a site with many products and i have a FARLEY good grasp on the BASIC understanding ab…

  BuilderBits

  17 replies

  4 years, 5 months ago

  By: curtains and blinds Dubai

• Using the ROWGUIDCOL attribute on primary key

  Hi! I'm using unqiueidentifiers as my primary keys for all tables with a default value of NEWID(). …

  jonashilmersson

  8 replies

  4 years, 10 months ago

  By: Sean Lange

• Rename a text file, move it, using a stored procedure

  I have a stored procedue that BCP's data into a table from a file called ImportData.txt in a direct…

  texpic

  17 replies

  5 years ago

  By: ggavin 64175

• Full Outer Join with all rows

  Hi Everyone, I have the following Table A and Table B. I tried doing a full outer join in Tableau s…

  louislsh

  3 replies

  5 years ago

  By: MVDBA (Mike Vessey)

• Trying to Sum by different levels

  Hello everyone, If any one could please help me with this? I'm trying to add additional sum by Fami…

  louislsh

  9 replies

  5 years ago

  By: louislsh

• count number of days between two dates excluding weekends for a particular month

  Hi guys, got a conundrum here that i'm pretty sure is possilbe but can't get my head around. I have…

  chenks

  14 replies

  5 years, 1 month ago

  By: Steve Collins

• Web page listing SQL code

  Hi, I'm building a web page for my users that will list example SQL scripts but would like to retai…

  EamonSQL

  5 replies

  5 years, 2 months ago

  By: EamonSQL

• Where is the Forum FAQ?

  Where can a forum user find the FAQ or details on how to perform forum actions like deleting a post…

  YSLGuru

  1 replies

  5 years, 2 months ago

  By: Sue_H

• Using MSXML2.ServerXMLHTTP within Stored Procedure To Grab Source of HTML Page and save to table

  I'm trying to use 'MSXML2.ServerXMLHTTP' though extended store procedures to retrieve the html sour…

  smhunt

  8 replies

  5 years, 3 months ago

  By: sreenatht

• Select and update statement

  Kindly assist on the below query 1. Convert all old data (without _N) to _OLD. Example, 000015 to 0…

  bb004938

  6 replies

  5 years, 5 months ago

  By: DesNorton

• Best Work from Home training najafgarh

  Some work from home jobs require a bit of skill, experience, or credentials while many of the other…

  ParminderSingh

  1 replies

  5 years, 7 months ago

  By: Jeff Moden

• Trying to group 2 rows into a single line

  Hi all, i am stuck trying to group 2 lines into 1. Hope someone could guide me in the correct direc…

  louislsh

  2 replies

  5 years, 8 months ago

  By: DesNorton

• Unable to group 2 records into a single line result

  Hi all, i am stuck trying to group 2 lines into 1. Hope someone could guide me in the correct direc…

  louislsh

  1 replies

  5 years, 8 months ago

  By: ktflash

• SQL question about grouping

  Hi, i am a newbie in SQL and today i hit an issue where the data can't group. I know im doing it wr…

  louislsh

  3 replies

  5 years, 10 months ago

  By: louislsh

• Split string in sql server 2000

  How to split string in sql server 2000 suppose i have a string  Like this  ---- <TD&g…

  Sandeep Mahajan-393729

  9 replies

  5 years, 11 months ago

  By: Spartan89