I'm trying to find a way to to migrate data that is in a DB already (MS Acces, although I can import it into SQL) in a different form. There is a name field that holds one or more names ins...
Below is the data set which I currently have by querying
UNIT NODE TYPE ACCOUNT SEQ
AA AB1 CON 677 1
AA AB1 ZBA 523 1
AA AB1 ZBA 504 1
AA AB1 STAND 555 2
AA AC1 CON 876 1
AA AC1 ZBA 4...
Just a side comment as it was unusual syntax for me. I noted in the inline views used in the solution by ee_rlee on the related question, that they were brackets used with a period []. versus...
How should we use the single quotes, double quotes while building the dynamic SQL having some contants, some keyword and some directory path.
hello there
i want to get the current date and then subtract minutes from it.how can i do this in sql server 7.my query is below .i want to put the subtracted date in place of '2007-07-12' ...
I want to create the same table from another table in my database. How do I write a sql statement to do a duplication of the table structure???
Hi,
I have an understanding issue here. The code block below uploads bulk data into my table but i need to forget the first line (header) in the tab delimited file.
Quite frankly, the sy...
Hi,
I have a stored procedure that need to execute a batch file which located on the SQL server folder. I do find a very useful command which can do this : master..xp_cmdshell. However, n...
I have a query that produces simple counts based on conditions; now I need to add a column showing the percentage of (totfree&reduced divided by totactive). Have had no success. Thank you for...
We have an orders table that has a field called "sold_date" and another field called "rep_id"
Over a one month time period we want to see the AVERAGE number of days between sold_date and th...
Hi,
Sorry I am new with MS SQL
I want to update the boolean field "CanDemand" in table MyTable where MyId = 1233
How do I do this?
Thanks,
HP
I need to update lngflexblance, lngflexrequested and lngflexremain in tblemployees with the amount that is in lngflexused in tblflex and I also need to set ysnrequested = 1. How I can do an ...
Using SQL 2000 how can I export the results of a SELECT to a comma delimited file? By default, the file is delimited by whitespaces.
when I am using this syntax:
select * FROM T_MAIN_REQUESTS
WHERE DR_sys_dt2 = '2008-01-03 00:00:00.000'
RESULT:1000 records
when I use this syntax
select * FROM T_MAIN...
Here's a tough one:
For the US among others the decimal symbol is a dot. Many countries, mine with them, is using a comma instead. Now, when performing an SQL query with a decimal number as a...
Hi Guys, I am converting Access SQL to SQL Server and I have two problems:
First of all I cant get the city, state and zip to concatenate. It will not take the "As Location" and it will not...
Using mySQL 5 I need help producing a SELECT statement. There are two tables:
checks.check_complete (INT1) set to 1 if complete
checks.check_date (timestamp)
check.check_ofc_oid (INT4) ...
We currently have a database that is searched using predefined keywords that correspond to specific columns. The search is very fast and accurate but is not very flexible. I have been tasked...
Hello,
I am still very new to Access so this question may be simple. I have a very basic query to select the top 5 records from a table - select top 5 drops from tbl_drops; This works great...
I have an extensive search page (ASP/SQL Server) which uses similar code to this - with many optional search parameters. I am trying to use only stored procedures to prevent sql injection atta...
I have an Access table that I want to run a query on to find out the records taht have two separate fields that do not contain the same data.
I have something like thism, but can not get it...
I need to put several (unkown 1 to 20) records of text together into one field in some sort of query. I have multiple records of exact same data except for one field and I need to join all of ...
I just got VS 2008 and I am trying to learn how to use LINQ in my projects, I have created a test project and attempted to use it to select from a List(OF String) My source code is attached, p...
I would like to use a single SQL statement to do the following:
If the digits in the last two positions of the string are 20, e.g. '200720', then I would like the value 'Spring' plus the...
I have a table entitled insurance_details_tbl that contains several float columns - I woult like to change all values in each column that are NULL to 0.
I have the below query (doing it col...
