mw112009 (3/11/2016)

---

Nice syntax...

I was just playing with the SQl and ran the following

exec sp_MSforeachdb 'SELECT top 1 ''?'' As DatabaseName FROM [?].sys.tables '

However it only listed about...

this will work:

if the database name shows up, it has a table with that name:

exec sp_MSforeachdb 'SELECT ''?'' As DatabaseName FROM [?].sys.tables WHERE name = ''ClmRejRept'' '

Previous place i worked at had a code base like that, created by an offshore team.

There was only a project manager, and no onsite developer reviewing the code produced, so...

I never had to do this, but i found this interesting!

i found a good article on SQLTips called "Transferring data from SAS to SQL Server and back":

https://www.mssqltips.com/sqlservertip/2659/transferring-data-from-sas-to-sql-server-and-back/

so if you don't...

a calculated column cannot have an if statement; you canuse a CASE though

something like this is what i think you wnat:

SET QUOTED_IDENTIFIER ON

ALTER TABLE Schedule ADD

[SubmitDate] AS

CASE

WHEN REVIEWDueStatus=10 AND...

I think it's a going to take a good rewrite and step back from trying to modify the existing, and just join these three tables together, and trim off any...

i'm pretty sure that all third party dlls have to be registered in the Global Assembly Cache(GAC) as it's not enough to just have the dll's in the folder, when...

there's nothing in your procedure that requires a cursor, let alone a cursor/while/cursor triumvirate of looping constructs.

In the end, you populate a #Results table, and return the results.

while the rewrite...

i've done something similar, but i just add the items together, and test for greater than zero; my query is assuming cost is a positive value, never negative, is that...

szejiekoh (3/7/2016)

---

Lowell (3/7/2016)

---

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and forwards...

i am definitely under the impression that procedures/functions/packages have to be hand edited, as there's no specific set of rules to convert them;

the migration assistant is fine for tables and...

i think State 16 means the default database assigned to the login does not exist. it might have been dropped or renamed.

change the default database of the login in question...

The SQL Browser service has to be running on the server in order to do that;

that service keeps track of what port SQL is running on, and forwards requests to...

here's one way to do it:

DECLARE @xml XML ='<Item>

<Item customerid="101" customername="Ram" gender="Male" married="Y"/>

<Item customerid="102" customername="Sham" gender="Male" married="Y"/>

<Item customerid="103" customername="Tom" gender="Male" married="N"/>

</Item>'

select

...

Thanks mister magoo! what tool did you use that helps you identify case sensitivity issues like that?