Search results for query: *

I have a matrix report with Theatre Name as the row and grouping on the theatre name. The columns are items like candy, popcorn, drinks, food etc. The problem is that not all theatres have all the items so when it gets to say Ice Cream some theatres there is no Ice Cream column and then the...

THANK YOU markros, I've been searching the web for HOURS trying to figure this out. thank you again!

(CASE WHEN @Group = 'Amstar' THEN ('1562', '1564', '1565', '1566', '1567', '1568', '1569', '1570') WHEN @Group = 'Grand' THEN ('1552', '1553', '1554', '1555', '1556', '1558', '1560', '1563') END) same error

Thanks, but I've been trying every variation of a case statement including using one case statement like you said and two and neither works??? When I change it like your example I get the same error???

I'm stumped on this one and it seems simple enough but it just isn't working. I've tried using an if statement with no luck either. I don't care which as long as it works. WHERE ti.TheatreId in (CASE WHEN @Group = 'Amstar' THEN ('1562', '1564', '1565', '1566', '1567', '1568', '1569', '1570')...

I figured it out, thanks

This is a totally new router and my first cisco router. We had a 870 that my predicessor setup just before he left. Some bad weather came through and ZIPPPP all kind of stuff is toast including the 2 month old router. I used the CLI Excel template from the 870 for the 871 and it's working fine...

Thanks, I've added them to the correct ACL list but it's still not working. Any other ideas? ip access-list extended Internet-inbound-ACL remark SDM_ACL Category=17 permit icmp any any echo permit tcp any eq ftp any log permit icmp any any echo-reply permit icmp any any traceroute permit...

I'm trying to allow remote desktop connections from the internet on a cisco 870 router without success. I set the access control list to wide open for udp just to see if that's the problem and I know I should secure it better but that was just for testing. I've natted port 3389 to the server's...

I have a table that gets written to every time there is an inventory transaction. I need to write a report that returns the last record for a given fiscal period, either the current period or a period in the past. I want only one record per location, type, product and costid of the fiscal period...

You guys are soooo wonderful. It works!!! Hurricane Katrina made me change jobs and I went from Healthcare to a Lumber Import/Exporter. They do hardwoods, flooring, decking, plywood in just about every unit of measure. We're upgrading to the latest version of the inventory software and there...

Sorry for not posting some data, I'm new to this! I'm sorry I wasted your time but in looking through the data I forgot about the milimeters. I do appreciate all the quick answers! 08 10 10 11 11 12 12 8 3/8 8 3/8 04 04 04 04 04 04 04 04 04 04 142M 142M 142M 142M 142M 142M 142M 142M 142M 142M...

Thank you thank you thank you. But one more thing, it's saying and invalid parameter has been passed and I think it's because the field can be blank. Can you return nothing if its blank? Thanks again, Sarah

Yes but without any punctuation other than the slash.

That works great for the lengths since they are integegers but what the widths are numbers like 4 3/8"? Thanks

THANKS!

Thanks Dennis but the field contains the lengths as numbers like 10 or 12. I'm not trying to get the length of the data in the field but an average of the numbers in the field.

Hopefully this is an easy one. I'm trying to get an average of a length field but the field is varchar(8). This is my query: SELECT AVG(CONVERT(varchar(8), pcslength, 0)) AS AvgLength FROM tag_detail GROUP BY tagnum The convert doesn't seem to be working. Is there another way to do...

SELECT TOP 100 PERCENT product, loc, protype, ohvolumequantity, MAX(histseq) AS Expr1 FROM dbo.pro_itm_hst GROUP BY loc, protype, product, ohvolumequantity, histseq ORDER BY loc, protype, product, histseq The first product, I only want the second row: Using group by and MAX this is...

This is my query: SELECT product, loc, protype, ohvolumequantity, histseq FROM dbo.pro_itm_hst ORDER BY loc, protype, product, histseq Every time the inventory is changed a history record is writting into this table to reflect the current on hand quantity. The first three fields are...