ahmed_elbarbary.2010 (2/13/2015)

---

Hi guys I have problem i need to make ERD relation entity

between employee and allowance

Employee table

Name

address

Basic Salary

Bonus

Allowance table

House rent

Food Allowance

Moving Allowance

Basic Salary is monthly and fixed

Bonus is...

bkshn (2/16/2015)

---

Hello

I have a date file with no delimiter like bellow

0080970393102312072981103378000004329392643958

0080970393102312072981103378000004329392643958

I just know 5 first number in a line is for example "ID of bank"

or 6th and 7th number in...

Why not query sys.tables instead of maintaining you own list of tables? There really is no...

OK. I will post and not ignore that huge white elephant over there in the corner.

Your code has some very major performance problems. You have a cursor. Then inside your...

Hi and welcome to the forums. 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...

jcobb 20350 (2/13/2015)

---

I have an invoice table with customer, date, sales location, and invoice total. I want to total the invoices by location by customer and see what location sells...

Hi and welcome to the forums. 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...

I prefer them at the beginning so you can just remove a column from the query with...

This is called deferred name resolution. Here is some MS documentation on this behavior.

https://technet.microsoft.com/en-us/library/ms190686%28v=sql.105%29.aspx

Lynn Pettis (2/11/2015)

---

Sean Lange (2/11/2015)

---

Lynn Pettis (2/11/2015)

---

Sean Lange (2/11/2015)

---

Stubby Bunny (2/11/2015)

---

Hi,

I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I...

Velveeta22 (2/11/2015)

---

Unfortunately this query is the only part of the transaction that I can grab. The rest is buried in .NET code that I do not have access to....

Lynn Pettis (2/11/2015)

---

Sean Lange (2/11/2015)

---

Stubby Bunny (2/11/2015)

---

Hi,

I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I get records but it...

Stubby Bunny (2/11/2015)

---

Hi,

I have tried all of that, but nothing returns with the Top 1 clause, if I take that out I get records but it multiplies them cause of...

Without some details it is impossible to help. This isn't even the complete statement as there are variables at the very top. There is also nothing here that is in...

And make sure you rebuild your indexes on that table if you shrink the file, they will horribly fragmented.