Microsoft SQL Server Forum

I am writing a stored procedure and have a temp table that is dynmaic in size when it executes. I want to loop through each row in the temp and take a value from a column and then append that value in a varaible that would hold each value from all the rows. I am having trouble doing this. I can see the values, however, I get null for my return. ...

Trying to setup my laptop as a development base for PHP. Details are as follows: Windows7 x64 SP1, SQL Server 2008 R2, (EasyPHP instalation) PHP 5.4.6, Apache 2.4.2 SQL Server is running fine as can read data using C# (in Visual Studio) PHP is running as can read data from the mysql db that comes with it.

Hi , While I am trying to import a .txt file from Linux server , I am getting this error - "The specified header or row delimeter "{CR}{LF}" is not found after scanning 65536 bytes of the file".. In the linux server I can see the file , open it and can download it to my local windows box as well. what could be the problem ?

i have deleted once sql server 2005 from control panel and from all programs also then i reinstaling thq sql server 2005 at that time i m getting error the message shows like"software is installed already" what should i do pls give me details

SELECT DISTINCT broker, COUNT(case when cntsze=20 then cntsze end) as '20', COUNT(case when cntsze=40 then cntsze end) as '40', COUNT(case when cntsze=45 then cntsze end) as '45' FROM CYMgps WHERE ( sysdte BETWEEN '2012-11-01 00:00:00' and '2012-11-30 23:59:59') GROUP BY broker ORDER BY broker asc

What would be a quick way to allow users to connect to sql server 2008 server or express editions no matter their username, password, windows group or domain? My app is been installed from various accounts and i am forced to create the same username and password, or windows group. I don't have such power on the users who are going to work with...

All, I am new to creating scripts to run on SQL. My goal is to create a script that allows me to query one table for an "id" value and then run a delete statement on another table to delete a row. These are the SQL commands I run manually and I would like to automate this so I don't have to get into SQL MGMT Studio each time. select id...

Hi Everyone, I'm running a delete statement to remove millions of records in a table on a live environment in full recovery mode. Because of the amount of transactions the delete is sure to create, I decided to run the operation in batches of 250000 records each. In order to control the size of the transaction log, I've also scheduled a job to...

Hi, how do I write this in sql script. I want to count the records from two or more joined tables and place the result in a new table. Attached is my tables. Thanks. http://bytes.com/attachments/attachment/6809d1357733881/count_sql.jpghttp://bytes.com/attachments/attachment/6814d1357788796/updated_tables.jpg

encrypting coloumn ..hiding password charecter use CRM create table h1 ( uname varchar(20) null, pwd varchar(20) null, varbinary(200) null )

I am running MS SQL Server 2008. I frequently need to manually run a large quantity of query files at a time. I need to log the results of the queries to a file without having to enter a new file name with each query executed. I wanted to automate the running of the batch of queries through the OSQL command specifying an output file, but...

OK, using SELECT I can view a database record from one of my tables, but now that I can see the selected record I notice that the first name, for example, is spelt incorrectly, and I wish to manually correct this mistake. Using transact SQL how do I, or can I, instruct SQL Server Management Studio that I wish to make specified column editable. I...

I have two different source locations. One has a file share assoicated with it and it works, the other is a UNC path to a NAS device and the file cannot be found. When I cut paste the XCMD to a dos window it works. Is there something related to the location, device, share that causes it to fail when running in XMDShell .

Hello out there here i am having difficulty in fetching the Brands Per ctegory in the sidebar of my website Here is the description .. I am using the feeds and feed uploader to upload feeds and create brands and Product categories in wordpress The Problem is there is No link Within the Product_category and product_brand and i want too show...

Hello. I want to ask for a question. I have a software which uses MS SQL database for storing data, i have to deploy this software different machines for different clients. The question is how can i protect my database so that no one even the administrator of the server or the machine administrator can view my database structure or the...

Hi, I have this working fine from a mysql database. I am trying to use it from a sql server 2008 database but cannot get it working, just error 500. Does anyone know how the driver info might have to change or is there anything else in the code that might be mysql specific? Thanks for any help in advance Richard the connection strung that...

Hi, In SQL clustered tables (B tree), pages are linked in all levels by doubly linked list. Already the index is pointing to the corresponding pages then why we need the doubly linked list between pages? Any help is appreciated. Thanks in Advance, Malathi

can we use "contains" as filter condition under where clause for a Date Field?if yes please give me example?if no please give me any alternate option?

I want add a number to a text value and have it appear in output. Original value column Extension is a text that I want to add 2100, but I want to have it output to a text. Using Northwind database, table Employees: Select (E.EmployeeID) as 'EmployeeID_ab', (E.Extension) as 'Extension_ab'

I've closed all SQL Server service except the MSSQLSERVER, and have set that service to startup in single user mode by using the -m switch in the Configuration Window. However, when I tried to login using the "sa" account" a dialog box popped up telling me that the service was in single user mode and only one Administrator could login. I am...

I am trying to create a data extract report in report builder 2.0 in sql 2008. I developed the report on my server in report builder 3.0 (2008R@) and it ran fine. I duplicated the report in report builder 2.0 and it executes through all the records but only displays the first one in the report. My data source is a stored proc.

Hey ALL, I have the following table-valued functions that works well if I pass its arguments with literal numbers or from declared variables. USE GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON

I am having a problem for which I have done numerous online searches but have not yet found an answer. I hope someone can help with it. SQLServer 2008r2 on Microsoft Windows 2008r2 There is a stored procedure which runs nightly. I did not write the stored procedure and I do not have the right to change it. Here is what the stored...

Hi, I have a small problem of the following Tables, I have MyTable1 (for example) and I want to attach content of following MyTable2 to MyTable1, but MyTable2 have the Data just 1 week ago, and it should be in appropriate columns against that columns in MyTable1, pl tel me what can I do? MyTable 1 : Id_Date Id_Branch NewBalance...

Ben, Hi, First of all, here are my work tools : I have an Access 2003 app that uses an SQL Server DataBase (i know it's weird). I am using Microsoft SQL Server Management Studio Express. I am now trying to execute a query from my app to insert some rows from 2 tables into another. My query works well when i use it rigth into SQL Server...