I need to develop a DDL that retrieves a value from a column of a table. However, when the DDL is executed on some databases, the column may or may not exist. My below code is not working:
...
Could anyone help me figure out how to perform these expressions in SSRS? They were originally in Crystal Syntax:
truncate({CHECKMAST.CHECKAMT});
replicatestring("0", 8 - length(totext(do...
Hi All,
I have the following transaction but when I run it it gives me an error which is as below:
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION state...
I am trying to get just a few columns from a SQL Server table using:
SELECT col1, col2, col3 FROM tablename
However col3 is actually "Badge #" (don't blame me - I didn't do the DDL!)
How...
Is there a way to view what servers / ad are already linked in SQL 2005
I created a strored procedure that creates multiple tables in MS SQL. When I open the procedure in Crystal, It only shows on table. The data it shows is from the first table out of the 8 table...
I have a pivot query, which is;
SELECT AttendanceDate, [C100] AS C1, [C200] AS C2
FROM (SELECT AttendanceDate, Derived_Provider
FROM OPA_G...
I'm partial to a tab size of 3 in the TSQL Query Designer. I've set it at 3 (SS1 - Tab Size.jpg). Yet, when I hit the tab key, the cursor only moves 2 characters to the right.
I have built a new server with 4GB ram, 2 Xeon E5410 cpu's on a Tyan Tempest I5400XT motherboard with 4 500gb harddrives set in a 0+1 raid format.
Access 2007 database in a solo physician cli...
Hi all,
I'm recreating an existing SQL 2000 database in a new SQL 2005 Express database, but when I try to create the following stored proc I get this error:
[4104] The multi-part identi...
Hi,
I am trying to install an application that installs SQL Express 2005 on a 2003 server. Whilst trying to install it an error saying...
installation package for sql server 2005 tools ...
Hello Experts,
I am extracting a The Date part only from a datetime column from a table like this:
CONVERT (VARCHAR(10), myDate, 101)
The resuling string looks like thes: 01/20/2009
...
Hi everyone
I need help with a complicated SQL Query
I'd like to do a UNION but add the results to the Second SELECT in new columns.
Here is the current Query :
Hello,
I am trying to find a list of accounts that have placed an order in over a month. Now this query will show me all the accounts that have not ordered, but I would like to also have th...
I have a table I am trying to run an update query on. But I only want records updated if a related record in another table has a specific value in the status field (I only want to update reco...
I have a query that I want to return results only when the value is false and not null.
Outside of a conditional for (x != 0 or x is null) is there a way to evaluate the following:
False...
HI.
My problem is as follows: I have two tables . Table A and Table B.
Table A contains names of persons with a person_id field. There are over 350 names in this table . --> person_id fiel...
hi
i have two fields
i want to make sure they are not equal
gameid not equal to gameidtwo
Hello all, ok I am going to explain this the best I can. I have a table called TransactionType. In this table I have the following fields and example records:
TransactionID Transa...
Refer to attached diagram.
In the execution plan, eager spool has the highest cost.
What is Eager Spool?
What does it do?
What can I do to reduce the cost of execution?
I have a SQL Server 2005 database Hosted at goDaddy on p3swhsql-v19...secureserver.net
I want to connect to this database using SQL Server Managment Studio Enterprise Edition. Is this possi...
I have a table like this.
customer- product- price - quantity
1 A 10 3
2 B 25 2
2 A 10 ...
I need to update a column depending on the order of another field. For instance, if columA is the lowest I need to update ColumnB to 1. There are multiple records for each account. So accountA...
I need to upgrade my hosting package and I'm being offered sql web 2008 much cheaper than sql 2005. Would my old sql 2005 db be ok to run on sql web 2008?
Hi Experts,
Need help w/ Sql script (this is for MS-SQL 2005).
Say we have two tables:
Regionid Region
-------- ------
1 West
2 East
3 ...
