helal.mobasher 13209 (9/30/2015)

---

my related question is although number of days in each week is rather consistent (6) if we expand the year from 2014 to 2020, but number of weeks...

luissantos (9/30/2015)

---

Hello comunity

I need to build an update query for all my article beginning with '0.%' for my varchar field refkey, but depending on some conditions.

For example.

Case st.base <> ''...

Luis Cazares (9/29/2015)

---

Do you mean something like this?

CREATE TABLE CharsTest(

myvarchar varchar(10),

myNvarchar nvarchar(10),

myLvarchar ...

Graeme Martin (9/29/2015)

---

You CAN, however, build an update VIEW that includes an INSTEAD OF TRIGGER, allowing you to update more than one TABLE from the CTE through the VIEW, based...

Yeah, the moment I got the error I was afraid of that. Darned inconvenient. I'll use the OUTPUT clause instead and do a second update. Thanks!

mbrady5 (9/28/2015)

---

I am interested in selecting certain tables to query from based on age of request.

Ex. If a person wants to query data that's > than 60 days old,...

eric-silva (9/25/2015)

---

Hi there,

I have to increment sequencial values for the following:

Current Data

Col1 Col2 Col3

12.345.678 0001 ...

andyc209 (9/25/2015)

---

Really need some help on this one - i need to generate documents for customers to sign automatically as sales staff enter their data into SQL. These are invoice...

Gazareth (9/24/2015)

---

sgmunson (9/24/2015)

---

Still looking for guidance, if anyone has any, with regard to exactly how to go about determining what pages belong to a specific table, and then being able...

Still looking for guidance, if anyone has any, with regard to exactly how to go about determining what pages belong to a specific table, and then being able to see...

Sean Lange (9/23/2015)

---

sgmunson (9/23/2015)

---

Gazareth (9/16/2015)

---

Don't envy you this task, sounds like changing a database collation but less fun!

I'd be fighting hard to change columns to built in datatypes rather than...

Gazareth (9/16/2015)

---

Don't envy you this task, sounds like changing a database collation but less fun!

I'd be fighting hard to change columns to built in datatypes rather than new/modified user defined...

Thanks Kristen and Scott. I now have the information I need. Based on what we now know, and some other things that have changed in the...

Glad you were...

Neil.McKinnon (9/16/2015)

---

Hi Guys,

I have a strange issue with an SSIS package whereby it is putting in an incorrect file name somehow. The package creates a number of .csv files and...