Viewing 15 posts - 9,916 through 9,930 (of 15,381 total)
Of course even the thing you just posted can't possibly take into account complex things. What about a cte in a proc that has a where statement and the value...
November 29, 2012 at 12:37 pm
srik.kotte (11/29/2012)
SET @sql = ' USE ?; SELECT ''?'' AS DATABASE_NAME,
sys.schemas.name AS [Schema Name], sys.objects.name AS [Object Name] , ...
November 29, 2012 at 12:31 pm
valeryk2000 (11/29/2012)
Sean, I'm silly, you are right. Sorry, it was a long day ...
No problem. Sometimes it just takes a new set of eyes looking at it. 😛
November 29, 2012 at 12:26 pm
Nice job posting ddl and sample data along with desired output. However it is totally unclear what the logic should be here.
This looks somewhat like an adjacency list except it...
November 29, 2012 at 12:25 pm
valeryk2000 (11/29/2012)
SELECT UniqueIDSystem
,FullLastFirstName
,Position PositionOrig
,case Position
...
November 29, 2012 at 12:20 pm
It will most likely take some manual manipulation to get only those that have that column in the where clause. Keep in mind that you are dealing with varchar data....
November 29, 2012 at 12:13 pm
I am trying this but not working properly.
What you have looks like it should work. Not sure what you mean by not working. You did mention that you want to...
November 29, 2012 at 10:17 am
davas (11/29/2012)
November 29, 2012 at 10:01 am
You might want to take a look at RedGate SQL Search.
November 29, 2012 at 9:59 am
dba_pkashyap (11/29/2012)
What is the data type of txtsupply and what are the actual values it holds?If its a string then your destination column should also be string else integer!
Pavan.
The OP...
November 29, 2012 at 9:57 am
davas (11/29/2012)
Just wondered why the sp_spaceused...
November 29, 2012 at 9:47 am
sonal_anjaria (11/29/2012)
is there a system level field that get updated for a table every time a row is updated?
Not sure what you are looking for here exactly. There is nothing...
November 29, 2012 at 9:44 am
adonetok (11/29/2012)
What...
November 29, 2012 at 9:43 am
SQLCrazyCertified (11/29/2012)
How can I achieve...
November 29, 2012 at 9:20 am
Viewing 15 posts - 9,916 through 9,930 (of 15,381 total)