I have tried DB_DATE and DB_TIME, but both give me an error that the data was not converted due to truncation. I have set the error to "Ignore Failure" for truncate.
How can I get this "200...
A program I have been running on my SBS 2003 Standard Edition R2 for three years with an Access database went to a new version which uses SQL Express. This database is installed with the insta...
Good idea to set all FK to "NULL" at all times?
Reason I ask is, I have a problem, I cant save any data to my database, because when the database was created all PK and FK has been set to...
Hello to the sql server expert,
Pls advise, if there is a way to create a temporary table, resident in the RAM memory to accelerate calculation (save I/O access)?
Thank you,
Ygnd
I am attempting to join 2 tables where the FK can return many possible results. The transaction table has data like this:
TimeID, StoreID, Amount
1, 1, $100
1, 0, $125
The Store Ta...
I have the tried the folowing quey but it doesn't return any records when I know they are records in the database for yesterday.
SELECT CAST(DAY(AccTran.TransProcessDate) AS CHAR(2)) + '/...
When I first configured the server I used an email address as the "reply to" address of no-reply@mydomainmame.com. Then I setup a couple reports for email subscription delivery. They worked ...
i have a sql query that bulk inserts from a text file...i'm having problems with one of these columns defined as datetime. i would like to convert this column to just date. the original file i...
Hello Experts,
I am using the following code to assign a Date/Location to a unique IdentityNum:
update TableName
set
Date = @Date,
Location = @Location
Where IdentityNum IN(
sele...
I need write a query that queries all of the stored procedures in my custom table for the element "xp_send".
Hello all,
I have the following data: person, date, punchtime, location
Example set:
Person, date, punchtime, location
384, 10/1/2008, 10/1/2008 8:00, 180
384, 10/1/2008, 10/1/2008 12:3...
Can a SQL 2005 Standard database be restored to SQL 2005 Workgroup?
Hi Experts,
I need to write a dynamic query that'll take some input variables and return a recordset.
I'm finding this immensely difficult, the few successes i've had, have been ridiculo...
Does it possible
Open SQL Managment Studio with expanded object explorer, for some DB
(SUM(CASE WHEN ha.AllowanceCode IN('100','130','AL','BL','BL1','DL','JS','LD','LSL','MU','NWA1','SP','R','SL','SSL','ST','TOILT') THEN ha.FTEhours /
(case when e.employeecode = '1011' and cou...
In my Stored Proc, I have 2 Date parameters - @BeginningPayDate DateTime, and @EndingPayDate DateTime. These are used in Where Clause as - T7.prgPayDate BETWEEN @BeginningPayDate and @EndingPa...
I have a table containing many columns, the one of interest being called Title. Title's type is char(255). We are doing some maintenance and have come to realize that there's no reason for i...
SEO Question: If I use the URL www.MyWebsite.com/free-sound-effects/appliances/royalty-free-sound-effects.html and there are no free sound effects on that page, will Google sanbox me?
Basi...
I am creating a Linked Server using ASE 15 to Sybase. The field I am selecting is varchar(10). When we run the following query, it always returns len 10 when we only 5 char in the result.
...
i have added this line in my select stmt and it is cmoing back with the followign error, i am think that i have to round decimal to two digits in order to fix and need help with that please
...
we are using SQL 2000 server application to launch automated email and looking for the way to request smtp "return reciept" as well. please adise.
I am trying to suppress repeating entries using TSQL.
Here is the data
1 name1 title1 choice 1
1 name1 title1 choice 2
2 name2 title2 choice 1
2 name2 title2 choice 2
I woul...
I in the process of a massive migration with many dup users and dbs, which is always fun. When I look at the properties of a db ,via gui, I can look in the permissions section and see the use...
Hi
I have a sqlcmd script that runs a simple select query and outputs it to a .csv
However one of the fields rounds using
ROUND(dbo.KASSTRNS.KAS_BETRAG / 1.175, 2, 2) AS Expr2
Bu...
Hi All.
Have a nice day.
[strsql = "insert into messages(message,dated1,time,userid)]- This command is saving data in sql
I am not writing all code.
I want my users se...
