SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Service Broker and Temp Tables

  Let's say that I have a stored proc that is assigned to a service broker queue and is constantly ru…

  TheGreenShepherd

  5 replies

  11 years, 2 months ago

  By: Dave Ballantyne

• How to default start / end date parameters to first / last day of current month?

  I have a SSRS report using 2008 R2. It prompts the user for the start and end dates. This all wor…

  bobh0526

  5 replies

  11 years, 2 months ago

  By: Alan Burstein

• Find locations with MAX sales amount per customer

  I have an invoice table with customer, date, sales location, and invoice total. I want to total the…

  jcobb 20350

  2 replies

  11 years, 2 months ago

  By: jcobb 20350

• How to get output based on sequential number

  Hi, The below data come from table table1. Instead of below result Ex1: I need output similar to th…

  rajkumar.r0212

  1 replies

  11 years, 2 months ago

  By: Sean Lange

• Logins or Users without any permission

  How to find thelist of logins/users who do not have any permission (except default Public) access.

  balasach82

  4 replies

  11 years, 2 months ago

  By: balasach82

• How to add a record when the data is not in the table

  I have a report that summarizes hospital readmissions. Some months may only have a female or male p…

  NineIron

  2 replies

  11 years, 2 months ago

  By: NineIron

• How To Insert 2 Values in 2 columns and rest Hello values in rest columns without using Create Table Statement

  Hey I am having a table say Test. Now i want to do is insert any two values in first 2 columns and …

  maria.pithia

  13 replies

  11 years, 2 months ago

  By: maria.pithia

• Run all stored procedures in a database

  Hi all I'm looking for an easy way to run all stored procedures in a database that match a specifie…

  richardmgreen1

  4 replies

  11 years, 2 months ago

  By: richardmgreen1

• Bizare Issue related to Log Shipping

  Hi I had Server A which shipping transactions logs to Server B, then applying them instantly to the…

  wak_no1

  2 replies

  11 years, 2 months ago

  By: wak_no1

• Deal with special chars - Trim?

  Hi I have some sql below.. SELECT t.Doctor, t.LedgerAmount, t.TransactionDate, ISNULL(lg.LedgerG…

  mattech06

  7 replies

  11 years, 2 months ago

  By: Stuart Davies

• Split single row into multiple rows based on column value (quantity)

  Deciding whether or not to use a CTE or this simple faster approach utilizing system tables, hijack…

  bugg

  1 replies

  11 years, 2 months ago

  By: Jeff Moden

• HOW TO ARCHIVE AND DELETE OLD RECORD IN A TABLE THAT HAS NO DATE COLUMN

  I have these two tables Log and CategoryLog, I need to archive records older than 13 months in thes…

  deebabat

  9 replies

  11 years, 2 months ago

  By: Jeff Moden

• Please Help Improve My While Loop

  I'm sure this is by far not the best way to do things, buts its been the only way I've worked out s…

  Byzza

  5 replies

  11 years, 2 months ago

  By: Jeff Moden

• Extract substring in SQL Statement

  I tried to extract the information in a field Samples of the data: "Current Date updated ( 12/31/20…

  Tamrak

  1 replies

  11 years, 2 months ago

  By: Jeff Moden

• ?? on Finding only fields that dont match in two different tables

  Hi I have two table People and Employee, both have firstname and lastname as fields I want to disp…

  jbalbo

  3 replies

  11 years, 2 months ago

  By: Luis Cazares