Viewing 15 posts - 1,651 through 1,665 (of 4,820 total)
First order of business... why are you using varchar(23) to store dates? Given that you are using ANSI PADDING turned on that only affects those columns, that just isn't making...
March 27, 2018 at 9:53 am
Hi All,
I'm trying to populate a temp table. Here is the temp table:CREATE...
March 27, 2018 at 9:43 am
March 27, 2018 at 9:22 am
I don't see any reason to break this up at all. One table is sufficient to hold a given address. Just the extra query complexity of having a separate table...
March 27, 2018 at 9:01 am
One thing you are doing that might cause trouble is the CONVERT(varchar(7), [pkKPIID]) portion, which will fail on any value of the pkKPIID column that is greater than 9,999,999 or less...
March 27, 2018 at 6:39 am
March 27, 2018 at 6:22 am
Wondering if it might be useful to use sp_msforeachdb, which is an undocumented stored procedure that can do that kind of thing. You use ? in your query wherever you...
March 22, 2018 at 9:48 am
I'm pretty sure what you want is a view:CREATE VIEW NBCVadodra
AS
SELECT Tstamp, Inverter_id, AC_Power, total_energy_generated_till
FROM [dbo].[IN-023C-I1]
UNION ALL
SELECT Tstamp, Inverter_id, AC_Power,total_energy_generated_till
FROM [dbo].[IN-023C-I2]
UNION ALL
March 22, 2018 at 9:38 am
March 20, 2018 at 2:30 pm
March 20, 2018 at 2:20 pm
March 20, 2018 at 2:17 pm
Replication is the Microsoft way to do this. Not that there aren't other ways, but you might need to somehow ensure that the session established by the trigger actually ends...
March 20, 2018 at 2:08 pm
Sorry, but I doubt anyone has any idea what you are looking for. Could be a language barrier problem, but a fairly clear English explanation is needed here. The words...
March 20, 2018 at 12:43 pm
March 20, 2018 at 6:56 am
Viewing 15 posts - 1,651 through 1,665 (of 4,820 total)