Viewing 14 posts - 331 through 345 (of 345 total)
Although this will cause an error if more than one row is updated. You could change
SET @Last_Login_Date = (SELECT Last_Login_Date FROM inserted);
to
SET @Last_Login_Date = (SELECT TOP 1 Last_Login_Date FROM...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 12, 2011 at 4:21 pm
Try this:
change
IF EXISTS
(SELECT 1
FROM inserted
WHERE user_id = 'bbsupport')
to
IF NOT EXISTS
(SELECT 1
...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 12, 2011 at 4:08 pm
This should help:
http://msdn.microsoft.com/en-us/library/ms190766.aspx
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 12, 2011 at 2:12 pm
something i whipped up:
create table A (col1 int, col2 int, col3 int, col4 int)
create table B (col1 int, col2 int)
declare @field_list varchar(max)
--set @field_list = ''
;with cte as
(select column_name, data_type...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 12, 2011 at 10:11 am
Jeff Moden (1/6/2011)
toddasd (1/6/2011)
declare @a varchar(100)set @a = 'Number of files=4'
select substring(@a, 17, len(@a))
:blink:
To me, looks like he wanted the "4" from the string. So, you know, taking a shot...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 6, 2011 at 7:18 pm
Is it considered cheating that I went to the BOL before answering the question and read "If two or more rows tie for a rank, each tied rows receives the...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 6, 2011 at 12:37 pm
then lets make it a proc:
create procedure updatetable
@a varchar(10),
@b-2 varchar(10),
@c varchar(10)
as
update whoknows
set col1 = @a, col2 = @b-2, col3 = @c where rowID in (1,2,3,4,5)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 6, 2011 at 12:13 pm
declare @a varchar(100)
set @a = 'Number of files=4'
select substring(@a, 17, len(@a))
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 6, 2011 at 11:53 am
according to your specs, this is what you need:
update whoknows
set col1 = 'MMADAS', col2 = 'HHFASD', col3 = 'HGGOI' where rowID in (1,2,3,4,5)
🙂
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
January 6, 2011 at 11:38 am
CELKO (12/29/2010)
sa.ordekci (12/29/2010)
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
December 29, 2010 at 3:18 pm
Actually no. I had to go back in my files and look, but it's the one that uses the tally table.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
December 28, 2010 at 8:53 pm
You could also use the split function and get a list of all the folders:
SELECT * FROM dbo.fn_Split('/folder/folder1/folder2/12345-ABCD.txt','/')
WHERE IDX = 3
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
December 28, 2010 at 1:30 pm
Some sample data and DDL please.
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
December 28, 2010 at 8:26 am
Thanks for the response.
Right-on about the schemas. Out of 607 total, 3 are used. I'm still suspect though, I don't want to removed unused schemas like db_owner, db_accessadmin, etc. I'll...
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.
December 13, 2010 at 11:49 am
Viewing 14 posts - 331 through 345 (of 345 total)