Viewing 15 posts - 6,421 through 6,435 (of 15,381 total)
No need to repost. The regulars around here will see your thread no matter what section you post in.
The original thread is here. http://www.sqlservercentral.com/Forums/Topic1507714-1292-1.aspx
October 23, 2013 at 12:39 pm
GilaMonster (10/23/2013)
The only thing I would suggest is give the column a better name. You shouldn't use reserved words or datatype names as column names
+100000000000
October 23, 2013 at 12:03 pm
What is the purpose of this? This seems like a very rudimentary method for scrambling your data slightly. Maybe if you could explain what the ultimate goal is we can...
October 23, 2013 at 12:02 pm
sumair.haider (10/23/2013)
I have not done the changes in Database so far but I was looking for any better option
What you posted worked fine on a dev database I have. If...
October 23, 2013 at 10:45 am
This is really pretty straight forward with pattern matching. It is generally considered best practice to post ddl and consumable data when asking for help. I created this for you...
October 23, 2013 at 10:21 am
Is what you have not working? Are you getting an error message?
October 23, 2013 at 10:10 am
Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1507706-2799-1.aspx
October 23, 2013 at 10:06 am
mxy (10/23/2013)
Create table dbo.UpdateDef( SourceTableName VARCHAR(100),ColumnName VARCHAR(100),Status_fl CHAR(1))
go
insert into dbo.UpdateDef values ( 'dbo.Src','NAME','Y')
go
insert into dbo.UpdateDef values ( 'dbo.Src','ADDRESS','N')
go
insert into...
October 23, 2013 at 10:04 am
On these forums you will find lots and lots of people willing and able to help. However, in order to help we will need a few things:
1. Sample DDL in...
October 23, 2013 at 9:10 am
josephmoka (10/23/2013)
Write a Stored Procedure utilizing a function that receives a LocationID and determines if the LocationID is an even oran odd number producing
This sounds like homework. We like...
October 23, 2013 at 8:19 am
Duplicate post. Please direct replies here. http://www.sqlservercentral.com/Forums/Topic1507634-3077-1.aspx
October 23, 2013 at 8:18 am
Any suggestion with update statement? how can i update the sample table with the out come of funtion returns table?
You need to provide us a bit more detail here. What...
October 23, 2013 at 7:39 am
nadarajan_v (10/22/2013)
Thanks, it worked perfectly!
You are welcome. Glad that worked for you.
October 22, 2013 at 2:25 pm
nadarajan_v (10/22/2013)
order by case when PurchaserID <> @LoggedIn...
October 22, 2013 at 2:15 pm
nadarajan_v (10/22/2013)
I have a purchase orders table, which stores PurchaserID among others. The table has thousands of rows with several hundred different PurchaserID. The PurchaserID is same as the LoginID...
October 22, 2013 at 1:32 pm
Viewing 15 posts - 6,421 through 6,435 (of 15,381 total)