dtopicdragovic (7/19/2012)

---

🙂

It is hard to explain and the process itself is very complicated.

More I work on it gets more confusing. :angry:

We want to show to our contacts what we have...

dtopicdragovic (7/19/2012)

---

I thought more in case when user deletes for example info in some specific field. Since I update just changed info into NeedApproval.Table, I wondered what I will do...

sqlfriends (7/19/2012)

---

Thanks, I know how to check collation from SSMS and code.

I cannot connect to this server somehow from other SSMS client.

And on the server itself no SSMS installed, there...

That would far too complex to automate. What if you are using new datatypes? What about table parameters?

We can help you rework it but you need to post the script...

A quick google search would be way faster for this type of thing. I typed "view collation sql server"...here is hit #1.

http://blog.sqlauthority.com/2007/08/30/sql-server-2005-find-database-collation-using-t-sql-and-ssms/%5B/url%5D

pdanes (7/19/2012)

---

Thanks, that also helped clear up some confusion about...

Celestial (7/19/2012)

---

here is the Structure of the Table

DescriptionNode(HierarchyID)StringPath

Manager0x /

Dev Manager0x58 ...

There are several ways you could handle this. One might be to change the ISNULL to check to a case statement.

Something like:

case when na.UserID is null then ui.FName else na.FName...

Check out Gail's blog post on catch all queries. This explains a couple of ways to go about this.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

dtopicdragovic (7/19/2012)

---

Do you think it is reliable to keep staging table (in your case UpdateInfo_NeedApproval table) in the same db as the production table (in your case UpdateInfo table)?

Our web...

Right click on the database --> Tasks --> Generate scripts.

This will bring up a script wizard. You can select everything in your database including all indexes, keys, constraints etc... You...

This should work but you have a couple issues. You said you want to load in batches of 10. You select top 10 but limit it to 5 rows with...

Well it is very unclear what you are trying to do here. Do you have these tables designed already? Can you post the ddl, sample data and desired results? I...

Mohammed Yousuf (7/18/2012)

---

I want to apply a range ( @fromvalue to @tovalue) to a column of type varchar.

lets say the column is ItemNumber

The ItemNumber can have both numeric and...

tacy.highland (7/18/2012)

---

Ok. So that kind of works.

I'm trying to build it as a matrix, with the route number as a row, and each 15 min increment (for the whole day)...