Tuesday, December 11, 2018
AUSQLUG Forums Home   Search   Login   Register   Member List  

  Viewing User Profile for: RyanCaleb
 About  Contact
Joined: 13 Sep 2017 09:38 PM
Last Login: 08 Nov 2017 11:16 PM
Location: Unavailable to anonymous users.
Occupation: Unavailable to anonymous users.
Interests: Unavailable to anonymous users.
Email: Unavailable to anonymous users.
MSN IM: Unavailable to anonymous users.
AIM: Unavailable to anonymous users.
Yahoo IM: Unavailable to anonymous users.
ICQ: Unavailable to anonymous users.
 Post Statistics
RyanCaleb has contributed to 66 out of 2,726 total posts (2.42% of total).
Most Recent Posts:
HELP - Build new stucture from recordset 11/8/2017 11:20:50 PM   (Total replies: 0)
Hi guys, I have the following task and I am looking for the best solution from performance perspective. I use MS SQL 2008R2. The task: there is a recordset with the following columns: ID, level, ParentID, LabelText For instance (recordset of table1): 1, 'D', null, 'Main 1' 2, 'D', null, 'Main 2' 3. 'C', 1, 'Sub 1' 4, 'C', 2, 'Sub 2' 5, 'B', 4, 'SubSub 1' I would like to create the following table/recordset (table2): LabelText (D), LabelText (C), LabelText(B) Main 1 Main ...

only alphabat show 11/8/2017 11:19:32 PM   (Total replies: 0)
hi, my data is like this SalesPerson aw.ab998 11abb.ia aa 111a i want data looks like this SalesPerson awab abbia aa a i want to remove numbers and dot through query thanks for the help I didn't find the right solution from the internet. References: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=200706 [url=https://blog.advids.co/20-brilliant-advertising-campaign-video-examples/]Advertising Campaign[/url]

how to connect to ms-sql server with joomla 10/18/2017 12:15:02 AM   (Total replies: 0)
hello everyone, I have started to learn about joomla a couple of weeks ago and now i have reached the part where i need to some how create a connection to my database. I don't have any real experience in programing, so please be as clear as you can. My website is working with a ms-sql server (2005) project and i have already installed joomla 1.5.22. Thanks I didn't find the right solution from the Internet. References ...

WinCC 6.2 & SQL Server 2005 10/18/2017 12:14:04 AM   (Total replies: 0)
I Have some problems to install Step 7, WinCC & SQL server 2005 into a Laptop O.S. Windows XP Professional ver 2002, SP3, also in the same computer i have already installed RS logix 5000 v.17. the installation crashes while i was trying to install SQL Server 2005 as a requirement to install WinCC v.6.2, i have try several times, but no progress... i just receive a message wich says that installation can not continue, nothing specific why... Thanks I didn't find the right solution from the ...

Hosting SQL Instance 10/18/2017 12:12:48 AM   (Total replies: 0)
Hi All, Very much a newbie to the whole SQL/Cloud/Web scene so apologies if anything below appears a bit 'dim'! To cut to the chase, we provide an application to client's up and down the country to which the application stores all of it's data within an SQL Database which by default and where possible we install SQL Express on our client's Computer or Server when possible and we then install our application onto a number of the client's computer's depending on how many people need to access ...

Populate Blank Rows, How? 10/18/2017 12:10:42 AM   (Total replies: 0)
I need help on how to solve this predicament that I’m facing. The customer data that I’m dealing with comes in Excel files. The customers are divided according to location where they are but that is not populated in all the rows. Before I explain my question further, please refer to the below table to understand.What I would like to achieve is to populate the blank rows under the column Location. Any advice on how I can do this. Everything which comes after “Location_A” should be “Location_A” ...

low identity value inserted 10/16/2017 10:00:50 PM   (Total replies: 0)
I have a table that has an identity on it. There are many people and apps that hit this table. the value increments as normal most of the time, but every now and then, we get a low value, as if someone uses and identity insert or reseeds it and it causes issues. So, I'm trying to find out the user that may be doing it. I set up a trigger (this is a non-prod env) to log if a new value is used lower than the max value and it logs to a staging type table. I got a hit and asked the user what they ...

Edit data in database in excel 10/16/2017 9:59:10 PM   (Total replies: 0)
When I have the data in Excel I would like to be able to edit the data in Excel instead of having to RDP to the SQL server and open the database in management studio. Can anyone tell me how this can be done? Thanks I didn't find the right solution from the Internet. References ...

SQL Server 2000 Personal Edition 10/16/2017 9:58:02 PM   (Total replies: 0)
One of my clients has an application that only requires “SQL Server 2000 Personal Edition” (the new versions of SQL are not supported). Tried going to Microsoft’s download center to get “SQL Server 2000 Personal Edition”, but all I found were the service packs. I also talked to the client about getting an updated version of the application he is using, but it is not cost effective. Does anyone know where I can get/buy a copy of “SQL Server 2000 Personal Edition”? Thanks I didn't find ...

sql server 2000 with ruby on rails works? 10/16/2017 9:55:51 PM   (Total replies: 0)
I'm trying to use Ruby on Rails accessing a pre-existing database on SQL Server 2000. After some research I found that it should use the gem activerecord- sqlserver-adapter. Create a connection via ODBC to the desired base, and creating a database user for access it. Thanks I didn't find the right solution from the Internet. References https://www.ruby-forum.com/topic/1257776 [url=https://blog.advids.co/20-awesome-b2b-marketing-video-examples/]B2B Video Marketing[/url]

Search for more...