Viewing 15 posts - 316 through 330 (of 2,452 total)
ScottPletcher (11/3/2016)
SELECT
SD.NUMBERS
,RIGHT('0000000' + REPLACE(NUMBERS, '.', ''), 7)
FROM SAMPLE_DATA SD;
which I believe is what I posted earlier
CASE...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 3, 2016 at 11:59 am
maria.lindquist (11/2/2016)
The current value is of varchar(7) type.
ok, without you answering the rest of my question for expected results on various scenarios...here is shot in the dark :
CREATE TABLE #test(CurrentValue...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 3, 2016 at 4:11 am
maria.lindquist (11/2/2016)
How can I use SQL to remove a decimal from a field value.Current value = 1.66770
Correct value = 0166770
what datatype is "current value"?
what would you expect for Current...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 2, 2016 at 3:47 pm
camiloecheverry11 (10/19/2016)
SELECT item_location_view.item_id AS 'Item',
item_location_view.item_desc AS 'Description',
inv_mast.class_id1 AS 'Brand',
item_location_view.location_id AS 'Location',
item_location_view.qty_on_hand AS 'Qty on Hand',
item_location_view.qty_allocated AS 'Qty Allocated',
item_location_view.qty_on_po...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2016 at 1:28 pm
why are you using ">$0" ...ie the $ sign?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 12:26 pm
what have you tried so far?
from you brief details maybe
SELECT a,
b,
c
FROM sometable
WHERE(a >= 0)
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 11:54 am
Aquilagb (10/19/2016)
I have a SQL query which works fine and returns 10 columns and one row of data. What I would like is to pivot this data so that...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 10:40 am
are you able to post the .sqlplan rather than the word doc please?
what does your "dbo.function" perform?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 9:40 am
WendellB (10/19/2016)
J Livingston SQL (10/19/2016)
I think you have to set up the the RI in the SQL Server environment, not via your Access FE.....I may be wrong though
You are correct...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 8:39 am
andrew gothard (10/19/2016)
SELECT REPLACE(REPLACE(REPLACE(CAST(CONVERT(VARCHAR(19), GETDATE(), 120) AS VARCHAR(10)),'-',''),':',''),' ','');hth
SELECT CONVERT(VARCHAR(10),GETDATE(),112)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 7:07 am
possibly ??
WITH cte AS (
SELECT Date,
Amount,
ROW_NUMBER() OVER(ORDER BY date) - DENSE_RANK() OVER(PARTITION BY amount ORDER...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 6:52 am
I really dont follow your question....can you please expand and explain.
and to help all of us help you....here's how to post sample data
CREATE TABLE #yourtable(
id ...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 6:20 am
ChrisM@Work (10/19/2016)
BLOB_EATER (10/19/2016)
Brandie Tarvin (10/19/2016)
ThomasRushton (10/19/2016)
rodjkidd (10/19/2016)
ThomasRushton (10/19/2016)
In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."at which point I lost the plot.
are you...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 5:09 am
I think you have to set up the the RI in the SQL Server environment, not via your Access FE.....I may be wrong though
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 19, 2016 at 1:39 am
one way maybe...??
CREATE TABLE #Counter
(CKey INT,
CA INT,
CB INT,
CC INT,
CD INT,
CE INT
);
INSERT INTO #Counter
VALUES
(1, 2, 3,...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 15, 2016 at 2:31 pm
Viewing 15 posts - 316 through 330 (of 2,452 total)