This isn't a java or flash site. Try a forum that is dedicated to to that. Your issue has absolutely nothing to do with sql server.

CptCrusty1 (7/20/2012)

---

The proc runs fine when he feeds the Update statement a good value. It was in testing that he discovered the interested Error messages. Either way, I...

This is an xml file that is used to define your report. If it doesn't save before you preview, the preview will look like it did the last time it...

You could use APPLY but on a small dataset it isn't likely to make much (if any) difference. The execution plan is only slightly different than your subquery approach.

SELECT

CardID,

TranDate, x.MyRowCount

FROM...

You can't really nest transaction like that.

Here is a very simple example of what happens.

Here I will create a proc called CrashSproc. This proc will do what it's name implies...

Oops...

SELECT dbo.IIRPS_HPOO_LPAR.LPAR, SUM(MaxHeapSize) AS SumMaxHeapSize, COUNT(dbo.IIRPS_HPOO_IHS.LPAR) AS IHSInstances,

(SUM(MaxHeapSize) * 1.6) + (1024 * COUNT(dbo.IIRPS_HPOO_IHS.LPAR)) as OnlineMemoryCheck

FROM dbo.IIRPS_HPOO_IHS

inner join dbo.IIRPS_HPOO_LPAR on dbo.IIRPS_HPOO_LPAR.LPAR = dbo.IIRPS_HPOO_IHS.LPAR

inner join dbo.IIRPS_HPOO_JVM on dbo.IIRPS_HPOO_JVM.LPAR = dbo.IIRPS_HPOO_LPAR.LPAR

GROUP...

You should be using HAVING in this case. http://msdn.microsoft.com/en-us/library/ms180199.aspx

SELECT dbo.IIRPS_HPOO_LPAR.LPAR, SUM(MaxHeapSize) AS SumMaxHeapSize, COUNT(dbo.IIRPS_HPOO_IHS.LPAR) AS IHSInstances

FROM dbo.IIRPS_HPOO_IHS

inner join dbo.IIRPS_HPOO_LPAR on dbo.IIRPS_HPOO_LPAR.LPAR = dbo.IIRPS_HPOO_IHS.LPAR

inner join dbo.IIRPS_HPOO_JVM on dbo.IIRPS_HPOO_JVM.LPAR = dbo.IIRPS_HPOO_LPAR.LPAR

GROUP...

You're welcome. 😀

ifiusof?

You want to add a new column every day? Or do you want to change the default every day? Seems like it would be easier to do this in your...

This thread should help. http://www.sqlservercentral.com/Forums/Topic1013558-146-1.aspx#bm1013569

select *, OBJECT_NAME(fkeyid)

from sys.sysforeignkeys

where OBJECT_NAME(rkeyid) = 'YourMainTableHere'

DOH! Still using the deprecated version above....disregard and instead use this:

select *, OBJECT_NAME(parent_object_id)

from sys.foreign_key_columns

where OBJECT_NAME(referenced_object_id) = 'YourMainTableHere'

L' Eomot Inversé (7/20/2012)

---

sestell1 (6/25/2012)

---

I was always under the impression that there was no reason to create indexes on table variables because they exist only in memory.

Does anyone know what...

Probably looks like their indexes...fragmented all over the place....

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1332970-291-1.aspx