laercionb (5/15/2014)

---

sorry me

is having words in English that use the google translator so it was pointless.

I want to create a scale of employees

exist words in English that...

This looks like you have views joining to views which are joining to views. Nesting views creates some of the worse execution plans.

In order to help we need a...

Let's replace the whole looping concept and do this in two steps. The first step is to create the date values as rows in CalDates. Since everything else is all...

Try this link and see if it helps.

http://msdn.microsoft.com/en-us/library/office/aa831024%28v=office.10%29.aspx

BWAHAHAHAHA!!!! That sets the value...

pdodgson (5/15/2014)

---

Hi,

I am currently in the process of writing an INSERT/UPDATE trigger in SQL 2012, the scenario is, I have a table called Quote, what I want to happen is...

If anybody else wants to see this code with some formatting...

CREATE TABLE CalDates (

MonthID INT IDENTITY(1, 1)

,MMDDYYYY DATETIME NOT NULL

,MonthStart DATETIME

,NextMonth DATETIME

,MonthDescr CHAR(6)

,MonthNam CHAR(3)

,YearMonth INT

,MonthNum INT

,DayNum INT

,IsBusinessDay CHAR(1)

);

DECLARE @MMDDYYYY DATETIME

,@MonthStart...

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...

marko.celarc (5/15/2014)

---

Hi everyone

I've a problem with a SP, running slow, even though there is a return statement at the beginning of the SP. (I put it there for testing purposes)

for...

jshahan (5/15/2014)

---

Thank you, Luis. You are the only one to respond so far so I am pretty sure I have posed a "toughie" to the team. Yes, a...

alicesql (5/15/2014)

---

Here is some INSERT code that is being flagged with a syntax error. I suspect the problem is further up the line:

INSERT INTO [dbo].[CalDates]

...

laercionb (5/14/2014)

---

let's see if I can explain:

Type want to do a range of staff.

then have a table of date where I want to create a table where the...

laercionb (5/14/2014)

---

create a table using the value of a variable

example:

create uspCreateTable

@ NameTable varchar (10)

the

begin

create table @ NameTable (

id int,

Name varchar (20))

end

the...

Kudos on the attempt at posting ddl and sample data. However, the sample data is unusable because the insert statements are all invalid. Secondly, you mention in your query TagValue...

jdasilva (5/14/2014)

---

Sean Lange (5/6/2014)

---

jdasilva (5/6/2014)

---

How does SQL get the value of the variable from the form in access?

In the example I am working on, I am polling the data for...