Andy I'd try removing the XML declaration during testing (<?xml version="1.0" encoding="utf-16"?>). It maybe that SSMS doesn't use UTF-16 for its editor. It...
4800
Andy Mills
photonormal
Apr 9, 2012 9:31 pm
I am working on a bug for my current project and tracked down the issue to a column having the wrong size. We have dbo.Products.ShortDescription set to...
4801
John Warner
john@...
Apr 10, 2012 9:02 am
Andy, I'm sure someone can post better but: http://blog.sqlauthority.com/2007/05/25/sql-server-stored-procedure-to-dis ...
4802
Andy Mills
photonormal
Apr 10, 2012 12:21 pm
Thanks John From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of John Warner Sent: Tuesday, April 10, 2012 5:02 AM To:...
4803
Damhuis Anton
antondamhuis
Apr 12, 2012 12:54 pm
My simple solutions would be the script the whole database, and then run through the script file with the editor, and find all references to the column. But I...
4804
Charles Carroll
charlesmarkc...
Apr 12, 2012 2:17 pm
http://www.speedferret.com/speedferret.html rocks for all databases. ... [Non-text portions of this message have been removed]...
4805
Andy Mills
photonormal
Apr 12, 2012 2:41 pm
Charles: I thank you for the link but have to ask if this product is still supported? When I look at the system requirements:...
4806
Charles Carroll
charlesmarkc...
Apr 12, 2012 2:45 pm
No idea. It was a great product pre-SQL Server. RedGate and Embracedero probably have that capability or should. As to support you may want to ask them. They...
4807
Noman Aftab
noman17pk
Apr 15, 2012 7:12 pm
Try this: SELECT sysobjects.name, REPLACE(syscomments.text, 'CREATE PROC', 'ALTER PROC') FROM sysobjects INNER JOIN syscomments ON sysobjects.id =...
4808
Andy Mills
photonormal
Apr 22, 2012 12:53 am
Thanks Norman From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Noman Aftab Sent: Sunday, April 15, 2012 3:12 PM ...
4810
Andy Mills
photonormal
May 9, 2012 6:58 pm
Hello Everyone: I am wondering if someone could help me with a SQL issue. I have table called "Profile". This is a self-relating table. It has the following...
4811
Andy Mills
photonormal
May 9, 2012 10:05 pm
Hello Everyone: For the life of me, I can't get this case statement / ISNULL function to replace the NULL values (please note: I took out a bunch of the...
4812
Arnie Rowland
arnie1568
May 9, 2012 10:43 pm
The simple minded question that I pose, and I hope you will excuse my simple-mindedness, are there rows where the p.[FirstName] column IS NULL, or does it...
4813
Arnie Rowland
arnie1568
May 10, 2012 5:48 am
If you can locate on the interweb a copy of the Northwind database for SQL Server, you will see how the Employees table self-references. Normally, you would...
4814
Andy Mills
photonormal
May 11, 2012 12:35 pm
Arnie: Here is the entire SQL Statement: SELECT r.RoleName, ISNULL(p.FirstName,'') as 'FirstName', ISNULL(p.LastName,'') as 'LastName', m.Email, am.UserName, ...
4815
Andy Mills
photonormal
May 11, 2012 12:58 pm
Arnie: I think I got this working. Thanks for the help as it pointed me in the right direction. Thanks Andy From: Andy Mills Sent: Friday, May 11, 2012 8:34...
4816
Mark E
meckeard2000
May 12, 2012 9:23 am
Arnie is correct about the subselect - it can only return a single value. That may be an issue unless the code you removed changed it in such a way that it...
4817
John Warner
john@...
May 12, 2012 9:44 am
I can't speak for all nor for the OP but null can cause procedural code to have an issue, null isn't a string or char array and thus will need conversion....
4819
Mark E
meckeard2000
May 12, 2012 2:09 pm
Coalesce is ansi standard whereas isnull is t-sql and could go away in the future. Mark Sent from Yahoo! Mail on Android From: John Warner ; To: ; Subject: RE:...
4820
Noman Aftab
noman17pk
May 14, 2012 4:42 pm
Hi, I have a varchar column which contains a formatted datetime in 'yyyyMMddHHmm' format. For e.g. '201205142050' represents 14 May 2012 08:50 PM This column...
4821
Paul Livengood
p_livengood
May 14, 2012 4:56 pm
because you are not everything in the column is not a date and your date format is not a SQL Standard you will need to test for a DATE and convert using...
4822
Noman Aftab
noman17pk
May 14, 2012 6:35 pm
Thanks Paul, Since this query has to be run for just for value at a time..inside a udf, your solution is pretty much accepted.  Best Wishes, Noman Aftab  ...
4825
John Warner
john@...
Jun 20, 2012 8:54 am
I have two tables TableA and TableB TableA TaskNbr varchar(25) , EmpID varchar(10) TableB TaskNbr varchar(25) , Respond varchar(10) Respond and EmpID are...
4826
Farhan Ahmed
farhan_4_love_u
Jun 20, 2012 9:28 am
Hi John, Try out this solution... I hope this will work for you.... Declare @T Table (TaskNum Varchar(10),EmpID varchar(10)) Declare @T2 Table (TaskNum...
4827
ksekha
Jun 29, 2012 3:06 am
Hi all, thanks for accepting me in the group.. my query is below, for x in (select table_name from all_tab_cols where owner = 'xxx') loop select column_name...
4828
chetan
caj_y
Jul 1, 2012 5:05 pm
... ===================================== The error means your statement "select column_name from all_tab_cols where table_name = x.table_name" is fetching...
4829
John Warner
john@...
Jul 1, 2012 6:17 pm
Might want to repost this to an Oracle list instead of an SQL list since your issue is specific to PL-SQL. John Warner ... expecting ... where ... to...
4830
kharkasi@...
ksekha
Jul 2, 2012 1:47 pm
Thanks much Chetna , could you the code how to create cursor Sent from my iPhone ... [Non-text portions of this message have been removed]...
4831
Dermot
dermotduke
Aug 1, 2012 10:14 pm
Hi, I have a table (menu_items) that is meant to represent a nested data structure for a menu (HTML select, option and optgroup). I've tried to adapt a...
4832
Mark E
meckeard2000
Aug 1, 2012 10:50 pm
A subquery isn't optimal but this may work for you: SELECTÂ mi1.id, mi1.menu_id, mi1.parent_id, mi1.label, Â Â Â Â Â Â Â Â Â Â Â Â (select COUNT(*) from...
