| Author | Message | ||
Driverramudu Hero Username: Driverramudu Post Number: 14935 Registered: 02-2009 Posted From: 166.137.246.32 Rating: N/A |
Gagu It should work If your shift times are different than you should replace Them in that query. I analyzed thoroughly and wrote query for More than a day and more than one shift per day. Better u give exact requirement and sample data to my email I would write exactly and you can make use it directly Again why do U want integrate Driving is my PASSION. Ball or Bimmer does not matter. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 56983 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
req enti ante...rojoo oka 1 mil rows load chesthaaru...vaatini vada katti endabedithe oka 500 rows data vasthundhi...adhi daily summary snapshot annatlu....from daily detailed snapshot | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 56982 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
0 results vasthunnayi...also one calendar day aithe work avutundhi gaani naa scenario 2 shifts....1 from 7 AM to 7 PM and the next shift is 7 PM to next morning 7 AM...aaa second shift calcuate avvatledhu | ||
Abhysg Megastar Username: Abhysg Post Number: 26463 Registered: 08-2008 Posted From: 209.133.66.6 Rating: N/A |
bulk insert (from a flat file) sesede snapshot data kada..malle snapshot enduku..? data changes untaya..? usually snapshots eod untay kada | ||
Sannayi_nokkulu Side Hero Username: Sannayi_nokkulu Post Number: 4863 Registered: 06-2014 Posted From: 68.100.234.172 Rating: N/A |
nee kalmoktha raa.....  deal all those issue outof db.. dxnnmadma db lo kottuknntunri.....santakam | ||
Abhysg Megastar Username: Abhysg Post Number: 26461 Registered: 08-2008 Posted From: 209.133.66.6 Rating: N/A |
trigger can work only for insert/delete/update.. not for bulk load or truncate.. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 56981 Registered: 10-2009 Posted From: 107.77.94.22 Rating: N/A |
after truncate and bulk insert | ||
Nakhral Junior Artist Username: Nakhral Post Number: 79 Registered: 11-2012 Posted From: 69.47.30.180 Rating: N/A |
I think we should have trigger only..because it has to be automatically rigger as soon as table loaded. Stored proc ayithe we cannot trigger autotmatiaclly unless schedule for every 5 mins and check the status for other table data | ||
Abhysg Megastar Username: Abhysg Post Number: 26456 Registered: 08-2008 Posted From: 166.137.240.16 Rating: N/A |
Snapshot before truncate? Or after? Backup style lo before truncate ayite "select * into sales_11022015 from sales" next truncate table sales Next bulk import into sales from c:\sales.txt Next select into sales_11032015_10am from sales Annee oka sp lo eskovachu.. trigger avasaram led | ||
Driverramudu Hero Username: Driverramudu Post Number: 14928 Registered: 02-2009 Posted From: 76.95.174.87 Rating: N/A |
nkamma truncate ki trigger antu ledu btw ninna updated query ni integrate sesukonnava all appies or any more doubting of usa Driving is my PASSION. Ball or Bimmer does not matter. | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 56980 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
but naaku table reload avvagaane snapshot kaavali? elaa how? | ||
Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 31836 Registered: 02-2009 Rating: N/A |
https://msdn.microsoft.com/en-us/library/ms189799(SQL.90).aspx Although a TRUNCATE TABLE statement is in effect a DELETE, it cannot activate a trigger because the operation does not log individual row deletions use an sp to copy before truncate | ||
Siloan Legend Username: Siloan Post Number: 43511 Registered: 03-2008 Posted From: 132.174.20.41 Rating: N/A |
SP | ||
Sachin Legend Username: Sachin Post Number: 39986 Registered: 04-2008 Posted From: 208.78.147.194 Rating: N/A |
asalu trigger deniki....truncate and load munde aa snapshot copy chesko... | ||
Gandhiguevara Legend Username: Gandhiguevara Post Number: 56979 Registered: 10-2009 Posted From: 204.61.207.7 Rating: N/A |
Ippudu oka table lo daily truncate and reload chesthaaru...every time aaa table truncate and reload ayinappudu inkoo table loki snapshot based on some logic load cheyyaali... Motham SQL lo ne elaa cheyochu? |