What is the relationship between these tables? This sort of looks like a hybrid EAV. Do you have to look in the RefModule column in each table to know which...

The issue here is that I can't even come close to executing this on my server. There are a lot of missing pieces here.

Users

udf_GetMonthsInDateRange

Booking

Employee

MU_Employee_Department

Position

Department

MU_Attendee_Bookings

And Varchar(music)???

Probably the easiest way to get...

That is the backend, not the front end. Please take a look at connection strings.com. It provides examples for nearly every connection...

I am by no means a MySql expert. Can you import it from the MySql side? You may have to do a two step process. First export from sql to...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1458992-20-1.aspx

You don't need to split this to achieve the results you are looking for. All you need is a simple replace.

select replace(Name, '*', ' ')

julie 75341 (6/2/2013)

---

Hi - I have been trying to return the date diff value and keep getting an error saying:

character constant must contain exactly one character

This is what I am...

Well we can't really help too much. You...

Is it in an explicit transaction? If...

kiran.vaichalkar (6/1/2013)

---

Thanks Folks!!

2nd question is now addressed

an you also let me know what special we need to do to get the below executed correctly

SET IDENTITY_INSERT USERS.ID ON

Where USERS(ID INT PRIMARY...

The most straight forward way is to NOT store calculated data. You should just have to be calculated as you need it. AvailableSeats = InitialSeats - sum(RegisteredSeats).

The query you have...

kiran.vaichalkar (6/1/2013)

---

Hi Folks,

Please help me on below few queries

My table is

Users(ID IDENTITY(1,1) PRIMARY KEY, NAME nvarchar(10), MANGER_ID fk_User_id References ID)

1) now im trying SET IDENTITY_INSERT USERS.ID OFF

But...

seshagirikudaravalli (6/1/2013)

---

Msg 1105, Level 17, State 2, Line 2

Could not allocate space for object 'dbo.SORT temporary run storage: 141509403869184' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create...

I don't there is a choice of which is "best". The "first query" is not a single query, it is several of them. It depends on what you want as...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...