james.brown2 (9/17/2015)

---

Hi all

I have a query which has data injected into it, which is returned from a user defined function. This is very slow and I'm looking for a way...

Torin (9/17/2015)

---

2008 R2 Instance

SQL Server Logs show that a full backup is occurring on each database at 10:30pm every night.

We have a Maintenance Plan the does a full backup on...

rkelly58 (9/17/2015)

---

You are totally right, my mistake, if the exam finishes at 5, then I obviously don't want to include that in the next hour, doh

If the booking begins/finishes at...

In order to get and use the calculated average in subsequent columns, I decided to go with the "quirky update" method.

Edit: I hope that someone can come up with a...

Jason A. Long (9/17/2015)

---

Something like this???

IF OBJECT_ID('tempdb..#months') IS NOT NULL

DROP TABLE #months;

create table #months (

jan float,

feb float,

mar float,

apr float,

may float,

jun float,

jul float,

aug float,

sep float,

oct float,

nov float,

dec float);

insert into #months...

jghali (9/9/2015)

---

Hi all,

It's been a few weeks now that I'm getting calls from some clients due to a syntax error. I'm unable to reproduce the error. when they upgrade...

amar_kaur16 (9/8/2015)

---

hello Wayne,

Looks like I am missing records because I am interested in getting first follow up date but I am not getting next follow up date right after the...

sqlfriends (9/7/2015)

---

Second thought, I can see records that entered 2 months ago, pretty recent, and we did not change any schema, or drop constraints , disable contraints, etc. so still...

If you don't know this, then you have people with improper access to your database.

Gotta love how requesting the...

ramrajan (9/7/2015)

---

declare @table table (

ParentID INT,

ChildID INT,

Value float

)

INSERT INTO @table

SELECT 1,1,1.2

union

select null,1,4.8

union

select null,1,4.6

union

select 2,2,1.8

union

select null,2,1.4

union

select 3,3,1.12

union

select null, 3 , 56.7

union

select null,3,43.6

select * from @table

/*

This case ParentID - Child...

The proper way to enable a constraint so that it ensures that all data is consistent is:

ALTER TABLE <tablename> WITH CHECK CHECK CONSTRAINT <constraintname>;

If there is any data that doesn't...

chandrakant_gaurav (9/7/2015)

---

The code needs to identify the columns that have changed. This needs to be a part of a stored proc which receives single security ID as parameter and it...

Still confused by your requirements... 🙁

Is the...

DamianC (9/7/2015)

---

Hello

I have a table (folderstructure) with the following columns:

pcmid, cmid, foldername

pcmid is the parent directory

cmid is the directory

foldername is the name of the directory

e.g. note, number of levels are...

DataGuy (9/4/2015)

---

Hi Guys,

I need to create a function that replaces the data in a column with an 'X' based on the LEN of the data in the column....