Hi-
I am using the SAS v8
I want to know if I can use poc SQL for date additions i.e. I want to add 365 days to a start date and creat a enddate. Can I use the normal formart MMDDYYYY + 365...
i get error message when i try to run my Sql script in my win app form.....
i get exception message saying thath:
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.
...
I would like to create job or sp that clears data from a table called dbo.mytable and the DB is called TEST.
I can do so manually but i would like to automatic this, here is what i run to c...
Hi there,
I think that posting the SQL error would help really... so here it is:
27/8: lmsulk: End of illegal lock count dump --------------
--------------------------------------------...
The database I'm using contains a table called OPERATION. Among other fields in that table, it contains ACT_RUN_HRS, RUN_HRS, and WORKORDER_BASE_ID. What I would like to do is copy the data ...
I want to turn/rotate certain information that are displayed in joined rows, so they will become extra columns in the query output.
To illustrate this problem, I have set up an example in w...
What is better...
To save my pdf files in my SQL database as binary data or ...
Save pdfs on my file server and save only the file location in my SQL database?
I am currently running SQL 2000 Standard SP4 on a windows 2003 box. I add another instance. SQL 2000 SP4 Enterprise edition, and it installs the instance, but as SQL 2000 Enterprise Edition RT...
Hi,
I have an indexed CHAR field that is fully populated in the YYYYMMDD format and is used as the basic date range for reports. So, "select a,b,c from tablex where dt_field >= '20081014' " ...
I have 2 MySQL databases and i want to make one single from them.
The data must not be replaced and also not duplicated.
For example:
BD1:
1. John
2. Kevin
3. Sandra
4. Alex ...
Hi,
How to search ignoring the dot.
SELECT*
FROM Contact
WHERE Phone LIKE '%7842131%' COLLATE French_CI_AI
The result is
021 / 784.21.31
Thanks !
I have been migrating users over to a new domain and they have been connecting to the Timberline server fine. But now that I moved the Timberline Server to the new domain the users cannot con...
What is the procedure for installing SQL security updates on an active/passive SQL 2000 Cluster? I don't want to fubar the cluster. If I update it on the live node will the other node be updat...
I have installed BCM on my local PC all working fine I have imported and converted my ACT DB into BCM as I cant stand ACT agian all working fine, now I want others to use the BCM so i want to ...
when trying to login to sage construct Advanced it asks for username and password, when you click ok it says it is trying to connect to the database and then comes up with attached error. trie...
Hello all,
I'm in need of online Inventory, Invoice, and Shipping Software. For instance, for the inventory part I would like to be able to control inventory and have it update automaticall...
I have 2 tables one has the Last Name Deffner in its columns and the other has Deffner JR in its columns. How can I make a table Join from Deffner to Deffner JR?
