SQL_Padawan_Learner (3/22/2011)

---

parthi-1705 (3/22/2011)

---

hi,

Have a look on this

declare @flg tinyint

Select @flg= case when cmptlevel=100 then 1 when cmptlevel=90 then 2 when cmptlevel=80 then 3 end

from master.dbo.sysdatabases

Select @flg

IF...

mtassin (3/22/2011)

---

Jeff writes great...

I cannot think of how you could know programmatically in T-SQL that the first one occurred...it's a popular topic right now though. Here is a related thread:

http://www.sqlservercentral.com/Forums/Topic1082102-338-1.aspx

As a side note...

Sorry, I misunderstood the original intent behind the question.

sku370870 (3/22/2011)

---

... are [Project 1] and [Project 2] hard-coded?

In the real data...

crazy4sql (3/22/2011)

---

if your database have enough free space then it will not affect performance.

But if your database almost full and then you increasing the space then you will see more...

It must have to do with how SQL Server handles data-type conversions internally. The rule surrounding converting character data to the NUMERIC/DECIMAL data type requires that there be either a...

Kindly provide the DDL and DML used to construct the environment in your example.

You can vote for an enhancement to add support for that:

http://connect.microsoft.com/SQLServer/feedback/details/339410/please-fix-the-string-or-binary-data-would-be-truncated-message-to-give-the-column-name

PIVOTs and cross-tabs change rows to columns. What you want is UNPIVOT, i.e. to change columns to rows.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

You have it good...

I wished many times that...

It's also known as the "double-hop issue" (winces, grits teeth)

The Agent tables are not my favorite thing in the world to dig through 😀 The way dates are stored, the lack of an easy way to find a job's...

Glad to help...now please use it to post some DML so we can help you with your solution 😉

Actually used in production:

- proc: access web services

- proc: accessing third-party address standardization software

- scalar function: use assemblies installed in local GAC containing proprietary encryption methods

- data type: IP address

Toying...

Please proceed knowing that this is not an SSMS / Query Analyzer issue.

Hopefully you will find the issue by checking these four things:

1. In DEV: Is there a table name...