Viewing 15 posts - 8,326 through 8,340 (of 26,490 total)
KoldCoffee (3/25/2013)
SELECT name, type_desc...
March 25, 2013 at 2:20 pm
When EZ9999 incrments to E0A001, what happens as E0A999?
March 25, 2013 at 2:08 pm
Getting there, but still don't know how this table is being used, what column is being used to provide info for the transaction.
Why don't you try explaining the entire process.
March 25, 2013 at 2:06 pm
I prefer his:
create table #TestData (
LabName varchar(32),
LabNo int
);
insert into #TestData
VALUES
('MICROSOFT VISUAL STUDIO .NET',101)
...
March 25, 2013 at 1:50 pm
Nope, still no actual explaination as to how these parameters are used or updated. Just keep repeating what it is you want to do even if it is wrong.
March 25, 2013 at 1:39 pm
abitguru (3/25/2013)
Lynn Pettis (3/25/2013)
March 25, 2013 at 11:16 am
pjuster (3/25/2013)
I have a database called databaseA with a table called, otherdbs with two columns
server databasename
server1 parts
server2 parts
I would like a query that...
March 25, 2013 at 11:07 am
Actually, I don't think you do. Instead of working to keep others from reading/updating a particular parameter row (again, not sure how you are using this), you should be...
March 25, 2013 at 11:05 am
Sean Lange (3/25/2013)
DarthBurrito (3/25/2013)
Sean Lange (3/25/2013)
declare @Time time = '09:26'
select @Time
Now you have...
March 25, 2013 at 10:58 am
raym85 (3/25/2013)
if you always know the len of the extnetion this should work as well without being so taxing.declare @string varchar (100)
set @string = 'x:\folder1\folder2\folder3\test.txt'
select SUBSTRING(@string,1, LEN(@string)-8)
Probably not a...
March 25, 2013 at 10:54 am
Not exactly sure how you are using this table, but you should limit the time that a record is locked to as short a time as possible. Users attempting...
March 25, 2013 at 10:44 am
kevaburg (3/25/2013)
Sorry Lynn.....it was aimed at the original poster....
Hard to tell just from the comment. It is apparent that this was some sort of college project.
March 25, 2013 at 9:01 am
Pulivarthi Sasidhar (3/25/2013)
CREATE Proc usersbyLocation(@locids varchar(max)=NULL)
AS
BEGIN
Declare @str varchar(max)
SET @str='SELECTUserID,
UserForename,
UserSurname,
LocationName
fromtUser JOIN
tLocation on tUser.locationID=tLocation.LocationID
Where tLocation.LocationID in ('+@locids+')'
PRINT @locids
Exec (@str)
END
--Test
--Exec usersbyLocation '1,2,3,4,5,6'
Look above, no dynamic sql required.
March 25, 2013 at 8:48 am
kevaburg (3/25/2013)
March 25, 2013 at 8:39 am
patrick.palmer (3/25/2013)
The filed has multiple dates in it. The 20050307 was just an example. Now all the dates say 2005-03-07???
The following was showing you a way to convert a date...
March 25, 2013 at 8:32 am
Viewing 15 posts - 8,326 through 8,340 (of 26,490 total)