Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Logic to check for empty table before joining

  Hi All, I have a requirement which requires me to display report as per the dimensio…

  Anjan Wahwar

  6 replies

  7 years, 10 months ago

  By: Aalam Rangi

• Stored proc with variables

  Heloo, i have a problem with the follow storedprocin my VB program i have a lot of tables with SQL …

  benny 52509

  7 replies

  7 years, 10 months ago

  By: benny 52509

• Looking to match up balancing records

  I have a view that is similar to the following one but with hundreds of records I need to find…

  rodrigueznestordavid

  3 replies

  7 years, 10 months ago

  By: Sean Pearce

• DELETED

  DELETED

  wakedog

  4 replies

  7 years, 10 months ago

  By: subramaniam.chandrasekar

• Views based on Multiple tables causing Locks?

  Hi, I have recently started at a new company and the way they have some data set up is as follows:D…

  ash.blair

  5 replies

  7 years, 10 months ago

  By: Gail Shaw

• DOES COLLATE DATABASE_DEFAULT CAUSE PERFORMANCE ISSUES AND HOW DO I GET AROUND IT?

  I am updating an existing SP to point to a different database created outside of my control.&n…

  carolyn.foster

  3 replies

  7 years, 10 months ago

  By: subramaniam.chandrasekar

• Assign incrementing letters to same value

  hi all, i have the following table OrderID   PointOrder1    1    …

  Talvin Singh

  7 replies

  7 years, 10 months ago

  By: Talvin Singh

• Format of result

  Hi all, im trying to do something, but have no idea how to acief this. Here part OF the DATA i'm wi…

  mikeaspnet

  5 replies

  7 years, 11 months ago

  By: drew.allen

• Automated XML file

  I was given this code from a vendor to export customer data from our ERP system into their system. …

  durocshark

  3 replies

  7 years, 11 months ago

  By: subramaniam.chandrasekar

• SQL Server: Loop Thru Semi-colon Delimited Lists and Perform Partial Matching

  ###Business Problem: I have a list of users and attributes that apply to the users (stored in user …

  kbsvgty90

  1 replies

  7 years, 11 months ago

  By: pietlinden

• Slow running query

  Hi, I am trying to get some counts and it's running really slow. Any help would be really appreciat…

  danny 35405

  5 replies

  7 years, 11 months ago

  By: danny 35405

• Find out all the tables with VARBINARY column

  Hi,Is there any way that to find out all the tables which include a VARBINARY type column? Thanks,

  yujinagata72

  6 replies

  7 years, 11 months ago

  By: ScottPletcher

• Duplicating nodes for xml path, combine child nodes

  Hi, I'm sorry if this post is a little long, I am trying to include only relevant information. Curr…

  lancerhnj

  3 replies

  7 years, 11 months ago

  By: jonathan.crawford

• If an INSERT fails, does the sql that follows still run? (is my code unreachable?)

  We have a stored procedure as below, which inserts a record, then checks @@ROWCOUNT to see if it wa…

  Rob

  4 replies

  7 years, 11 months ago

  By: Rob

• Performance when Inserting into nvarchar vs varchar

  Hi A stored proc was running v.slow. The problem was select fieldlist into #t from myview Time take…

  terry999

  4 replies

  7 years, 11 months ago

  By: TheSQLGuru