Viewing 15 posts - 3,526 through 3,540 (of 8,731 total)
You have your logic inverted
SELECT OBJECT_NAME(referenced_major_id) AS referenced_object_name
,COALESCE(COL_NAME(referenced_major_id, referenced_minor_id), '(n/a)') AS referenced_column_name
,*
FROM sys.sql_dependencies
WHERE object_id = OBJECT_ID('YourStoredProcedureNameAndSchema')
ORDER BY referenced_object_name, referenced_column_name;
January 19, 2016 at 11:49 am
river1 (1/19/2016)
When I try to use that I get empty back. No records returned
Can you post the code that you're using?
January 19, 2016 at 11:38 am
Here's the approach that I would take. Note that I changed the pivot to cross tabs. The reason behind this is that it will perform better as you only read...
January 19, 2016 at 8:53 am
johnwalker10 (1/17/2016)
SELECT column_name(s)
FROM table1
RIGHT OUTER JOIN table2
ON table1.column_name=table2.column_name;
Try to read the question before posting and, if possible, the previous posts. Also test code against sample data and compare it to...
January 17, 2016 at 10:09 pm
Ed Wagner (1/16/2016)
I've never seen the technique produce inaccurate results. Can you provide an example of where it screws up? I'm incredibly curious.
I've seen it happen once when...
January 16, 2016 at 9:32 am
Some options:
- You're missing an alias,
- You have a space where you shouldn't,
- You're missing a comma,
- If you're using dynamic code, the single...
January 15, 2016 at 11:26 am
Grumpy DBA (1/15/2016)
Wonder if Ramsey scored a goal...
January 15, 2016 at 11:21 am
Orlando Colamatteo (1/15/2016)
guy 1966 (1/15/2016)
Ok, I finally found what I neededUPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'.gif','');
UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'','');
Thank you!
@guy1966, I am not sure why you insisted on getting an...
January 15, 2016 at 10:41 am
Another option.
SELECT *
FROM #tb_1 t1
JOIN #tb_2 t2 ON t1.SKU1 LIKE t2.SKU2 + '-__'
January 15, 2016 at 10:09 am
RayMan007 (1/15/2016)
Luis, Thank You!! 😀
Make sure that you don't need an additional condition on your join to get a backup date for each database instead of one per server.
You might...
January 15, 2016 at 9:17 am
arkiboys (1/15/2016)
Eirikur Eiriksson (1/15/2016)
arkiboys (1/15/2016)
Using the foreachloop I loop through excel files to get the filename andthen start loading the data into sql server using oledb...
1- I get the...
January 15, 2016 at 8:06 am
How about doing something like this:
SELECT ch.ServerName,
ch.DatabaseName,
ch.DbId,
ch.error,
ch.MessageText,
...
January 15, 2016 at 7:51 am
A possibly bad idea is to change an option in your PK index. Specifically IGNORE_DUP_KEY.
This will prevent errors from happening when inserting duplicates to a table, but will also hide...
January 14, 2016 at 2:32 pm
SQLRNNR (1/14/2016)
amn't (ask Steve about that one!)
ain't (nobody got time for that)
January 14, 2016 at 2:25 pm
Considering that you're working with SQL 2000, an option could be using a scalar function. I'm not sure that the order will always work, but it's an option.
CREATE TABLE tblNOTES(
...
January 14, 2016 at 2:19 pm
Viewing 15 posts - 3,526 through 3,540 (of 8,731 total)